Advanced Excel (Winter 2020)

  • Share:
Name: Advanced Excel (Winter 2020)
Date: February 4, 2020
Time: 8:00 AM - 10:30 AM EST
Registration: Register Now
Event Description:
Program Objective: Participants will learn how to create more advanced charts, database functions, logical formulas, creating range names and working with large spreadsheets more efficiently. 
 
Course Outline:
Various methods of selecting cells
Creating Range Names
Absolute Reference
Working with Logical formulas
Conditional formatting
Inserting Comments
Track Changes - the snitch report!
Working & Printing large Spreadsheets
Using Data Sort & Filters
Creating an Outline
Goal Seek
Creating Scenarios
Macros
Creating Subtotals
Grouping Spreadsheets
Advanced Linking of Spreadsheets

Participants will work on 11 practice examples throughout the 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!

Prerequisite: Introduction to Excel and a good working knowledge of the computer.


 
Location:
Shearer Technical
727 Penn Avenue
West Reading, PA 19611
Date/Time Information:
February 4th, 11th, 18th, 25th
8:00 a.m. - 10:30 a.m.
Contact Information:
Amy Ambrose
Fees/Admission:
$220/person - Chamber Members;
$320/person - Not-Yet Chamber Members
Set a Reminder:
Enter your email address below to receive a reminder message.
Please complete the Captcha