Skip to content

Main Navigation

Excel: Beyond the Basics and Master Pivot Tables

Program Highlights

  • Flexible Learning: Instruction is all online with deadlines set by instructor
  • Time Commitment:  Each class is 2 hours long and followed by 2 hours of coaching
  • Length of Program: Each class is only one day
  • Beginner:   Sept. 29, 10 am - Noon or Oct. 14, 2 pm - 4 pm
  • Intermediate: Nov. 10, 6pm - 8pm

*All applications must be received by November 20th for consideration.


About


These interactive online programs are designed to familiarize students to the Excel interface, navigation of tools, spreadsheet terminology, and fundamental organization concepts that are essential to creating and presenting dynamic worksheets in Excel.

Excel: Beyond the Basics will cover templates, Excel’s formulas and functions, PMT lookups and data validation.

Master Pivot Tables will build on what you learn in Excel: Beyond the Basics and teach you how to prepare data for pivot tables, create pivot tables and charts, format, filter, and so much more. 

What You Will Learn


Upon completion of both classes, you will understand:

  1. Templates
  2. Named Ranges
  3. Formulas vs. Functions
  4. Absolute vs. Relative Referencing
  5. If Function (Basic Introduction)
  6. Vlookup Function (Basic Introduction)
  7. PMT Function
  8. Subtotals
  9. Data Validation
  10. Conditional Formatting
  11. Sorting & Filtering
  12. Charts – Pie, Combination, Dual Axis, List
  13. How to prepare data
  14. Create Pivot Table
  15. Organize Data
  16. Slicers
  17. Timelines
  18. Filters
  19. Formatting
  20. Change Data/Refresh
  21. Pivot Charts
  22. Pivot Tables vs. PowerPivot

Employment Outlook


The skills taught in this program apply to any position where managing data is important. Sales, science, and database management.

Mastery of Excel and Pivot Tables is a marketable skill.

Foundational Knowledge


We recommend that you have the following to participate in this program:

  • Basic computer skills
  • HS diploma or GED
Last Updated: 9/16/20