The Ultimate Microsoft Excel Mastery (Dashboard, Power Pivot & Power Query) in just 2 days

Dive into the functionalities of these tools to help you better understand and utilize Excel for data analysis and visualization. Whether you’re a beginner seeking to improve your spreadsheet skills or a seasoned user wanting to explore advanced features, we’ll walk you through the ins and outs of Dashboard, Power Pivot and Power Query.

Discover how to transform raw data into meaningful insights and create effective dashboards. Understand the process of building relationships between data tables, creating calculated columns, and using Data Analysis Expressions (DAX). Learn how to connect to various data sources, clean and transform data, and create seamless workflows. Whether you’re dealing with large datasets or multiple sources

Excel Dashboard Development: Power Query & Power Pivot Essentials

Learn how to master microsoft excel mastery in just 2 days

Microsoft Excel Mastery (Dashboard, Power Pivot & Power Query)

In this class, you will familiarize yourselves with the features Power Query, Power Pivot, Cleaning Data and Dashboard. If you have the basic knowledge of Excel charts, pivot tables, functions and formulas, you can proceed to this course to learn how to create dashboard out of your, example sales data, that allows you to interactively slice-and-dice within the data and gain greater insights out of your company’s business performance.

Excel Mastery allows you to understand what Dashboard, Power Query and Power Pivot is and gain greater insights.

Who is it for: To optimize the learning experience in our Excel Mastery course, encompassing Dashboard, Power Pivot, and Power Query, participants are expected to possess a foundational understanding of Excel, including familiarity with creating charts, pivot tables, and utilizing functions and formulas.

Take Note: Participants must have basic knowledge of Excel charts, pivot tables, functions and formulas.

Duration: 2 Days

Cost: Normal price RM2450 – *Promotional Price* RM1890

 

Details & Booking

Course Content
Day 1
1) Extract Data From Multiple Sources 
  • Installation Steps for Power Query
  • Import data from Excel file
  • Import data from the Web
  • Import data from CSV file
  • Import data from Access File
  • Import data from Text file
  • Refreshing Data

    2) Transform Data
  • Cleaning Dirty Data
  • Define Data Format
  • Renaming Columns
  • Append Data from Different Tables
  • Merge Two or More Different Tables

3) Load Data
  • Load Clean Data into Excel
  • Load into Data Model

    4) Power Query Formula Language
  • Introduction to Power Query Formula Language
  • Advance Editor
  • Simple Formula
  • Create a formula function

Day 2
5) Introduction to Power Pivot
  • Installation Steps for Power Pivot
  • Limitation of Normal Pivot Table
  • Power Pivot Interface
  • Import external data from multiple sources
  • Client database
  • Excel tables
  • CSV files

6) Building your data model and linking
  • Handling massive data from multiple sheets
  • Create relationships between multiple tables
  • How to create a user friendly models

7) Custom Columns and Calculation
  • Perform calculations in PowerPivot
  • Calculated columns
  • Measures (Calculated fields)
  • Create Pivot Tables and Pivot Charts
  • Introduction to Data Analysis Expression language (DAX)

8) Presentation using Pivot Table and Chart
  • Introduction to Dashboards
  • Create Pivot Table based on Data Model
  • Display Related Data from Different Sources in One Table
  • Experimenting Slicers and Timelines
  • Create Pivot Chart


Class Duration and Schedule

Aside from this we also conduct short courses that cover all the essentials and advanced knowledge of Ms Excel.

Microsoft Excel Basics – 1 days
Microsoft Excel Intermediate – 1 days
Microsoft Excel Advanced –  1 days
Microsoft Excel Mastery (Dashboard, Power Pivot & Power Query) – 2 days

Our classes start at 9:00 am to 5:00 pm with regular breaks. These breaks give the participants time to rest and to process the information that they receive during the course.

**Free Repeats**

To help our participants better, we offer free repeat classes. Students can revisit the institute and refresh their skills if needed. These free repeat classes are available every month. 

Details & Booking

Who Should Attend

Our Microsoft Excel Mastery (Dashboard, Power Pivot & Power Query) courses are designed for a diverse range of individuals, including business analysts, data analysts, financial analysts, project managers, and professionals involved in data visualization and reporting.

It caters to those seeking to enhance their Excel skills and unlock the advanced capabilities of Power Pivot and Power Query for efficient data analysis and manipulation. 

 

Classroom Training and Facilities

 

Our training centre is located in Bandar Puteri, Puchong and is only a 2-minute walk from the Bandar Puteri LRT station with many restaurants nearby. For those who drive, nearby there is a shaded car park which is free. Due to its proximity, our centre gets many students from Kuala Lumpur and Klang Valley.

 

    • Our training sessions are held in a classroom setting. The instructor teaches the theory and shows various practical examples. 
    • Participants also get to try out numerous exercises and experience the learning-by-applying concept.
    • The training style consists of 70% practical and 30% theory, workshop style. We intend that students learn more by doing rather than just listening.
    • You will receive personal guidance from our trainers during the class. 
    • Our trainers will have Q&A sessions to answer the various questions throughout the class.
    • Our typical class size is between 6-10 students. This setup allows our trainers to spend more time with each of their students.

 

[Covid-19 Update]

At CAD Training Centre, we take social distancing and SOP regulations very seriously in the interest of the safety of our fellow participants.

Our training centre is sanitized and disinfected regularly. There are ample hand sanitizers placed around the room.

Our classroom settings follow the standard guidelines of 1-meter space between participants’ seating areas and 1.5 meters space between the table rows. Safety and wellbeing of our students is our number one priority.

 

Online Training

 

Our online classes are conducted via digital platforms such as Zoom and Cisco Webex. Classes are both exciting and relaxed as our trainers have a lively approach that works well for online training. We also designed the lessons to promote ease of learning. 

Our experienced trainers will teach and guide the students with practical hands-on exercises that are done via screen sharing.

Because there are no geographic limitations, our students are from all over Malaysia.

 

In-house and Corporate Training

 

We also conduct in-house training programmes based on request. 

Why Choose Us

 

Free Repeats & Tutorials

We offer free unlimited repeats, no questions asked. 

In rare instances, some students are unable to digest all the information at one go and may need a refresher.   

Also, we have our students’ best interests at heart and want them to leave the class with full confidence. 

Upon completing the course, we also provide free online tutorials for your continuous learning.

Professional Certification 

Upon completing the Excel Mastery course, a Certification of Achievement will be issued.

We have professional certification issued by our partners at UTM (University Technology Malaysia) and other professional bodies.

CIDB & MOF Registered Provider

Our institute is a registered training provider for the Construction Industry Development Board (CIDB). As such, we provide CCD points under the Continuous Contractor Development program as required by the construction industry. Participants from the construction industry will receive CCD points for attending our training courses. 

We are also a registered training provider with the Ministry of Finance, MOF.

HRDF Claimable

We are accredited by the Human Resource Development Fund, HRDFAll our courses offered by us are HRDF claimable under the ‘SBL’ Scheme.

Beginner Friendly

We are known for our tagline “Start from zero!” – students do not need any prior knowledge or experience to take our basic courses.

Conducive Learning Experience 

Our classes focus on the practical aspects and less about theory to the ratio of 70:30 – we found that this approach helps with learning and remembering. 

Our class sizes are small at about 4-12 pax per session, and this gets each student more attention from the trainer.

Learning Aids

We provide laptops during the classroom sessions for your convenience.

During your training, a handbook will be given for your reference.

Meal options are also provided.

Our intention is for you to focus on the training and not worry about what to bring to class.

 

Frequently Asked Questions

What is Microsoft Excel Mastery (Dashboard, Power Pivot & Power Query) course all about?

Discover the Excel Mastery course—your gateway to creating dynamic dashboards, mastering Power Pivot, and streamlining data with Power Query. Perfect for business and data professionals, it’s the key to elevating your Excel skills for effective data analysis and decision-making.

What are the benefits of learning Excel Mastery?

Elevate your data analysis capabilities with our Microsoft Excel Mastery (Dashboard, Power Pivot & Power Query) course.

Gain the skills to create dynamic dashboards, master advanced data modeling, and streamline data manipulation. Ideal for business analysts and data professionals, this course empowers you to make informed decisions, enhancing your proficiency in Excel.

What are the prerequisites?

A prerequisite for this course includes having a foundational understanding of the Microsoft Windows operating system, familiarity with data warehouse schema topology, exposure to basic programming concepts, and an awareness of key business priorities, with a particular emphasis on revenue, profitability, and financial accounting; additionally, familiarity with Microsoft Office applications, especially Excel, is beneficial.

How long does it take to learn Excel Mastery?

Participants must have basic knowledge of Excel charts, pivot tables, functions and formulas.

What is the difference between classroom learning vs online courses? 

Classroom Learning

    • Participants will attend the course at the training centre in Bandar Puteri, Puchong.
    • Face to Face Interaction with the trainer in a classroom setting.
    • Immediate guidance & attention from the trainer
    • More focused
    • Learning among other participants during exercises

Online Course

    • Participants will attend the course using online platforms such as Zoom and Cisco Webex
    • Can save on travel and food expenses
    • Learn from the comfort of your own home/office
    • More flexibility
    • Able to discuss with people from different companies.

What Participants Say

We have trained many well-known companies and individuals who completed their course highly satisfied. We feel honoured to receive their encouraging feedback and positive reviews.

Enrol Today

Begin your journey in mastering Excel Mastery today. Getting started is easy; just click an option below:

 

 

WhatsApp chat