FREE ONLINE COURSES
Introduction to Excel | Advanced Excel | Microsoft Teams
A Series of FREE Courses For Club Professionals
Duration: 60 Minutes / Session
Registrations for Courses Starting May 25th are Full.
If interested in attending a future course please share your interest using the 'Express Interest' link.
Topics Covered
Below you will find the topics covered under each module of our online courses.
Introduction to Excel
Intro to Excel: Module 1 - Understanding the Interface
- The Ribbon
-
Customizing the Ribbon -
The Quick Access Toolbar -
Tell Me and Smart Lookup -
The Smart Lookup Tool -
The File Tab
Intro to Excel: Module 2 - Building and Maintaining Tables
- Creating Tables
-
AutoFilters -
Table Tools Design Tab -
Add a Total Row -
Add a Column Total -
Formatting Table Data -
Delete Duplicate Data -
Automatically Extend a Table -
Automatically Freeze Panes to Show the Heading Row -
Select Columns, Rows or the Entire Table
Intro to Excel: Module 3 - Protecting Worksheets
- Protecting your Spreadsheets
-
Preparing your Cells -
Locking your Spreadsheet -
Unprotect Worksheets -
Protecting Workbooks -
Unprotect Workbooks
Intro to Excel: Module 4 - Introduction to Charts
- Using Recommended Charts
-
Inserting a Chart -
Most Commonly Used Charts -
Chart Elements -
Chart Styles -
Chart Formatting Shortcuts -
Using the Chart Styles Button -
Using Chart Filters -
Switching Row and Column Data -
Changing the Chart Type -
Moving a Chart -
Saving a Chart as a Template
Intro to Excel: Module 5 - Introduction to Creating a Form
Step-by-Step Guide on Building Forms
Advanced Excel for Club Professionals
Advanced Excel: Module 1 - Keyboard Shortcuts
- Navigate Worksheets
-
Basic and Advanced Cell Selection -
Edit Content of Cell -
Adjust Clumn Width and Height -
Manage Multiple Worksheets
Advanced Excel: Module 2 - Advanced Formulas
- Extract Text from a Cell
-
Date and Time -
Count Related Formulas -
Sum Related Formulas -
VLOOKUP -
Match and Index -
IF Statements
Advanced Excel: Module 3 - Data Validation
- Creating Data Tables
-
Using Validation Tools
Advanced Excel: Module 4 - Pivot Tables
- Create a Pivot Table
-
Pivoting Data -
Filters -
Slicers -
Pivot Charts
Advanced Excel: Module 5 - Protecting Your Worksheet
- Protect a File
-
Protect a Worksheet -
Locking/Unlocking Cells -
Ranges with Passwords
Advanced Excel: Module 6 - Recording a Macro
- What is a Macro
-
Steps to Record a Macro
Microsoft Teams
Introduction to MS Team
- Introduction
-
Admin – Basics to Get Up and Running -
User Guide -
Meetings -
Join a meeting in Teams -
Schedule a meeting -
Invite people to a meeting in Teams -
See all your meetings in Teams -
Share content in a meeting in Teams -
Record a meeting in Teams -
Play and share a meeting recording in Teams -
Share a file in Teams -
Useful Keyboards Shortcuts