Skip to main content

Microsoft Excel 2016: Level 3 (Pivot tables & Charts)

ID : 6073   
« back to classes page
Microsoft Excel 2016: Level 3
Learn how to reorganize, summarize, analyze and filter data using Pivot Table.  Students will also learn to summarize large data using Pivot Table and Pivot Charts, working with "name" ranges, the functionality of Excel data tables, write complex functions & formulas, working with multiple worksheets, use of conditional formatting, and creating appealing charts & graphs.  An introduction to creating Macros. Please bring a USB drive to save your work and practice take-home exercises.
Class Outline
  • How to work with multiple worksheets
  • Reorganize and summarize large data using Pivot Table and Pivot Charts
  • Write complex formulas using absolute references
  • Use VLookup & HLookUps, and incorporating them within formulas
  • Sorting and analyzing data through the use of Slicers and Timeline
  • Writing IF Statements and Applying Conditional Formatting
  • Protecting your worksheet and workbook
  • Goal Seek Feature
  • How to use the new INDEX & MATCH Function
  • Introduction to Macros

Class Details

4 Sessions
Weekly - Sat

Los Angeles Harbor College

Mario Diaz 



Please read:  Experienced Users or those who have completed Lv 2.



Registration Closes On
Saturday, May 11, 2019 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
4/20/2019 - 5/11/2019 Weekly - Sat 9:00 AM - 12:00 PM Wilmington, Los Angeles Harbor College  Map Mario Diaz 

You may also be interested in these classes