I am a student of Xavier Institute of Communications and I undertook a course on Microsoft Excel by Faiyaz Khairaz sir and it was super interactive and fun! The content is very relevant and the teaching style made it easy to comprehend. Would recommend to anyone looking to grab similar skills!
About Mechamind
We are a Registered Singapore Based Company, offering LIVE Virtual Training in Advanced Excel to Companies in Singapore.
Our Trainers are Microsoft Certified with 17+ Years of Training Experience in Excel & Microsoft Applications.
All our training programs are conducted using Live Case Studies & Examples from real time corporate scenarios.
We urge the participants to apply what they have learnt to their Data, to get maximum benefit from the training program.
Power Pivot is an Application widely used across the globe, by employees at different levels of the corporate sector to analyse, organize and represent their data, in a concise and visually appealing manner.
Would you Like to Train Your TEAM & Empower them?
Our FREE ONLINE Demo Class, which can be scheduled at a time convenient to you, to give you a closer look at what the excel training program has to offer. This 90 Minutes Session would give your Team Members a Hand's on and practical experience of our training methodology, interactivity & participant engagement.
Looking for LIVE 1:1 Training Sessions ?
Why Join Groups, when you can learn as per your pace and at a time convenient to you.
A tailor made Microsoft Excel Program keeping in mind the requirements of the corporate sector which will empower you to get an edge above the rest.
Learn on your own DATA & practically apply what you have learnt in a STEP By STEP Manner.
Looking for LIVE 1:1 Training Sessions ?
Why Join Groups, when you can learn as per your pace and at a time convenient to you.
A tailor made Microsoft Excel Program keeping in mind the requirements of the corporate sector which will empower you to get an edge above the rest.
Learn on your own DATA & practically apply what you have learnt in a STEP By STEP Manner.
Power Pivot training in Singapore Objective
What is POWER QUERY in Excel?
Power Query ( Inbuilt in Office 365 & 2016, Add-in for 2013 ) in Excel, is used for ETL(Extract, Transform, Load). That means, data can be extracted from different sources, and after transforming, it can be loaded into the worksheet. It can be said that POWER QUERY is a data cleansing mechanism as it has all the possible options to transform the data. It performs real-time tasks and records all the steps which are performed.
Why Should You Use Power Query ?
Different Data Sources: We can load data into power query editor from different data sources, like, CSV, TXT, MS SQL Server, JSON, Web etc.
Transform Data Easily: Normally we use formulas and pivot tables for data transformations but with POWER QUERY we can do a lot thing just with few clicks.
It’s Real-Time: Write a query for once and it can be refreshed every time when there is a change
In this course, you will learn how to harness the capabilities of Power Query to resolve your data challenges and, in the process, save up to 80% of your data preparation time.
Let’s take a practical EXAMPLE for Power Query:
An HR Consultant, has been provided with the below Data, where 705 employees have been asked 25 Questions regarding their opinion, about the COMPANY, and we have to analyse each of the 25 Questions, depending on their Score,Go Ahead Try it ( Nothing like a Practical Example ).
Phase 1 - Power Pivot Course Syllabus
Introduction to Power Query
- Power Query Introduction
Import Data into Power Query
- Import Data from Excel File
- Import data from other files / folder
Loading and Refresh
- Load data and refresh query when source data change
Data Transformation
- Column Transformation
- Row Transformation
In built transformation in Power Query
- Text Transformation
- Numbers transformation
- Date transformation
- Conditional Column transformation
Consolidate and Append Data
- Append data from Excel tables within same Excel file
- Append / Duplicate / Reference multiple Queries
- Import data from files in a folder
- Import data from multiple excel files in a folder
- List of files in folder
- Changing file path for source data
Phase 1 - Power Pivot Course Syllabus
Merge Queries / Multiple Joins in Power Query
- Multiple JOINS in power query (Merge Queries)
- Different Joins in Power Query
- Cross Joins / Cartesian Product of Two tables
Building blocks for M language
- Introduction to building blocks in M
- Text functions in Power Query
- Date functions in Power Query
- Conditional Functions in Power Query
Case Studies
- Self-Service BI
- Power Pivot
- Power Query
Power Query Objects
- List as object and List functions in Power Query
- Record as object and Record functions in Power Query
- Table & other objects and Table functions in Power Query
- Power Query Objects
Mr. Faiyaz Khairaz
( Microsoft Certified Trainer
Experience : 17+ years )
Hi, my name is Faiyaz M Khairaz. I'm a Microsoft Certified Trainer & (Power BI DA-100 Certified) with 17+ Years of Training Experience.
I have Conducted training for Corporates such as Deloitte, PwC, Kuoni. Trained over 83k participants till date
Talk To The Trainer
GET IN
TOUCH
TOUCH
- +65 8951 7001
- training@mechamind.sg
Enquire About Our Programs
Training Images
training@mechamind.sg