Microsoft Excel 2007 / 2010 AdvancedTraining Course
Sponsored links
On this Microsoft Excel 2007/2010Advanced 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.
| Delivery: |
|
| Regions: |
|
| Category: | |
| Duration: |
|
| Qualification: |
|
Further Details
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
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
Scenarios
Creating data tables
Macros and custom functions
Running and recording a macro
Working with VBA code
Creating functions
Creating Icons to Run Macros.
Customising the Ribbon
Conditional formatting and SmartArt
Conditional formatting with graphics
SmartArt graphics
This Training Course is taught in classrooms in the following locations:
Manchester
Oldham
Stockport
Warrington
Wigan
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
