Logo Loading

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

Objectives

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will:

  • 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

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

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.

CONTACT US

Our Experts Are Here to Help