 |
|
|
Datamann understands us very well and is providing us with the service and solutions that meet our exact needs. They have
... read more
|
|
|
|
|
|
Back to Schedule |
|
|
|
Microsoft Excel 2007 - Advanced |
|
|
Prerequisites:
Introductory Classes - Introduction to Computers
Microsoft Excel 2007 - Beginner
Microsoft Excel 2007 - Intermediate
Levels:
Beginner
Intermediate
Advanced
Class length: 1 day
Class Objectives
Summarize worksheet data by creating automatic subtotals; use the Data Validation feature to validate data entered in cells; use database functions to summarize list values that meet the criteria you specify; and use data forms to add data.
Use the PivotTable and PivotChart Wizard to create a PivotTable for analyzing and comparing large amounts of data; change PivotTable view by moving fields and by hiding and showing details; improve the appearance of a PivotTable by changing its field settings and applying a format; and create a PivotChart to graphically display data from a PivotTable.
Export data from Excel to a text file, and import data from a text file into an Excel workbook; import XML data into a workbook, and export data from a workbook to an XML data file; and use Microsoft Query and the Web query feature to import data from external databases.
Run a macro to perform tasks automatically; record macros to perform repetitive tasks; assign a macro to a button, and use the button to run the macro; edit a macro by editing VBA code; and create a custom function to perform calculations when built-in functions are not available.
Use the Goal Seek and Solver utilities to meet a target output for a formula by adjusting the values in the input cells; install and use Analysis ToolPak to perform statistical analysis; create scenarios to save various sets of input values that produce different results; and create views to save different sets of worksheet display and print settings.
Class Outlines
Unit 1: Advanced functions
Topic A: Logical functions
Topic B: Math and statistical functions
Topic C: Financial functions
Topic D: Displaying and prining formulas
Unit 2: Lookups and data tables
Topic A: Using lookup functions
Topic B: Using MATCH and INDEX
Topic C: Creating data tables
Unit 3: Advanced list management
Topic A: Validating cell entries
Topic B: Exploring database functions
Unit 4: PivotTables and PivotCharts
Topic A: Working with PivotTables
Topic B: Rearranging PivotTables
Topic C: Formatting PivotTables
Topic D: PivotCharts
Unit 5: Exporting and importing
Topic A: Exporting and importing text files
Topic B: Exporting and importing XML data
Topic C: Querying external databases
Unit 6: Analytical options
Topic A: Goal Seek and Solver
Topic B: The Analysis ToolPak
Topic C: Scenarios
Topic D: Views
Unit 7: Macros and custom fuctions
Topic A: Running and recording a macro
Topic B: Working with VBA code
Topic C: Function creating
Unit 8: Conditional formatting and Smart Art
Topic A: Conditional formatting with graphics
Topic B: Smart Art graphics
|
|
