Overview

Microsoft Excel Level 2 woman analyzing spreadsheets
PDT-ComDP-21

Microsoft Excel: Level 2

This workshop builds on the basic concepts and skills learned in Introduction to Microsoft Excel (Level 1) and introduces tools for analysis of complex data.

Topic covered will include:

  • Managing Workbooks: Summarizing and working with multiple worksheets.
  • Named Ranges: Using names in formulas
  • Summarizing Data: Consolidation and subtotals
  • Formulas: Logical and Lookup formulas that use criteria to find and calculate data; consolidate, separate and modify text imported from your ERP software
  • Tables: Sorting, filtering tables, structured references, table formulas
  • Intro to Charts: Creating and modifying charts, sparklines, quick analysis and Smart Art
  • Intro to PivotTables: Creating and formatting, manipulating, and summarizing

All students will receive handouts and sample files to take home with them for continued practice.

Prerequisites: Students should have taken Introduction to Microsoft Excel (Level 1), or already be familiar with the concepts covered within the workshop.

This class is hands-on. Students must bring a laptop (and mouse) with MS Office in a version no older than 2013 with them to class.  Please ensure that Microsoft Excel is working properly and that your laptop has downloaded and incorporated the latest Windows updates prior to class.  All students will receive sample files which will be emailed within a week prior to class. Please download those practice files to your laptop prior attending, if at all possible. During class, the accompanying home handouts will be distributed for continued practice.

The course will be presented in MS Office 365 on a Windows platform.  Those using a Mac will notice a few differences with course material presented in Windows.

  Important Notice: Check the drop down menu in the enrollment section for additional dates.

What You Will Learn

PDT-ComDP-21

Microsoft Excel: Level 2

Workshop topics include:

Managing Workbooks

  • Managing worksheets
  • Customizing Excel

Named Ranges

  • Using names in formulas

Tables

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

Summarizing Data

  • Consolidation
  • Subtotals

PivotTables

  • Creating and formatting
  • Manipulating
  • PivotCharts

Presentation Features

  • Conditional formats,
  • Custom formats
  • Graphics

Advanced Charts

  • Special chart types
  • Sparklines
  • Quick analysis

Collaboration

  • Permissions
  • Shared workbooks

Tools & Materials

PDT-ComDP-21

Microsoft Excel: Level 2

This class is hands-on. Students must bring a laptop (and mouse) with MS Office in a version no older than 2013 with them to class.. Please ensure that Microsoft Excel is working properly and that your laptop has downloaded and incorporated the latest Windows updates prior to class.

All students will receive a Microsoft Excel: Level 2 workbook to use during class, and to take home with them for continued practice.

Instructor Bios

PDT-ComDP-21

Microsoft Excel: Level 2

  • Nancy Little

    Nancy has been working as a Microsoft Certified Trainer since 2002.  She has extensive experience in classroom, corporate, custom, and individual trainings with Excel, Word, Access, PowerPoint, and Windows.  Nancy's students describe her as professional, patient, and knowledgeable.

09:00am - 03:30pm
Portsmouth - 230 Commerce Way
Nancy Little
289.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
UNH Extension Discount
Guild Partner
Military Discount
REEO Discount
New to NH Discount
0.6
PDT-ComDP-21
224267
09:00am - 03:30pm
Portsmouth - 230 Commerce Way
Nancy Little
289.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
UNH Extension Discount
Guild Partner
Military Discount
REEO Discount
New to NH Discount
0.6
PDT-ComDP-21
224270
09:00am - 03:30pm
Portsmouth - 230 Commerce Way
Nancy Little
289.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
UNH Extension Discount
Guild Partner
Military Discount
REEO Discount
New to NH Discount
0.6
PDT-ComDP-21
224279
09:00am - 03:30pm
Portsmouth - 230 Commerce Way
Nancy Little
289.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
UNH Extension Discount
Guild Partner
Military Discount
REEO Discount
New to NH Discount
0.6
PDT-ComDP-21
224282