Develop one of the most critical and fundamental digital skills - Microsoft Excel. Excel is a powerful tool essential for managing and presenting work-related data. Participants will learn to create Microsoft Excel data tables, use pivot tables, and create charts with impact. Through hands-on practice, participants' new skills will help them to present data in a clear and professional manner.    

Key learning outcomes

• Inserting graphics  
• Inserting links, comments, text, and symbols   
• Creating tables  
• Naming tables 
• Formatting tables  
• Calculations in tables 
• Defined Names 
• Charts with impact  
• Pivot tables  
• Pivot table tools
• Pivot charts  
• Reviewing tools  

This course requires basic knowledge and experience with MS Excel. Participants must have a working understanding of the following:

• How to open, save and print workbooks.
• Formatting cell contents as numbers, text, currency, time, etc.
• Basic MS Excel Operators
• Knowledge of formula and functions

Course Duration: 1 day | Continuing Education Contact Hours: 7 

This course is part of the Mastering Microsoft Excel Program

If you are unsure of your level of knowledge and experience with Excel as it pertains to this course, please use the Microsoft Excel Placement Self-Assessment to determine which level you should begin with. 

NOTE: This is an interactive session. Participants must have Microsoft Excel 2016, Microsoft Excel 365, (or compatible version) installed on their laptop.

To further boost your productivity, we suggest using a second monitor, which allows you to easily follow along and practice simultaneously.

Course Endorsements & Partnerships

This course qualifies as credits toward the International Association of Business Communicators' (IABC) professional certifications.

When applying to sit for either the exam for Communications Management Professional (CMP)(R) or Strategic Communication Management Professional (SCMP)(R) or to apply for recertification, Gardiner Centre courses can be an integral part of your application package.

To learn more about this global standard certification, visit: gcccouncil.org. To inquire about sitting for a certification exam, contact the local IABC NL chapter at iabcnl@gmail.com, or visit: iabcnl.com.

___________________________________________________________________________________________

This course qualifies for Professional Development Units (PDUs) as defined by the Project Management Institute (PMI).

Each course has a specific qualifying factor for PDUs. See the table below for a specific PDU breakdown for this Gardiner Center program.

To learn more about PDUs and how to apply these credits to your active credential please see www.pmi.org.

Graduate Testimonials

"I didn't think it was possible to make learning excel fun and easy. the instructor was clear. Concise and has excellent teaching ability. Thank-you!"

"Kelly's willingness to go above and beyond was much appreciated. Too bad I didn't do this course two weeks ago... I could've saved myself some headache. I will definitely use this info in my future excel projects." - Mark Hawco, NL Hydro. 

"There were lots of good practice activities." - Fall 2022 Participant

Instructor(s)

Betsy Bond

Betsy, EMBA, B.Comm., CCMP, Prosci® Executive Instructor, is an expert facilitator, renowned for her extensive experience in Change Management through which she has been a power use of all the major productivity tools including the Microsoft 365 suite products, various Generative AI platforms and survey-based tools. With over 25 years of experience in change and project management, Betsy has worked across various sectors including manufacturing, banking, insurance, healthcare, transportation, packaged foods, retail, and non-profit. Her ability to deliver clear communication across diverse workgroups leads to quick and effective results.

With a background in information technology and strong analytical skills, Betsy excels at helping teams solve problems swiftly and endorses various tools to enhance team effectiveness. She also offers coaching to leaders responsible for complex change initiatives.