Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Java Programming
Print PageExcel 97: Advanced
Description:
Participants will learn the skills and concepts necessary to work with advanced features of Excel 97.
- Cost: Price on application
- Duration: 1 Day
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Participants should have a basic knowledge of the concepts involved in using Excel 97.
For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.
For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.
Customizing the work area :
Working with existing toolbars
Creating a toolbar
Creating and using styles
Creating templates
Creating a toolbar
Creating and using styles
Creating templates
Advanced formula construction :
Nested functions
The IF function
The VLOOKUP function
Error handling and the Auditing features
The IF function
The VLOOKUP function
Error handling and the Auditing features
Pivot tables :
Creating pivot tables
Working with pivot tables
Viewing pivot tables at different levels
Working with pivot tables
Viewing pivot tables at different levels
Multiple file linking :
Working with workbooks
Linking individual cells
Workbooks versus links and workspaces
Linking individual cells
Workbooks versus links and workspaces
Consolidating data and using analysis tools :
Consolidating worksheets
Using the Goal Seek and Solver utilities
Creating a scenario by using Scenario Manager
Using the Goal Seek and Solver utilities
Creating a scenario by using Scenario Manager
Protect and display options :
Using comments
Protecting the worksheet
Hiding information
Custom views
Protecting the worksheet
Hiding information
Custom views
Introduction to macros :
Running a macro
Recording a macro
Viewing and editing VBA code
Recording a macro
Viewing and editing VBA code