|
ms303-ver12.7-sg
Microsoft Office Excel 2007 - Level 3 (1 day)
Description
In Microsoft Office Excel 2007 - Level 3, you learn how to analyze and manage your data.
You will explore the many data analysis tools available in Excel.
Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, manage your data lists, create PivotTables and create basic macros.
Prerequisites• Microsoft Office Excel 2007 - Level 1
• Microsoft Office Excel 2007 - Level 2
Supplemental Instructor ResourcesInstructor class workshop files are available for download after purchasing this product.
Course OutlineLesson 1: Using Advanced Functions • Use Function Arguments • Use Financial Functions • Use Logical Functions • Use Nested IF Functions • Use Date Functions • Use Text Functions • Use Statistical and Math & Trig Functions • Use a Lookup Function • Use the Formula Auditing Toolbar • Trace Cell Precedents and Dependents
Lesson 2: Analyzing Data • Work with a Scenario • View the Scenarios • View a Summary • Edit a Scenario • Delete a Scenario • Use Solver • Use Goal Seek
Lesson 3: Managing Data • Use Database Terms • Understand how Excel Organizes Data • Work with Tables • Add and Delete Records • Sort a List • Filter Your Data • Use Other Filtering Options • Use the Advanced Filter • Create Subtotals
Lesson 4: Using Conditional Formatting • Apply a Conditional Format • Manage Conditional Formatting Rules • Delete a Conditional Formatting Rule • Create a Custom Format • Use Zeros in Formatting • Use Color Codes
Lesson 5: Using PivotTables and PivotCharts • How a PivotTable Works • Create a Simple PivotTable • PivotTable QuickFilter • The PivotTable Field List Pane • The PivotTable Screen • The PivotTable Ribbon • Pivot the PivotTable • Copy PivotTables • Delete PivotTables • PivotTable Options • Work with PivotCharts • See the Detail of a Cell • Merge Labels • Manually Add Calculations • Use Calculated Fields • Use Calculated Items • Use the Report Filter • Sort a PivotTable • Display the Top or Bottom Items • Group Data • Create a PivotChart • Format a PivotChart • Work with PivotCharts
Lesson 6: Importing and Exporting Data • Accessible Data Sources • Export a File • Import Data • Import a Text File • Use Access Data • Copy a Word Table into Excel • Insert Excel Data Into Word
Lesson 7: Working with Macros • Record a Macro • Run a Macro • View and Editing a Macro • Visual Basic Editor Anatomy • Delete a Macro • Run a Macro from a Custom Button • Assign a Macro to a Drawing Object • Understand Macro Viruses
|
|
|
|
