Microsoft Excel

Advanced

Take your skills to the next level
with Microsoft Excel Advanced


Get in Touch With Us
Microsoft Excel

Advanced

Learn to create Excel
dashboards in minutes

Take your skills to the next level with Microsoft Excel Advanced


This Advanced Microsoft Excel training class is designed for participants to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros. workbooks.
Course Modules Covered in the Microsoft Excel Advanced program
Module 1 - The Basics

The Basics

  1. Getting Started
  2. Signing In
  3. Creating a New Workbook
  4. Understand the Basic Parts of a Workbook
  5. Saving a Workbook
  6. Opening a Workbook 
Module 2 - Working with Data

Working with Data

  1. Inserting Rows and Columns
  2. Merging and Splitting Cells
  3. Moving Cells
  4. Using Paste Special
  5. Using Find and Replace
  6. Hiding and Unhiding Cells 
Module 3 - Formatting Data

Formatting Data

  1. Wrapping Text
  2. Changing the Size of Rows and Columns
  3. Adjusting Cell Alignment
  4. Changing Text Direction
  5. Changing Number Format
Module 4 - Working with Formulas

Working with Formulas

  1. Concept of Formulas
  2. Understanding Relative and Absolute Cell References
  3. Understanding Named Ranges
  4. Defining Named Ranges
  5. Editing Named Ranges
  6. Deleting Named Ranges
  7. Using Named Ranges in Formulas
  8. Using Array Formulas
  9. Using 3D References 
Module 5 - Working with Functions

Working with Functions

  1. Concept of Functions
  2. Using Advanced Functions
  3. Using Logical Function: IF
  4. Using Logical Function: AND
  5. Using Logical Function: OR
  6. Using Logical Function: IFS, SWITCH 
Module 6 - Working with Functions(II)

Working with Functions(II)

  1. Using Statistical functions: AVERAGEIF, COUNTIF
  2. Using Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP
  3. Using Text functions: TEXTJOIN, CONCAT
  4. Using Statistical Functions: MAXIFS and MINIFS 
Module 7 - Working with Table

Working with Table

  1. Converting Data in range as a Table
  2. Total the Data in Table
  3. Removing Duplicates from Table
  4. Using Sort and Filter 
Module 8 - Managing Data

Managing Data

  1. Consolidating Information
  2. Removing Duplicates
  3. Configuring Data Validation
  4. Converting Text to Columns
Module 9 - Outlining and Grouping Data

Outlining and Grouping Data

  1. Outlining Data
  2. Showing and Hiding Outline Details
  3. Grouping Data
  4. Creating Subtotals
  5. Removing Outlining and Grouping
Module 10 - Data Visualization

Data Visualization

  1. Understand Types of Charts
  2. Box & Whisker compares sets of data
  3. Creating Treemap Chart
  4. Creating Waterfall Chart
Module 11 - Analyzing Data

Analyzing Data

  1. Using Goal Seek
  2. Using Data Tables
Module 12 - Pivottable Features

Pivottable Features

  1. Creating a Basic PivotTable
  2. Creating a Basic PivotChart
  3. Using the PivotTable Fields Pane
  4. Adding Calculated Fields
  5. Sorting Pivoted Data
  6. Filtering Pivoted Data
  7. Using Slicers
  8. Creating Timelines
Our Training Methodology
Program Key Highlights

online-learning-2
48 hours of Remote Online Learning
learning-hours
Additional Coaching Hours
hands-on
Live Hands-on Projects
certification
Certified by International Body
mentor
Mentorship with Industry Experts
industry
Designed for Beginners & Professionals
Get in Touch With Us Today!

This training program is suitable for anyone who intends to enter into the field of Microsoft Excel. This program is being conducted in Malaysia and can be joined by anyone, anywhere in the world remotely.
Program Fee

MYR 1300 per pax.

Funding Schemes for Companies who are claiming from their HRDF levy or from the SBL Khas scheme.

One-time fee. One year access to course materials and resources.
 
 



READY TO KICKSTART YOUR CAREER?
Please fill in the form and a Program Advisor will reach out to you. You can also reach out to us at info@thulija.com or +60123661502
Contact us on Whatsapp for more enquiries