Intermediate Microsoft Excel - SOLD OUT!

  • Share:
Name: Intermediate Microsoft Excel - SOLD OUT!
Date: January 17, 2022
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 Mondays: Jan. 17, 24, 31 and Feb. 7
TIME: 8 a.m. - 10:30 a.m.
Contact Information:
Mark Dolinski, Vice President Training and Professional Development
Fees/Admission:
$240/person - Chamber Members;
$340/person - Not-Yet Chamber Members
Set a Reminder:
Enter your email address below to receive a reminder message.
Please complete the Captcha