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.
Duration
2 days / 16 hours
Level
Intermediate to Advanced
Delivery
100% Online - Instructor Led
Request For Information
Key Features
- 16 hours of instructor led training
- Fully Online
- Class recording available
- Interactive Learning
- Additional Coaching Session
- 100% HRDF SBL-KHAS Claimable!
Pre-Requisites
- Intermediate Microsoft Excel Knowledge
- Analytical Mindset
- Willingness to self learn online
- No prior experience is required
- We will start from the very basics
- Committed to complete all tasks
Who Should Join
- Directors
- General Managers
- Chief Financial Officers
- Finance Managers
Course Modules Covered in the Microsoft Excel
Advanced program
Module 1 - The Basics
The Basics
- Getting Started
- Signing In
- Creating a New Workbook
- Understand the Basic Parts of a Workbook
- Saving a Workbook
- Opening a Workbook
Module 2 - Working with Data
Working with Data
- Inserting Rows and Columns
- Merging and Splitting Cells
- Moving Cells
- Using Paste Special
- Using Find and Replace
- Hiding and Unhiding Cells
Module 3 - Formatting Data
Formatting Data
- Wrapping Text
- Changing the Size of Rows and Columns
- Adjusting Cell Alignment
- Changing Text Direction
- Changing Number Format
Module 4 - Working with Formulas
Working with Formulas
- Concept of Formulas
- Understanding Relative and Absolute Cell References
- Understanding Named Ranges
- Defining Named Ranges
- Editing Named Ranges
- Deleting Named Ranges
- Using Named Ranges in Formulas
- Using Array Formulas
- Using 3D References
Module 5 - Working with Functions
Working with Functions
- Concept of Functions
- Using Advanced Functions
- Using Logical Function: IF
- Using Logical Function: AND
- Using Logical Function: OR
- Using Logical Function: IFS, SWITCH
Module 6 - Working with Functions(II)
Working with Functions(II)
- Using Statistical functions: AVERAGEIF, COUNTIF
- Using Lookup Functions: VLOOKUP, HLOOKUP, LOOKUP
- Using Text functions: TEXTJOIN, CONCAT
- Using Statistical Functions: MAXIFS and MINIFS
Module 7 - Working with Table
Working with Table
- Converting Data in range as a Table
- Total the Data in Table
- Removing Duplicates from Table
- Using Sort and Filter
Module 8 - Managing Data
Managing Data
- Consolidating Information
- Removing Duplicates
- Configuring Data Validation
- Converting Text to Columns
Module 9 - Outlining and Grouping Data
Outlining and Grouping Data
- Outlining Data
- Showing and Hiding Outline Details
- Grouping Data
- Creating Subtotals
- Removing Outlining and Grouping
Module 10 - Data Visualization
Data Visualization
- Understand Types of Charts
- Box & Whisker compares sets of data
- Creating Treemap Chart
- Creating Waterfall Chart
Module 11 - Analyzing Data
Analyzing Data
- Using Goal Seek
- Using Data Tables
Module 12 - Pivottable Features
Pivottable Features
- Creating a Basic PivotTable
- Creating a Basic PivotChart
- Using the PivotTable Fields Pane
- Adding Calculated Fields
- Sorting Pivoted Data
- Filtering Pivoted Data
- Using Slicers
- Creating Timelines
Our Training Methodology
Practical Assignments
We provide hands-on assignments that requires practical implementation.
Virtual Coaching Sessions
Online coaching sessions that happen over the phone, via video, or on a web platform.
1 Year Access to LMS
Get access to learning resources upto 1 year of class completion.
Live Project Experience
Hands-on learning and training gives participants the opportunity to experience real world situations.
Online Assessments
Participants can assess reflect on their own learning and their level/skills.
Free Industry Webinars
Stay current on market research trends, learn best practices through our webinar sessions.
Program Key Highlights
48 hours of Remote Online Learning
Additional Coaching Hours
Live Hands-on Projects
Certified by International Body
Mentorship with Industry Experts
Designed for Beginners & Professionals
Request For Information
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.
Thulija Academy is a HRDF registered training provider. Our panel of expert trainers provide technology training for some of the biggest organizations in Asia.
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