On this Microsoft Excel 2007 Advanced training course you will work with advanced formulas. You will create lookups with VLOOKUP, MATCH, and INDEX. In addition, you will learn about database functions such as DSUM and data validation. You will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, you will learn about the analytical features of Excel  running and recording macros, and sharing Excel data via the Web. 

Next Microsoft Excel 2007/10 Advanced Open Training Course
08/02/2012
Manchester City Centre Venue
1 place remaining 
Call 0161 408 0435

Course contents

Advanced functions
Logical functions
Math and statistical functions
Financial functions
Displaying and printing formulas 

Lookups and data tables
Using lookup functions
Using MATCH and INDEX
Creating data tables 

Advanced list management
Validating cell entries
Exploring database functions 

PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
PivotCharts 

Exporting and importing
Exporting and importing text files
Querying external databases 
Web Query 

 Analytical options
Goal Seek and Solver
The Analysis ToolPak
Scenarios
Views 

Macros and custom functions
Running and recording a macro
Working with VBA code
 Creating Icons to Run Macros.
Customising the Ribbon

Conditional formatting and SmartArt
Conditional formatting with graphics
SmartArt graphics

 

Last Updated (Thursday, 02 February 2012 18:33)