ProfBurnett.com - Master a Skill / Learn for Life

Excel Tips and Tricks – Advanced

Course Outline:

Want to take your Excel game to the next level? In this course, you will learn powerful tips, tricks, and shortcuts that can help you leverage more of what Excel has to offer. Learn time-saving tricks for creating formulas rapidly, accelerating data entry, and navigating within worksheets efficiently. Plus, discover drag and drop techniques, and formatting shortcuts.

Prerequisites:

Computer Basics and Working with Windows or File Management Skills or equivalent experience.

Required Textbook & Materials

Title:   Excel Tips and Tricks – Advanced PDF

Materials:   Please bring a Flash Drive/Memory Stick 512MB or larger to class which will enable you to save your class work

Meeting Information:

  • 1/28/2021 - 8:30 - 10:00 AM / 10:30 - 12:00 PM
  • 2/1/2021 - 8:30 - 10:00 AM / 10:30 - 12:00 PM
  • 2/10/2021 - 1:00 - 2:30 PM / 3:00 - 4:30 PM
  • 3/31/2021 - 8:30 - 10:00 AM / 10:30 - 12:00 PM
  • 4/7/2021 - 1:00 - 2:30 PM / 3:00 - 4:30 PM
  • 4/13/2021 - 8:30 - 10:00 AM / 10:30 - 12:00 PM

Course Objectives:

  • Expanding and collapsing ribbon and full-screen views
  • Efficiently navigating between workbooks and worksheets
  • Selecting entire rows, columns, regions, and worksheets
  • Data entry and editing shortcuts
  • Rapidly creating formulas
  • Data management techniques

Class Exercise Files:

Colleges and Universities