Microsoft 2016 Excel II: Intermediate

Microsoft 2016 Excel II: Intermediate

Girl looking at a spreadsheet on a computer screen

Girl with blonde hair looking at a computer screen.

Image: Penn State

Expand your skills and improve your productivity with this hands-on Microsoft Excel course. Practice exercises will be included during class in order to give students experience with each area. Some topics covered include a review of formulas, simple “if” formulas, using ranges, AutoFill, Flash Fill, Concatenation, Comments, inserting pictures, macros, charting, and sorting.

Topics covered will be:

  • Review formulas
  • Cells
  • AutoFill and Flash Fill
  • Concatenation
  • Comments
  • Inserting pictures, logos, clip-art
  • Macros, VLookup/HLookup
  • Charting
  • Review functions
  • Sort and Filter
  • Formatting


Date(s): TBD
Time: 5:30PM – 8:30PM
Location: Penn State DuBois, DEF Building, Room 201
Fee: $195
25% discount for Penn State employees, call (814) 375-4772 for your unique coupon code.