Description

Course Curriculum:

If you’re already familiar with the basics of Excel, this course will take you through the more advanced features of the software.

Topics covered:

• Functions
• Freezing Panes and View Options
• Sorting Data
• Filtering Data
• Groups and Subtotals
• Tables
• Charts
• Conditional Formatting
• Track Changes and Comments
• Inspecting and Protecting Workbooks
• Intro to PivotTables
• Doing More with PivotTables
• What-if Analysis

Course Details:

• Courses last for 8 weeks, meeting 90 minutes, once per week on Fridays at 6:00pm CST 
• The course starts on the start date you select from the Date drop-down menu at the top of this page
• The course is led by a live instructor
• The course sessions take place on Zoom
• The instructor’s camera will be on, but your camera is optional

Course Requirements:

• Familiarity with the basics of Microsoft Excel (see course curriculum for the Level 1 course)
• Your own Microsoft Windows device with a recent version of Microsoft Office, including Excel, installed
  • If needed, click here to learn more about Microsoft Office
  • The instructor will be using the latest Microsoft Office Professional Plus 2021
• A stable internet connection
• The ability to access, attend, and participate in the class through Zoom (Ok to use the free version linked below)
  • Zoom can be downloaded at https://zoom.us/
• Functioning speakers and a microphone
• An internet browser (Chrome, Edge, Firefox, etc)
• The ability to download and open Excel files on your device
• A quiet environment free of disruptions and background noise that could interfere with the lesson