Microsoft Excel – Level 2 (2016, 2019)
Learn to organize, protect and display data using formulas and functions, multiple workbooks, charts, and advanced formatting.
Topics include:
- Worksheet Organization
- Advanced Formulas
- Using Multiple Workbooks and Worksheets
- Working with Charts
- Applying Formatting
What you'll learn
Upon completion of the course, participants will be able to accomplish the following:
- Organize, protect, and display data using various tools
- Use the IF function
- Create linking formulas, and manage links
- Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and consolidate data from multiple sources
- Create and modify charts to present data effectively
- Customize charts to enhance their appearance
- Create, apply and modify styles to format worksheets consistently and quickly
- Use comments, text boxes sparklines to annotate worksheets and highlight and explain data
Who should attend
This course is intended for participants who are familiar with Microsoft Excel 2016.
Prerequisites
The learners are expected to be familiar with concepts covered in MS Excel Level 1.
Course Materials and Fees
Course materials will be provided to each learner. Required Software: MS Excel 2016 or MS Excel 2019 required (not included with course materials). MS Excel 2013 or earlier not supported. This course does not support Mac computers.
Microsoft Learn for Educators (MSLE) Member
$275
1 day
6 session(s) available
Choose a session
Select a date to registerFor more information about individual or group registration please call 1-833-282-6852 or email training@algonquincollege.com.
Government of Canada Employees
Take advantage of our Standing Offers and Supply Arrangements with the Government of Canada to receive a discount when you register for training.