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





Bullseye CX Logo-HR.png
  • LinkedIn Social Icon

© 2020 BULLSEYE CX Pty Ltd. All Rights Reserved.