At the end of the training, participants would be able to:Create advanced formulas Analyse Data with Logical and Lookup Functions Create and Modify Tables Sort and Filter Data Use Subtotal and Database Functions to Calculate Data Visualise Data with Charts Create Advanced Charts Create a PivotTable Filter Data by Using Slicers

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

MIM1005 Microsoft Excel 365 - Intermediate Level (2 Days)

Description

MIM1005 Microsoft Excel 365 – Intermediate Level (2 Days)

Overview

This course advances the user’s knowledge of functions, demonstrates how to manage data with Excel. The objective of this course is to provide delegates with a brief review of Microsoft Excel basics and then introduce the intermediate features of Excel.

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:

Create advanced formulas
Analyse Data with Logical and Lookup Functions
Create and Modify Tables
Sort and Filter Data
Use Subtotal and Database Functions to Calculate Data
Visualise Data with Charts
Create Advanced Charts
Create a PivotTable
Filter Data by Using Slicers

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 Formulas

Basic Formula
Relative, Absolute, and Mixed Cell References
Using Named Ranges in Formulas
Naming a Single Cell
Naming a Range of Cells
Naming Multiple Single Cells Quickly
Using Formulas That Span Multiple Worksheets

Module 2: Analysing Data with Logical and Lookup Functions

Use Text Functions
Use Logical Functions
Use Lookup Functions
Use Date Functions

Module 3: Organising Worksheet Data with Tables

Create and Modify Tables
Sort and Filter Data
Use Subtotal and Database Functions
Calculate Data

Module 4: Visualising Data with Charts

Create Charts
Modify and Format Charts
Create a Trendline
Create Advanced Charts

Module 5: Analysing Data with PivotTables, Slicers, and Pivot Charts

Create a PivotTable
Filter Data by Using Slicers
Analyse Data with Pivot Charts

Module 6: Inserting Graphics

Insert and Modify Graphic Objects
Layer and Group Graphic Objects
Incorporate SmartArt

Module 7: Enhancing Workbooks

Customise Workbooks
Manage Themes
Create and Use Templates

MIM1005 Microsoft Excel 365 – Intermediate Level (2 Days)

Description

MIM1005 Microsoft Excel 365 – Intermediate Level (2 Days)

Modules:

Program Methodology

Choose a Training Partner that Stays Invested.

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

MIM1005 Microsoft Excel 365 – Intermediate Level (2 Days)

Description

MIM1005 Microsoft Excel 365 – Intermediate 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