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: Quality Training, Office Executive, Office IT...

...(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: Tax Returns, MS Excel, Fixed Assets...

...highly interactive and dynamic GUI. Bookmark Management System - You can bookmark important lessons to watch them again. Self-assessments with instant results... Learn about: Microsoft Office, Ms Office, 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: MS Excel, Office IT, Ms Office...

...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: Microsoft excel training, Office IT, Power Maps...

...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 Training, Financial Reporting...

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

...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: IF statements, Nesting VLOOKUP, MS Excel...

...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: Microsoft Excel, Skills and Training, Database training...

...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 Assistant, Microsoft excel training, MS Excel...

...(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: Pivot Reporting, Excel Productively, Conditional Formatting...

...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, Existing Workbook, Microsoft Excel...

...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, MS Excel, Database training...

...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, IT Auditing, Database training...

...Validation rules Clearing existing Data Validation rules C. Conditional Formatting Understanding conditional formatting Managing Conditional Formatting... Learn about: Conditional Formatting, Simulations & Solver, Pivot table...

...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: Microsoft Excel, Microsoft excel training, Data Validations...

...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: Pivot Reporting, Conditional Formatting, Advanced Formulas...

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

...Using Text Functions Breaking Apart Text Entries Using Date & Time Functions Using the Net Workdays Function Using Logical Functions & Fixing Errors Using... Learn about: Tables & Formatting, Advanced Formulas, Excel Productivity...

...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: Simulations & Solver, Tables & Formatting, MS Excel...