Logo Loading

MIM1005_A – 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.

Objectives

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

  • 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

  • Typically spans 2 days (9am to 5pm).
  • Nonetheless, we can customize both the program’s duration and schedule to cater to unique client requirements (e.g., compact 1-day workshops or extended sessions beyond 3 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

PROGRAM OUTLINE

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 to
  • 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

PROGRAM METHODOLOGY

  • Hands-on Activities: Practical exercises to reinforce theoretical concepts.
  • Group Discussions: Opportunities for peer-to-peer learning and exchange of ideas.
  • Role Plays: Simulations of realistic situations to build practical skills.
  • Feedback Sessions: Reviews and reflections to encourage improvement.
  • Problem-solving Exercises: Develop critical thinking and decision-making skills.
  • Experiential Learning: Learning by doing, promoting active involvement.
  • Interactive Lectures: Engaging presentations by experts in the field.
  • Case Studies: Real-world scenarios for learners to apply their knowledge.
  • Quizzes & Tests: Regular assessments to track learning progress.

It’s very informative and the knowledge given and practices that we did in class is helpful.

Claim Executive

Sector: BPO

I liked how the trainer is very knowledgeable and tries to be engaging to all of the participants in the session.

Engineer

Sector: Manufacturing

CONTACT US

Our Experts Are Here to Help