Students will learn how to create more advanced charts, database functions, logical formulas, creating range names, and how to work with large spreadsheets in Excel more efficiently including:
- Everything you can do in Pivot Tables
- Consolidating Workbooks
- Creating a Shared Workspace
- Creating a Saved Workspace
- Data Validation in Range Names
- Creating a One Variable Input Table
- Creating a Two Variable Input Table
- Working with Advanced Macros
- Using the Text To Columns command
- Protecting Cells that contain formulas
- Creating a Pareto Chart
- Creating a Histogram
- Advanced Goal Seek
- Working with V Lookup functions
Advanced Microsoft Excel Fall 2017 (M...
Date and Time
Wednesday Oct 11, 2017
8:00 AM - 10:30 AM EDT
Four Sessions on Wednesdays:
October 11, 18, 25 & November 1
8:00 a.m. - 10:30 a.m.
Location
Shearer Technical Computer Consultants
727 Penn Ave., West Reading
Fees/Admission
$220/person
Contact Information
Mark Dolinski, Director of Business Services
610-898-8386
Send Email