At the end of the training, participants would be able to:Work with multiple worksheets and workbooks. Share and protect workbooks. Automate workbook functionality. Use Lookup functions and formula auditing. Forecast data. Create sparklines and map data.

Office professionals working with Microsoft Excel Data analysts and business intelligence professionals Financial analysts and accountants Project managers and team leads Individuals seeking to enhance their advanced Excel skills Professionals using Microsoft Excel for complex data analysis and reporting tasks

MIM1003 Microsoft Excel 365 - Advanced Level (2 Days)

Description

MIM1003 Microsoft Excel 365 – Advanced Level (2 Days)

Overview

This Excel training program covers functions, formulas and techniques for those who already have a strong foundation on Excel. This 2-day program aims to enhance your expertise in Excel to the highest level and ensure a comprehensive understanding of all the advantageous features Excel can offer your workplace.

This program can be tailored to your specific business needs.

A little bit of personalization goes a long way. Ask us for a no-obligation Training Needs Analysis (TNA) so we can tailor this, or any other CSG program to meet your learning outcomes.

Objectives

At the end of the training, participants would be able to:

Work with multiple worksheets and workbooks.
Share and protect workbooks.
Automate workbook functionality.
Use Lookup functions and formula auditing.
Forecast data.
Create sparklines and map data.

Duration

2 Days

Target Audience

Office professionals working with Microsoft Excel
Data analysts and business intelligence professionals
Financial analysts and accountants
Project managers and team leads
Individuals seeking to enhance their advanced Excel skills
Professionals using Microsoft Excel for complex data analysis and reporting tasks

Modules:

Module 1: WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS

Topic A: Use Links and External References
Topic B: Use 3-D References
Topic C: Consolidate Data

Module 2: SHARING AND PROTECTING WORKBOOKS

Topic A: Collaborate on a Workbook
Topic B: Protect Worksheets and Workbooks

Module 3: AUTOMATING WORKBOOK FUNCTIONALITY

Topic A: Apply Data Validation
Topic B: Search for Invalid Data and Formulas with Errors
Topic C: Work with Macro

Module 4: USING LOOKUP FUNCTIONS AND FORMULA AUDITING

Topic A: Use Lookup Functions
Topic B: Trace Cells
Topic C: Watch and Evaluate Formulas

Module 5: FORECASTING DATA

Topic A: Determine Potential Outcomes Using Data Tables
Topic B: Determine Potential Outcomes Using Scenarios
Topic C: Use the Goal Seek Feature
Topic D: Forecast Data Trends

Module 6: CREATING SPARKLINES AND MAPPING DATA

Topic A: Create Sparklines
Topic B: Map Data

MIM1003 Microsoft Excel 365 – Advanced Level (2 Days)

Description

MIM1003 Microsoft Excel 365 – Advanced Level (2 Days)

Modules:

Program Methodology

Choose a Training Partner that Stays Invested.

Tell Us What You Need, We’ll Make it Happen

MIM1003 Microsoft Excel 365 – Advanced Level (2 Days)

Description

MIM1003 Microsoft Excel 365 – Advanced Level (2 Days)

Modules:

Program Methodology

Choose a Training Partner that Stays Invested.

Tell Us What You Need, We’ll Make it Happen

Welcome Back

Sign In