PennTRAIN: Microsoft Excel Training

This 3-hour course will be held over three 1-hour sessions:

Participants should plan to attend all three sessions.

Who Should Attend: PPTA members who are familiar with Excel and desire to increase their comfort/level knowledge regarding Excel.

The session will review the following topics:

General "Just using Excel"

• • Includes multiple windows 
  • Freezing portion of the worksheet 
  • Quick Access Tool bar (QAT) 

Formatting

• Dos and Don’ts 
• Dates 
• Format painter 
• Page layout and Printing 

Working with Data which includes: 

• Sorting 
• Filtering 
• Tables 
• Conditional formatting 
• Subtotals 
• Finding and Removing Dups 

Basic formula creation 

• Summing 
• Relative and Absolute 
• Order of operation 
• Formulas such as VLOOKUP, HLOOKUP, and IF functions 
• Troubleshooting formulas 
• Charting/charts 

Tips and Tricks

Presented by: Rich Williams, Data Centric Services

Cost: No charge.

Internet Access Required. This course will be presented via Zoom, and attendees must have an internet connection in order to participate. Links to join each session will be provided in advance via email.