Go to page content

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

Event Listing 2024-10-25 8:30:00 2024-10-25 16:00:00 America/St_Johns Microsoft Excel Level 2: Executing Data Analysis and Visual Presentation 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. Online Gardinder Centre