2022 Course Listing
& Registration

logo-web

Courses Offered - Jan to Jun 2022

Below are  the private courses running for the Municipality of Meaford from January to June 2022.  

To register, please use the form at the bottom of this page.

All courses are delivered online (live and fully interactive).  Speak with the Instructor at any time during the course or use the Chat and Q&A features.  Each course is 3.5 hours in length and includes a PDF reference manual and 30 days of technical support. 

ezgif.com-webp-to-png.png

Excel Course 1B
Basic Formulas

Available Dates
Tue Jan 18 (9am to 12:30pm)

All the formula essentials are covered in this course: operators, the order of operations, using built-in functions, and understanding relative vs. absolute cell referencing. Topics include:

Formulas / Functions
– Entering a basic formula
– Operators & order of operations
– General Use of Excel Functions
– Using these Functions:
     – Sum, Average, Max, Min
     – Count, CountA, CountBlank
     – Round, Today, Now

Absolutes ‐ $
– What is a Relative Reference?
– What is an Absolute Reference?
– Using Full Absolutes
– Using Partial Absolutes

Trouble Shooting / Tips
– Display Formulas
– Editing and Finding Formulas
– Errors & Error Checking

ezgif.com-webp-to-png.png

Excel Course 2A
Format & Validation Rules

Available Dates
Tue Mar 8 (9am to 12:30pm)
Tue May 10 (9am to 12:30pm)

Conditional Formatting and Data Validation are features so widely used today that knowing how they work is essential.   They are two very useful Excel features.  Topics include:

Conditional Formatting
-Highlight Cell Rules
-Top/Bottom Rules
-Data Bars, Color Scales, Icon sets
-Using Manage Rules
-Clearing Rules
-Using Formulas for a Rule
-Absolute References in Rules
 
Data Validation
-Restrict Entries in Cells
-Customized Error Messages
-Suppress Error Messages
-Add Input Messages
-Simple Drop-Down Lists
-Create Drop-Down Lists from Data
-Circumvent Validation Settings
-Modify Validation Settings
-Clear Validation
ezgif.com-webp-to-png.png

Excel Course 2B
Working with a Database

Available Dates
Tue Apr 12 (9am to 12:30pm)
Tue Jun 14 (9am to 12:30pm)
 
Understand how to setup and work with database data. Topics include setting up a valid database, sorting & filtering and protecting data from being changed or erased. Topics include:
 
Setup a Valid Database
Why Correct Setup is Important
-Valid Database Rules
-Selecting and Navigating Data
-Freeze Headings & Print Titles
 
Sort & Filter
-Basic and Custom Sorting
-Activating Filter
-Entering/Selecting Filter Criteria
-Totalling Filtered Data
-Clear & Reapply
-Copy/Paste and Delete Filtered Data
 
Protecting Sheet Data
-Locking/Unlocking Cells
-Protection Options
-Protect On/Off
-Forgot Your Password?
1200px-Microsoft_Office_PowerPoint_2018–present.svg.png

PowerPoint Course 2
Presenting Slides

Available Dates
Tue Feb 8 (9am to 12:30pm)
 

This course looks at the presentation of your slides, from transitions, animations and zoom slides to tips on ways to design your slides that effectively communicate your ideas and information.  Topics include:

Zoom Slides (Version 365 only)
-Zoom to a Slide
-Create Sections
-Section Zoom
-Summary Zoom
 
Transitions
-Add Transitions
-Set Options
-The Morph Transition (Version 365 only)
 
Animations
-Add Animations
-The Animations Pane
-Effect Options
-Preview & Auto Preview
-Animate Charts
-Basic Motion Paths
 
Good Slide Deck Design
-Content & Focus
-Using Notes
-Use of Effects
-Fonts & Colours
-Using Design Ideas
-Slide Show Presenter View

Register

To register for one or more courses, please complete this form.    

Private Individual

Registrations

Summary & Payment

What You Need to Attend

To attend a live online course you will need a computer (desktop or laptop), an internet connection and a web browser. 

If you work with a laptop, it might be difficult to show the Instructor’s screen and work in the program at the same time, so for smaller screens, we recommend you have a second monitor or second computer.

It would be helpful if you have a microphone so you can speak during the course, but if you don’t you will still be able to ask questions and make comments using the Q&A or Chat features.