Microsoft Excel 2003 - Advanced
Short course
Distance
Description
-
Type
Short course
-
Methodology
Distance Learning
-
Duration
1 Day
About this course
Course delegates would be expected to be able to create spreadsheets with a variety of formulas, functions and charts and have completed our Microsoft Excel Intermediate course.
Reviews
Course programme
Course Details:
Our one day Advanced course in Microsoft Excel, covers the following topics:
- Naming Cells & Ranges
- Automatic & conditional Formatting
- Custom Number Formats
- Paste & Select Special
- Importing Data from Other Applications
- Cell & Sheet Protection
- Data Handling Queries & Functions
- Linking & Consolidation
- Templates
- Advanced Charting
- Complex Functions
- Text Manipulation
- Lookup & Reference
- Conditional Formatting
- Error Checking
- Pivot Tables
- Scenarios
- Data Analysis
- Goal Seek, Solver & Data Tables
- Auditing Worksheets
- Macros, Toolbars & Menus
Microsoft Excel 2003 - Advanced