Course Outline

Signup Now!

• Recording and Running Macros
  • Running Macros
  • Recording Additional Macros
• Editing Macros
  • Editing Macros on the Module Sheet
  • Adding Comments to Macro Steps
• Assigning Shortcut Keys to Macros
• Using Shortcut Keys for Macros
• Adding a Macro Button to a Worksheet

Module 2: Using Multiple Worksheets

• Linking Data Between Workbooks
  • Creating Links
  • Identifying Parts of a Linking Formula
  • Linking and Performing Calculations at the Same Time
  • Updating Links
• Changing and Restoring Links

Module 3: Workgroup Functions

• Applying Outlines
• Working with Shared Workbooks
  • Sharing Workbooks within a Workgroup
  • Removing a Workbook from Shared Use
  • Tracking Changes on Shared Workbooks
  • Merging Shared Workbooks
• Resolving Conflicts
• Saving Documents as HTML

Module 4: Managing Data

• Sorting Data
  • Sorting in Ascending Order or Descending Order
  • Sorting Using Multiple Criteria
• Extracting Data Using Filters

• Creating Custom AutoFilters to Extract Data
• Creating Advanced Filters to Extract Data
• Copying Filtered Data
• Querying a Database
  • Creating a Query

Module 6: Analyzing Data

• Using Data Tables to Calculate Projections
  • Creating One-Input Data Tables
  • Information touristique de Lloret de MarEditing Data Table Source Data
• Creating What-If Scenarios
  • Editing Scenarios
  • Creating Scenario Summary Reports

Module 7: Using Pivot Tables

• Creating Pivot Tables
  • Designing a Pivot Table
• Editing Pivot Tables
  • Changing the Layout of a Pivot Table

Module 8: Working with Multiple Worksheets

• Importing Files from Other Programs
  • Formatting Data Automatically
• Exporting Files to Other Programs
• Consolidating Data from Multiple Worksheets

Module 8: Using Data Maps

• Displaying Geographic Data with DataMap
  • Modifying a Data Map