Categories
Applications
Business Finance
Database Management
Email & News Convertor
Inventory Systems
Multimedia & Design
Personal Finance
Personal Info Managers
Presentation Tools
Project Management
Software Development
Spreadsheets
Web Authoring & Development
Word Processing


Related
Multiple Regression Analysis
The Multiple Regression Analysis and Forecasting template provides a solid...
EXCEL to MySQL
Access-to-MSSQL is a program to move MS Access databases to MS SQL server....
MSSQL to EXCEL
Access-to-MSSQL is a program to move MS Access databases to MS SQL server....
MYSQL to Excel
MSSQL-to-Excel is a program to publish Microsoft SQL databases as Microsoft...
Project Management - Excel Business Tools
The Project Planning and Management excel template is designed as a generic...
Home : Business Finance : SpreadSheet :
Excel Level 2 and 3 Training

Excel Level 2 and 3 Training has 20 lessons written by OzGrid Business Applications. The courses include Excel Fundamentals, Worksheet Formulas, Advanced Formulas, Advanced Filters, and etc.

Buy Now Download


Main features:

  • Developed on a professional basis and drawn from 'real world' experience.
  • Each lesson is between 5 and 10 Word Document pages long. and there are 10 Workbook examples. 

Course outline:

  • Excel Fundamentals, Worksheet Formulas, Specific Worksheet Formulas, Extract Data and Decision Making, Data Validation and External References, Advanced Filters, AutoFilters, Names Charts, Under Utilized Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining
  • Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the Web, Macros 1, Macros 2.