Intermediate Excel / February 3rd, 10th, 17th, 24th

  • Share:
Name: Intermediate Excel / February 3rd, 10th, 17th, 24th
Date: February 3, 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 this 10-hour course and are certain to leave with a very good understanding of the more advanced features of working with a spreadsheet!
Location:
Shearer Technical
727 Penn Avenue
West Reading, PA 19611
Date/Time Information:
February 3rd, 10th, 17th, 24th
8:00 a.m. - 10:30 a.m.
Contact Information:
Amy Ambrose
Send an Email
Fees/Admission:
$220/person - Chamber Members
$320/person - Non-Chamber Members
Set a Reminder:
Enter your email address below to receive a reminder message.
Please complete the Captcha