Intermediate Excel - January 2023

  • Share:
Name: Intermediate Excel - January 2023
Date: January 4, 2023
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!
 
Prerequisite: Introduction to Excel and a good working knowledge of the computer.
Location:
Shearer Technical Computer Consultants
727 Penn Avenue
West Reading, PA 19611
Date/Time Information:
Four weeks on Wednesdays: January 4, 11, 18, 25
Time: 8 a.m. - 10:30 a.m.
Contact Information:
Mark Dolinski, Vice President Training and Professional Development
Fees/Admission:
$300/person - Chamber Members;
$375/person - Not-Yet Chamber Members
Set a Reminder:
Enter your email address below to receive a reminder message.
Please complete the Captcha