Distance and online learning Excel courses

...so you can be assured that the material is high quality, accurate and up-to-date." On receiving your request, one of our stuff members will call you... Learn about: Office Admin, Microsoft excel training, Microsoft Excel...

...(profit and loss) on your profit and loss statement and Balance sheet Depreciation model which I have prepared for the course is quite robust and takes... Learn about: Fixed Assets, MS Excel, Tax Returns...

...highly interactive and dynamic GUI. Bookmark Management System - You can bookmark important lessons to watch them again. Self-assessments with instant results... Learn about: Ms Office, Office IT, How to use Excel...

...number formats Using functions to format text Working with styles Working with themes Other advanced formatting Outlining and subtotals Outlining and consolidating... Learn about: Office IT, Ms Office, MS Excel...

...million rows of data visually on Bing maps in 3-D format from an Excel table or Data Model in Excel. Discovering data insights: you will gain new understandings... Learn about: Ms Office, Sales Training, Data exploration...

...for:Anyone interested in finance, accounting or related fields Identify key elements in building interactive dashboard with clickable buttons for detail... Learn about: MS Excel, Financial Reporting, Financial Training...

...& Replacing Empty Values Sorting Data Sorting Multiple Columns Filtering Data Lesson III USING FORMATTING TECHNIQUES 22:45 Formatting Numbers & Dates Formatting... Learn about: Pivot tables, Tables & Formatting, Excel Productively...

...We’ll also encounter examples of using formulas to build formulas; mega formulas, sometimes dozens of lines long, which would be very hard to write manually... Learn about: Nesting VLOOKUP, Optimizing Lookup, Excel Formulas...

...so you'll know the exact steps for your own projects. Course Fast Facts: Only 18 hours to complete this course 260 tutorial videos Expert instructors... Learn about: Database training, Microsoft Excel, MS Excel...

...which is up-to-date and easy to understand. This course is comprised of professional learning material, all delivered through a system that you will... Learn about: Office IT, MS Excel, Office Assistant...

...(prior to Office 2007), then there are a lot of features and changes you need to be aware of to fully utilize this software. Chapter I: GETTING COMFORTABLE WITH EXCEL... Learn about: Simulations & Solver, MS Excel, Pivot tables...

...Creating a sparkline. Editing and auditing formulae to ensure they are delivering accurate calculation results. Sorting and filtering data to display pertinent... Learn about: MS Excel, Selecting cells, Pivot table...

...learn how to develop a whole new appreciation for the information in your spreadsheets and gain insights into what it might mean. You’ll also learn how to create Pivot Charts... Learn about: PC training, Database training, MS Excel...

...as well as use other auditing tools Create and work with charts Create Pivot Tables and Pivot Charts Record and run macros Solve formula errors Use... Learn about: MS Excel, Database training, IT Auditing...

...Validation rules Clearing existing Data Validation rules C. Conditional Formatting Understanding conditional formatting Managing Conditional Formatting... Learn about: Conditional Formatting, Pivot Reporting, Tables & Formatting...

...learning led by IAP, so you can be assured that the material is high quality, accurate and up-to-date. So, if you want more information about this programme... Learn about: Vlookup and Hlookup, Financial Training, Microsoft excel training...

...and move between cells B. Working with Cells and Data Sort data Filter data Search data Set cell ranges Enter values in a cell range Use AutoFill Create... Learn about: Data tables, Pivot Reporting, Excel Productively...

...Charts and Graphics, Formatting Charts, Scenarios and Goal Seeking, Advanced Data Analysis. After completion you will find yourself with increased knowledge... Learn about: MS Excel, Data analysis...

...Using Text Functions Breaking Apart Text Entries Using Date & Time Functions Using the Net Workdays Function Using Logical Functions & Fixing Errors Using... Learn about: Excel Productivity, Pivot tables, VBA & Macros...

...2 Hiding and unhiding worksheets B. Controlling the Worksheet View Zooming in and out of a worksheet Viewing a worksheet in multiple windows Splitting... Learn about: MS Excel, Pivot tables, Pivot Reporting...