Microsoft (MS) Excel Advanced

Terms & Conditions Apply
CA$19*

BUY 1-MTH ACCESS MS OFFICE BUNDLE CONTACT US

CREDENTIAL

Course Certificate

Delivery

eLearning (Self-paced)

DURATION

Approx. 5-6 hours

CLASS SIZE

Private Link

PREREQUISITES

English CLB 7
See details below

Course Description

This course provides intermediate-level training in Microsoft Excel, focusing on advanced data management and visualization techniques. Participants will learn how to work with data tables, create and customize charts, and manage multiple worksheets and workbooks effectively. The course also covers essential skills for printing worksheets and securing sensitive data. By the end of the program, participants will be adept at organizing, analyzing, and protecting data, as well as presenting information clearly through charts and printed documents.

Course Outline

Mastering Lookup Functions

Learn how to use VLOOKUP and HLOOKUP functions to search for and retrieve data from large spreadsheets. This section covers how to apply these functions to match data in columns and rows, enhancing your ability to analyze and reference information efficiently.

Advanced Lookup Techniques

Discover how to create and customize charts to visually represent your data. This section provides techniques for selecting the right chart types and formatting options to make data trends and insights easily understandable.

Analyzing Data with PivotTables

Master PivotTables to summarize, analyze, and present data in a dynamic way. This section covers creating and customizing PivotTables to aggregate and explore data, making it easier to generate insightful reports and make data-driven decisions.