Overview

Microsoft Excel Level 3 business woman at computer
PDT-ComDP-24

Microsoft Excel: Level 3

This workshop builds on the basic concepts and skills learned in Microsoft Excel: Level 2 and provides more advanced tools for data management, analysis, and presentation of large and small databases.

Topic covered will include:

  • Visuals that pop: Conditional formatting based on formulas, finding expiration dates, top performers, duplicate records
  • Advanced Formulas: Combine data validation with conditional formatting and VLOOKUP, more lookup functions when VLOOKUP does not suit your data list, array formulas, mixed absolute references
  • Advanced Charts: Special chart types, compare targets to actuals, thermometer, benchmark, dynamic with scrollbar, track labor hours by project
  • Advanced Pivot Tables: Setting up your data source, multiple ways to summarize data, adding calculations to your pivot table, custom grouping, creating dashboards

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

Prerequisites: Students should have taken Microsoft Excel: Level 2, or already be familiar with the concepts covered within the workshop. Note: Students who have already taken Advanced Pivot Tables may find overlap within this class.

This class is hands-on. Students must bring a laptop (and mouse) with MS Office 2010, 2013 or 2016 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.  The class will be presented in MS Office 365 on Windows.  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.

Tools & Materials

PDT-ComDP-24

Microsoft Excel: Level 3

This class is hands-on. Students must bring a laptop (and mouse) with MS Office 2010, 2013 or 2016 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 2016: Level 3 workbook to use during class, and to take home with them for continued practice.

Instructor Bios

PDT-ComDP-24

Microsoft Excel: Level 3

  • 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
279.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
Cooperative Extension Discount
Guild Discount
Military Discount
REEO Discount
New to NH Discount
0.6
PDT-ComDP-24
223318
09:00am - 03:30pm
Portsmouth - 230 Commerce Way
Nancy Little
279.00 Tuition (includes lunch)
6
USNH Tuition Benefit Discount
PDT - 10% Alumni Discount
Cooperative Extension Discount
Guild Discount
Military Discount
REEO Discount
New to NH Discount
0.6
PDT-ComDP-24
223500