Upon Request Courses

Excel 2010/2007 Part 3

This course covers a number of powerful and important functions and features in Excel. Learn popular advanced functions, statistical and analytical features, and automation using macros.

Dates & Times

Request

Call (518) 786-1181 or contact us for customized, individual or group training.

Course Outline

This course is recommended for an experienced Excel user who would benefit from learning more about the functions and features of the product.

Includes:
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously

  • Use 3-D references
  • Use links and external references
  • Consolidate data

Lesson 2: Sharing and Protecting Workbooks

  • Collaborate on a workbook
  • Protect worksheets and workbooks

Lesson 3: Automating workbook functionality

  • Apply data validation
  • Work with forms and controls
  • Work with macros

Lesson 4: Applying Conditional Logic

  • Use Lookup functions
  • Combine functions
  • Use formulas and functions to apply conditional formatting

Lesson 5: Auditing worksheets

  • Trace cells
  • Search for invalid data and formulas with errors
  • Watch and evaluate formulas

Lesson 6: Using Automated Analysis Tools

  • Determine potential outcomes using data tables
  • Determine potential outcomes using scenarios
  • Use the Goal Seek feature
  • Activate and use the Solver tool
  • Analyze data with Analysis ToolPak tools

Lesson 7: Presenting Your Data Visually

  • Use advanced chart features
  • Create Sparklines