Key Fact:
Out of 2,500 companies-those that offered comprehensive training had 24% higher profits. -ASTD
Register for Computer Training
Advanced Excel 2007
Date: Friday, September 17, 2010
Course Length: 1 Day
Time: 9:00 AM - 4:00 PM
Price: $249.00
Seats Remaining: 4
1. Working with Tables
Creating a Table, Working with Table Size, Total Row and Table Data, Summarizing a Table with a PivotTable, Using the Data Form, Table Styles and Table Style Options, Creating and Deleting Custom Table Styles, Convert or Delete a Table.
2. Working with Pivot Tables
Creating a PivotTable, Specifying PivotTable Data, Changing a PivotTable’s Calculation, Filtering and Sorting a PivotTable, Working with PivotTable Layout, Grouping PivotTable Items, Updating a PivotTable, Formatting a PivotTable, Creating a PivotChart.
3. Analyzing and Organizing Data
Creating Scenarios, Creating a Scenario Report, Working with Data Tables, Using Goal Seek, Solver, Data Validation and Text To Columns, Removing Duplicates, Grouping and Outlining Data, Using Subtotals, Consolidating Data by Position or Category and Consolidating Data Using Formulas.
4. Working with Web and External Data
Inserting a Hyperlink, Creating a Web Page from a Workbook, Importing Data from Access or Text Files, Importing Data from the Web or Other Sources, Working with Existing Data Connections.
5. Working with Macros
Recording a Macro, Playing and Deleting a Macro, Adding a Macro to the Quick Access Toolbar, Editing a Macro’s Visual Basic Code, Inserting Code in a Macro.
6. Advanced Topics
Customizing the Quick Access Toolbar, Using and Customizing AutoCorrect, Changing Excel’s Default Options, Recovering Your Documents, Using Microsoft Office Diagnostics, Viewing Document Properties and Finding a File, Saving a Document as PDF or XPS, Adding a Digital Signature to a Workbook, Preparing Documents for Publishing and Distribution, Publishing a Workbook to a Document Workspace.