Microsoft Excel Course - Canada

Microsoft Excel Training Outline

Module 1: Navigation of the Excel Interface

• Understanding the Excel Start Screen
• Excel Tab Interface
• Introduction to Microsoft Excel
• Excel Workbook Screen
• Ribbon
• Name Box
• Formula Bar
• Worksheet Tab
• Understanding the Backstage View
• Accessing the Backstage View
• Understanding Dialog Boxes
• Launching Dialog Boxes
• Understanding Quick Access Toolbar
• Changing the Location of the Bar
• Understanding the Status Bar

Module 2: Use of Lists and Tables

• Understanding Lists
• Applying a Filter
• Clearing a Filter
• Performing an Alphabetical Sort
• Performing a Numerical Sort
• Creating a Table
• Inserting or Deleting Table Records
• Removing Duplicates
• Modifying a Table
• Sorting Data in a Table
• Naming Tables
• Resizing Tables
• Converting a Table to a Range
• Deleting a Table

Module 3: Conditional Formatting

• Understanding Conditional Formatting
• Highlighting Cells Containing Values
• Highlighting Cells Containing Text
• Highlighting Duplicate Values
• Using Top and Bottom Rules
• Using Data Bars
• Using Color Scales
• Using Icon Sets
• Creating Custom Rules
• Conditional Formatting Rules Manager
• Clearing Rules

Module 4: Using Formulas and Creating Pivot Tables

• Using Sparklines
• Using Formulas in Excel
• Exploring Excel Functions
• Insert Function Button
• Working with Names and Ranges
• AVERAGE Function
• COUNT Function
• Common Logical Functions
• Using Formulas in Excel
• IF Formulas
• IFS Formulas

Module 5: Visualising Your Data

• Creating and Formatting Charts
• Create a PivotTable from an Excel Data List
• Refresh Data/Change Data Source
• Changing the Pivot Table Design
• Creating and Modifying a Pivot Chart
• VLOOKUP
• HLOOKUP
• XLOOKUP
• Creating and Managing Drop-down Lists
• Undo, Redo, and Repeat with Keystrokes

Module 6: Paste Special Techniques

• Basic Use Cases for Paste Special
• Transposing Data Using Paste Special
• Applying Paste Special Operations to Improve Data Accuracy

Who should attend this Microsoft Excel Course?

This Microsoft Excel Course is designed for individuals of varying skill levels who want to enhance their proficiency in using Microsoft Excel. This Microsoft Excel Training Course can benefit a wide range of professionals, including:

• Beginners
• Intermediate Users
• Advanced Users
• Business Professionals
• Entrepreneurs and Small Business Owners
• Data Analysts
• Administrative Professionals
• Project Managers

Prerequisites of the Microsoft Excel Course

There are no formal prerequisites for this Microsoft Excel Course.

Microsoft Excel Course Overview

Microsoft Excel is an indispensable tool across various industries, known for its versatility in data analysis, financial modelling, and information management. Its relevance stretches from simple spreadsheet management to complex data analytics, making it a critical skill set for professionals aiming to enhance their productivity and analytical capabilities.

Proficiency in Microsoft Excel Courses are crucial for professionals who deal with data, financial reports, and analytical tasks daily. This includes Accountants, Financial Analysts, Data Analysts, Project Managers, and Marketing Professionals. Mastering Excel streamlines their workflow and opens up opportunities for data-driven decision-making and insights, setting a solid foundation for career advancement.

The Knowledge Academy’s 1-day Microsoft Excel Training is designed to transform delegates from casual users to Excel power users. Delegates will learn through practical examples, hands-on exercises, and real-world case studies, enabling them to unlock Excel's full potential. By the end of the day, delegates will be proficient in advanced functions, data visualisation techniques, and automation processes, significantly enhancing their efficiency and analytical skills.

Course Objectives

• To introduce the comprehensive capabilities of Microsoft Excel, from basic functionalities to advanced features
• To develop skills in using formulas, functions, and Excel operations to solve complex problems
• To enhance proficiency in data analysis and visualisation tools for insightful reporting
• To teach efficient data management techniques, including sorting, filtering, and conditional formatting
• To explore the power of PivotTables and PivotCharts for dynamic data summarisation and exploration

After completing this Microsoft Excel Certification, delegates will receive a Microsoft Excel Certificate, recognising their proficiency in Excel. This Microsoft Excel Certification validates their skills and enhances their professional credibility, opening doors to new career opportunities and advancements.

What’s included in this Microsoft Excel Course?

• World-Class Training Sessions from Experienced Instructors  
• Microsoft Excel Certificate
• Digital Delegate Pack