Microsoft Excel 2007 - Advanced
Short course
In Carlisle
Description
-
Type
Short course
-
Level
Advanced
-
Location
Carlisle
-
Duration
1 Day
Facilities
Location
Start date
Start date
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 Content
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 2007 - Advanced