Microsoft^® Excel 2010 Formulas, Functions & PivotTables for the Advanced Excel User

Length: 1 day
Prerequisites: Familiarity with Excel at an Intermediate/Advanced Level.

Target Student:  Take this course if you want to learn useful tools, tricks and tips for utilizing functions and formulas available in Microsoft Excel 2007.  Learn which are best suited from over 300 available built-in functions.  If you need to analyze large amounts of data quickly and easily, this class covers PivotTables - Excel's best resource for doing so.
 

Course Content:

Lesson 1: Advanced Topics Customizing the Quick Access Toolbar Using and Customizing Autocorrect Changing Excel's Default Options Recovering Your Documents Using MS Office Diagnostics Viewing Document Properties/Finding Files Saving a Document in Different Formats Adding a Digital Signature to a Workbook Preparing documents for Publishing and       Distributing Publishing a Workbook to a Document Workspace Creating a Custom AutoFill List Creating a Custom Number Format   Lesson 2: Formula Fundamentals Overview of Formulas and Using AutoSum Entering Formulas Using AutoFill Understanding Absolute and Relative Cell References   Lesson 3: Operators, Range Names, Formula Auditing, etc. Using Subtotals Formulas with Multiple Operators Inserting and Editing a Function Defining Names Using and Managing Defined Names Displaying and Tracing Formulas Understanding Formula Errors   Lesson 4: Formula Functions Using Logical Functions (IF) Using Financial Functions (PMT) Using Database Functions (DSUM) Using Lookup Functions (VLOOKUP) Financial Functions Date & Time Functions Math & Trig Functions Statistical Functions Lookup & Reference Functions Database Functions Text Functions Logical Functions

Lesson 5: Working with Tables Creating a Table Working with Table Size Working with the Total Row Working with Table Data Summarizing a Table with a PivotTable Using the Data Form Using Table Styles & Options Creating and Deleting Custom Styles Convert or Delete a Table   Lesson 6: Working with Web and External Data   Inserting a Hyperlink Creating a Web Page from a Workbook Importing Data from an Access Database or Text File Importing Data from the Web or Other Sources Working With Existing Data Connections   Lesson 7: Working with PivotTables 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   Lesson 8: What-If Tools for Analyzing Data Working with Data Tables Creating Scenarios Creating a Scenario Report Using Goal Seek Using Solver

This website and its contents are copyright © 2010, Knowledge Source Inc.