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 1, 2 and 3 Training

Excel Level 1, 2 and 3 Training written by OzGrid Business Applications includes 30 lessons. It offers you Excel Fundamentals, Worksheet Formulas, Extract Data and Decision Making, Advanced Filters and much more.




 

Buy Now Download


Main features:

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

BASIC COURSE OUTLINE:

  • The Fundamentals of Excel, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas - The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function
  • 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