You are here: / / / Microsoft Excel Training – Advanced

MSEX102

Microsoft Excel Advanced Training

Duration:22.5 Hours (Over 5 ~ 6 days)
Language:English
Platform:Windows
Format:Option 1:  Online Live Instructor-led
Option 2:  In-Class with Instructor
Class Size:1 ~ 5 Participants
Who should attend:Students, job seekers, office workers, small business owners, and anyone new to Excel who wants to build practical spreadsheet skills.
Pre-requisite:Basic knowledge of Microsoft Excel, including working with cells, formulas, and simple charts.
Key Outcomes & Highlights:Master advanced formulas, data analysis, automation, and dashboard creation to boost productivity and stand out professionally.

Dates coming soon…

No start dates available at the moment.

SKU: MSEX102 Category: Tags: , , , , , , , , , , , , ,

Course Curriculum

  • Using Logical & Lookup Functions
    • IF, IFS, AND, OR, NOT functions
    • VLOOKUP, HLOOKUP, INDEX, MATCH
  • Working with Nested Functions
    • Combining multiple functions for complex formulas
    • Error handling with IFERROR and ISERROR
  • Named Ranges & Formula Auditing
    • Creating and managing named ranges
    • Using Trace Precedents and Evaluate Formula
  • Data Cleaning with Text & Date Functions
    • TEXT, LEFT, RIGHT, MID, TRIM, LEN
    • DATE, DATEDIF, NETWORKDAYS, TEXTJOIN
  • PivotTables and PivotCharts
    • Creating, formatting, and filtering PivotTables
    • Generating PivotCharts for visual analysis
  • Data Grouping and Slicers
    • Grouping by date, value ranges, or text
    • Adding and customizing Slicers for interactivity
  • What-If Analysis
    • Using Goal Seek and Data Tables
    • Working with Scenario Manager
  • Advanced Conditional Formatting
    • Formulas within conditional formatting
    • Visual indicators for trends and errors
  • Data Validation & Error Prevention
    • Creating dropdown lists and input restrictions
    • Using custom validation formulas
  • Power Query Basics
    • Importing and transforming data
    • Cleaning and shaping data with queries
  • Consolidating & Linking Data
    • Consolidating data from multiple sheets/workbooks
    • Using formulas to link external data
  • Text to Columns & Remove Duplicates
    • Splitting data into columns
    • Identifying and removing duplicates efficiently
  • Introduction to Macros
    • Recording, editing, and running macros
    • Storing macros in Personal Macro Workbook
  • Using the VBA Editor
    • Basic VBA structure and logic
    • Creating buttons and assigning macros
  • Macro Security and Management
    • Understanding macro-enabled workbooks
    • Setting trusted locations and enabling content
  • Building Reusable Scripts
    • Automating repetitive tasks
    • Tips for writing efficient VBA code
  • Designing Excel Dashboards
    • Planning layout and data flow
    • Using charts, slicers, and dynamic ranges
  • Interactive Elements & Form Controls
    • Checkboxes, drop-downs, scroll bars
    • Linking form controls to calculations
  • Building a Final Dashboard Project
    • Combining key concepts into one file
    • Creating a summary report or KPI dashboard
  • Review & Q&A
    • Recap of all tools and techniques covered
    • Hands-on review and final questions
read more

What is Microsoft Excel Advanced Training?

Microsoft Excel Advanced Training is designed for users who already know the basics and want to unlock the full potential of Excel. This course dives into complex formulas, data analysis tools, automation with macros, and dynamic dashboards. It’s perfect for those who need to handle large datasets or create professional reports.

Who is this course for?

  • Professionals working with data, reports, or KPIs
  • Accountants, analysts, project managers, and admin staff
  • Anyone looking to boost Excel efficiency and master advanced functions
  • Excel users who want to upskill for better career opportunities

Why is advanced Excel important?

Advanced Excel skills help you manage, analyze, and visualize data efficiently. You’ll be able to automate repetitive tasks, build dashboards, and make informed decisions using tools like PivotTables, advanced formulas, and Power Query. These capabilities are essential in today’s data-driven workplace.

How can this course help your career?

Advanced Excel skills are highly valued in nearly every industry. This course will set you apart by enhancing your ability to work with complex data, streamline workflows, and contribute more effectively to decision-making and reporting processes.

Contact Us