Excel – Level 2

= Guaranteed to run date

Dates are listed in Pacific Time Zone

Dates Locations
Oct 22 8:00 AM - Oct 22 4:00 PM + Remote
Nov 30 8:00 AM - Nov 30 4:00 PM Seattle WA + Remote

$295.00

Learn how to use multiple worksheets and workbooks efficiently. Work with more advanced formatting options including styles, themes, and backgrounds. Learn to use advanced formulas, including lookup functions. Create and apply cell names, work with tables, learn basic and advanced charting techniques, including the use of trendlines and sparklines. Finally, learn to work with PivotTables and PivotCharts.

SKU: ExcelL2 Category: Topic:

Description

Print Friendly, PDF & Email

Overview:

The course builds on the basic concepts and skills of the Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel. Lessons including how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.

Prerequisite(s):

Excel Level 1

Audience:

Outline:

Lesson 1: Managing workbooks

  • Managing worksheets
  • Customizing Excel

Lesson 2: Named ranges

  • Using names in formulas

Lesson 3: Tables

  • Sorting
  • Filtering tables
  • Structured references
  • Validation
  • Transposing data

Lesson 4: Summarizing data

  • Consolidation
  • Subtotals

Lesson 5: PivotTables

  • Creating and formatting PivotTables
  • Manipulating PivotTables
  • PivotCharts

Lesson 6: Presentation features

  • Conditional formats
  • Custom Format
  • Graphics

Lesson 7: Advanced charts

  • Special chart types
  • Sparklines
  • Quick Analysis

Lesson 8: Collaboration

  • Permissions
  • Comments

Additional information

Length

1 day
Guaranteed to run

No

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Related products