by Pam Conway | Released November 2012 | ISBN: 00021CWORKS

This course builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft Office Excel 2007, you learn how to analyze and manage your data. You will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, filter and manage your data lists, create and manipulate PivotTables and PivotCharts and record basic macros. Show and hide more

1. Introduction
   • Introduction 00:01:41
2. Using Advanced Functions
   • Financial Functions 00:07:45
   • Logical Functions 00:16:04
   • Text Functions 00:14:57
   • Statistical and Math Functions 00:05:26
   • Lookup Functions 00:10:14
3. Formula Auditing
   • Displaying Formulas 00:01:22
   • Tracing Cell Precedents and Dependents 00:01:23
   • Using the Formula Evaluator 00:04:05
   • Error Checking 00:01:31
4. Analyzing Data
   • Using Subtotals 00:04:12
   • Using Goal Seek 00:03:15
   • Using the Scenario Manager 00:08:00
5. Advanced Formatting
   • Understanding Custom Formats 00:09:22
   • Applying a Custom Format 00:03:44
   • Using Conditional Formatting 00:02:58
   • Adding Data Bars, Color Scales, and Icon Sets 00:04:36
   • Managing Formatting Rules 00:05:15
6. Managing Data
   • Planning a Database and Understanding Database Terms 00:10:42
   • Formatting and Sorting Tables 00:01:48
   • Filtering a Table 00:10:03
   • Using the Advanced Filter 00:11:09
7. Working with PivotTables
   • Creating a Simple PivotTable 00:01:57
   • Using the PivotTable Field List Pane 00:05:31
   • Working with PivotTable Options 00:05:45
   • Sorting in a PivotTable 00:06:04
   • Formatting a PivotTable 00:02:37
   • Creating a PivotChart 00:05:15
   • Formatting a PivotChart 00:02:15
8. Importing and Exporting Data
   • Importing from Access 00:07:07
   • Importing a Text File 00:07:16
   • Managing Updates 00:01:44
   • Exporting Data 00:02:59
9. Macros
   • Recording a Macro 00:02:44
   • Running a Macro 00:01:31
   • Running a Macro from a Custom Button 00:02:34
10. Conclusion
    • Conclusion 00:01:21
Show and hide more