Microsoft Excel Level 2: Executing Data Analysis and Visual Presentation
Friday, Oct. 25, 8:30 a.m.-4 p.m.
Online
To register, please visit https://www.mun.ca/gardinercentre/professional-development-schedule/ |
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, apply conditional formatting, 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
- Conditional formatting
- 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 is part of the Mastering Microsoft Excel Program.
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 (i.e. font face, size, color)
- Formatting cells (i.e. boarders, fill)
- Formatting numbers (i.e. time, date, currency)
- Basic MS Excel Operators
- Knowledge of formula and functions
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.
Presented by Gardinder Centre