|
These lessons have been written by OzGrid Business Applications who develop Excel spreadsheets on a professional basis. Each lesson is drawn from 'real world' experience and not made up class room scenarios. There are 20 lessons, each between 5 and 10 Word Document pages long, and 10 Workbook examples.
Excel Level 2 Intermediate is for students and professionals with 1-3 years of Microsoft ExcelŽ experience. Level 2 advances your core Excel skills, dramatically enabling you to perform advanced analysis, formulas, data capture, charts, graphs, and presentations necessary for today's complex business and academic environment. The course covers:
Worksheet Formulas
Specific Worksheet Formulas
Extract Data and Decision Making
Data Validation and External References
Advanced Filters and AutoFilters
Range Names
Charts
Under-Utilised Features
Protection
Shared Workbooks and Merging Shared Workbooks
Track Changes
Custom Views
Report Manager
Hyperlinks
Outlining
Excel Level 3 Advanced is for students and professionals with strong Microsoft ExcelŽ knowledge. Level 3 truly makes you a master of Excel, and provides you with the powerful knowledge and skills you need to do complex modeling, data management, advanced formulas, pivot tables, and much more! The course covers:
Advanced Formulas
Advanced Filters
Text To Columns
Importing Text Files
Pivot Tables (with online tutorial)
Scenarios
Goal Seek
Data Tables and Consolidation
Excel on the Web
VBA Macros 1 and 2
5 Downloadable Workbook examples
What you Get
Instant download of your Excel training
FREE Excel question support for LIFE!
Ask all/any Excel/VBA questions free in OzGrid's 24/7 Excel Help Forum
All Lessons Applicable to Excel 97-Excel 2003 and Windows 95 and Above!
30 Day Money Back Guarantee on All Excel/VBA Training
3 LICENSE OPTIONS (SPECIFY IN THE ORDER FORM):
- 1 User License allows installation of the course on 2 Computers
- Unlimited license allows installation of the course on an unlimited number of Computers, and/or Networks.
- Resellers License allows you do what ever you like with the lessons, re-brand and re-sell. No Restrictions At All!
|
