Intermediate Microsoft Excel 2019 M55269 Training Overview

Course syllabus

Who it’s for

What’s included

FAQs

Intermediate Microsoft Excel 2019 M55269 Training Course Outline

Module 1: Common Functions

  • Using Named Ranges in Formulas
  • Entering a Formula Using Data in Multiple Worksheets
  • IF and IFS
  • AND and OR
  • NOT
  • SWITCH
  • COUNTIF, AVERAGEIF, and SUMIF
  • PMT and NPER
  • TEXTJOIN and CONCAT
  • Text Functions
  • Creating Ordinal Numbers
  • Date and Time Functions

Module 2: Working with Lists

  • What is a List of Data?
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List

Module 3: Visualising Your Data

  • Chart Basics
  • Tools for Editing Charts
  • The Format Tool Tab
  • Line and Area Charts
  • Hierarchy Charts
  • Statistic Charts
  • Combo Charts
  • Using Recommended Charts
  • Sparklines
  • Add and Format Objects
  • Working with Icons
  • Working with SmartArt
  • Using the Quick Analysis Tool

Module 4: Working with Tables

  • Format Data as a Table
  • Table Design Tool Tab
  • Formatting Individual Cells
  • Selecting Table Rows and Columns
  • Modifying a Table in Excel
  • Structured References
  • Convert a Table to a Range

Module 5: Advanced Formatting

  • Cell Styles
  • Conditional Formatting
  • Highlight Cells Rules
  • Top/Bottom Rules
  • Data Bars, Color Scales, and Icon Sets
  • Create a New Rule
  • Removing Conditional Formatting
Show more blue-arrow

Who should attend this Intermediate Microsoft Excel 2019 M55269 Training Course?

The Intermediate Microsoft Excel 2019 M55269 Course is designed for individuals who already have foundational skills in Excel and wish to elevate their proficiency.  The professionals who will benefit from this course are:

  • Office Professionals
  • Project Managers
  • Financial Analysts
  • Accountants
  • Sales and Marketing Personnel
  • Human Resources Professionals
  • Retail Managers

Prerequisites of the Intermediate Microsoft Excel 2019 M55269 Training Course

There are no formal prerequisites of the Intermediate Microsoft Excel 2019 M55269 Course. However, some basic knowledge of Excel functionalities, familiarity with creating, editing, and formatting simple spreadsheets, might be beneficial.

Intermediate Microsoft Excel 2019 M55269 Training Course Overview

Microsoft Excel is an essential tool for data analysis, reporting, and automation in various industries. This course enhances proficiency by covering advanced formulas, data validation, and automation techniques. It helps delegates streamline workflows, improve efficiency, and gain a competitive edge in data management. By mastering these skills, professionals can optimise productivity and make informed business decisions.

This course is ideal for professionals who have basic Excel knowledge and wish to advance their skills. It is particularly beneficial for analysts, accountants, project managers, and business professionals who rely on Excel for data processing and decision-making. Enhancing Excel proficiency can lead to greater efficiency, improved reporting accuracy, and increased career opportunities in data-driven roles.

This 1-Day course, provided by The Knowledge Academy, equips delegates with practical skills to handle complex Excel functions efficiently. It covers essential topics such as advanced formulas, data validation, and automation, ensuring proficiency in handling large datasets. With hands-on exercises and expert guidance, delegates will develop the confidence to apply Excel's advanced features effectively. Completing this course can significantly enhance productivity and accuracy in data management, making it a valuable investment for professionals.

Course Objectives

  • To develop proficiency in using advanced Excel formulas and functions
  • To apply data validation techniques for improved accuracy
  • To create and manage PivotTables for effective data analysis
  • To automate repetitive tasks using macros and VBA
  • To utilise conditional formatting for enhanced data visualisation
  • To analyse large datasets efficiently using Excel’s built-in tools

Upon completion, delegates will have an in-depth understanding of Excel’s advanced features, enabling them to work efficiently with large datasets, automate tasks, and generate insightful reports. These skills will help professionals enhance their productivity and decision-making abilities in various industries.

Show more blue-arrow

What’s included in this Intermediate Microsoft Excel 2019 M55269 Training?

  • World-Class Training Sessions from Experienced Instructors
  • Intermediate Microsoft Excel 2019 M55269 Certificate
  • Digital Delegate Pack
Hands-On Labs: Included as part of our online instructor-led delivery, these labs provide real-world exercises in a simulated environment guided by expert instructors to enhance your practical skills.
Show more blue-arrow
Show more blue-arrow

Train Your Workforce

Looking for Intermediate Microsoft Excel 2019 M55269 Training in-house or onsite training in Saskatoon? We specialise in corporate group training and bulk bookings for organisations of all sizes in Saskatoon. Our trainers deliver tailored sessions at your premises, online, or hybrid, with best price guarantee, group discounts and flexible scheduling to train your team.

Our Saskatoon venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

Saskatoon, a city in the Canadian province of Saskatchewan, has an average population of roughly 222,190 spread across 65.9 square miles of land.  At The Knowledge Academy, we offer 50,000 classroom based training courses throughout the different areas of Saskatoon, in order to enhance people’s learning in an array of subject areas.  Education in Canada is generally funded by federal, provincial, and local governments; the system is divided into primary, secondary and post-secondary education and is operated under provincial jurisdiction.  On the whole, there are 190 days in a school year, starting in September and ending towards the last Friday of June.  Some popular and highly regarded universities in Canada include: the University of Toronto (notable alumni including: William Lyon Mackenzie King, Vincent Massey, Donald Sutherland and Lesra Martin), the University of British Columbia (notable alumni including: Eddie Peng, Justin Trudeau and Nardwuar the Human Serviette), and the University of Alberta (notable alumni including: Dayo Wong, George Stanley and Beverley McLachlin). 

Show moredown

Ways to take Intermediate Microsoft Excel 2019 M55269 Training in Saskatoon

Online Instructor-Led Learning

Online Self-Paced Learning

Onsite Learning

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Intermediate Microsoft Excel 2019 M55269 Training. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

classes

Live classes

Join a scheduled class with a live instructor and other delegates.

interactive

Interactive

Engage in activities, and communicate with your trainer and peers.

degree

Global Pool of the Best Trainers

We handpick from a global pool of expert trainers for our Online Instructor-led courses.

expertise

Expertise

With 10+ years of quality, instructor-led training, we equip professionals with lasting skills for success.

global

Scalable Training Delivery

Access Intermediate Microsoft Excel 2019 M55269 Training in Saskatoon delivered by one of the largest training providers, with scalable instructor-led classes, accessible worldwide.

Master Intermediate Microsoft Excel 2019 M55269 Training with a flexible yet structured approach that combines live, expert-led sessions and self-paced study. With Weekly one-to-one tutor support and consistently high pass rates, you’ll receive tailored guidance and achieve real results.

trainer

Structured Yet Flexible Learning

Take part in scheduled, instructor-led sessions with real-time feedback, while enjoying the freedom to study independently. Interactive resources and progress tracking tools help you stay motivated and on target.

venue

Engaging & Interactive Training

Join dynamic live sessions featuring discussions, practical activities, and peer collaboration. Learn from Intermediate Microsoft Excel 2019 M55269 Training industry experts and reinforce your knowledge with self-paced modules—plus, connect with professionals in your field.

classes

Expert-Led Course

Gain valuable insight from experienced trainers during live sessions, and revisit course materials anytime to deepen your understanding. This method offers the ideal balance between expert guidance and independent learning.

money

Global Training Accessibility

Access top-quality training across time zones—anytime, anywhere. Whether at home or on the go, our expert-led sessions and flexible study materials support your goals, and help you on the journey towards the certification.

Learn Intermediate Microsoft Excel 2019 M55269 Training through The Knowledge Academy’s Online Self-Paced Learning. This flexible and structured format supports your training goals and enables every professional to build skills with confidence.

flexiblelearning

Flexible Learning

Access Intermediate Microsoft Excel 2019 M55269 Training resources 24/7 to maintain steady progress, complete regular assessments or tasks, and upskill effectively alongside work commitments.

expert-developed

Expert-Developed Content

Our Online Course content is designed by experienced trainers to ensure accuracy, relevance, and practical value.

global-access

Global Training Provider

Access Intermediate Microsoft Excel 2019 M55269 Training in Saskatoon from a trusted global training provider delivering consistent learning to professionals worldwide.

cost-effective

Cost-Effective Training

Benefit from the cost-effective Intermediate Microsoft Excel 2019 M55269 Training that delivers high-quality course content without compromising learning outcomes.

interactive-lms

Interactive LMS

Track performance, download resources, and receive AI-enabled support through The Knowledge Academy’s dedicated Learning Management System.

Fri 10th Jul 2026

-

Fri 10th Jul 2026

View Price

1 day

Online Instructor-Led

Fri 13th Nov 2026

-

Fri 13th Nov 2026

View Price

1 day

Online Instructor-Led

Package deals for Intermediate Microsoft Excel 2019 M55269 Training in Saskatoon

Our training experts have compiled a range of course packages on a variety of categories in Intermediate Microsoft Excel 2019 M55269 Training, to boost your career. The packages consist of the best possible qualifications with Intermediate Microsoft Excel 2019 M55269 Training, and allows you to purchase multiple courses at a discounted rate.

Microsoft 365 Training | Intermediate Microsoft Excel 2019 M55269 Training in Saskatoon FAQs

There hasn't been any questions asked about this Topic

Which is the best training institute/provider of in Saskatoon?

The Knowledge Academy is one of the Leading global training provider for .

What are the best courses in Saskatoon?

Please see our courses available in Saskatoon

Show more blue-arrow

Customers Reviews

Request For Pricing

WHO WILL FUNDING THE COURSE?
+44

Corporate Training

Unlock tailored pricing and customised training solutions for your team’s needs.

Request your quote today!

Government of Canada Employees

Take advantage of our Standing Offers and Supply Arrangements with the Government of Canada to enjoy exclusive discounts when you register for training.

View Supply Arrangements

Courses Related to Microsoft 365 Training

Why choose The Knowledge Academy

price

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

trusted

Trusted & Approved

Recognised by leading certification bodies, we deliver training you can trust.

learning

Many delivery methods

Flexible delivery methods are available depending on your learning style.

resources

High quality resources

Resources are included for a comprehensive learning experience.

Our Clients

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water
santander barclays bmw google thames-water deloitte bupa tesla

Intermediate Microsoft Excel 2019 M55269 Training in Canada

cross

Upgrade Your Skills. Save More Today.

superSale Unlock up to 40% off today!

WHO WILL BE FUNDING THE COURSE?

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.