Learn Excel Power Query

By a top Microsoft Excel Specialist & Microsoft Certified Trainer

Join Now

Watch at your convenience

Who is this workshop for?

Data Analyst
MIS Executive
Accountant
Financial Analyst

What will you learn in this workshop?

Day 1

  •  Introduction to Power Query
  • Combining 2 Columns
  •  Power Query Editor
  •  Change Case

Day 2

  • Filling Blank Cells
  • Separate Non Digit to Digit
  • Adding More Records
  • Combining Sheets Project 1

Day 3

  • Sheets Project 2
  • Adding New Data
  • Deleting Queries
  • Combining Files

Day 4

  • Adding Extra Files to Combine
  • Fixing Date Issue
  • Power Query Project 1

Day 5

  • Power Query Project 2
  • Power Query Project 3 (UnPivot Data)
  • Quiz

Meet your Trainer

Ramzan is passionate about telling stories with data. Microsoft Certified Trainer,Excel Specialist with Power BI.

17+ years of experience in managing large databases, from requirements gathering through implementation and support.
Currently serving corporate clients across Gulf and Europe taking care of their training programs, helping them in preparing & analysing customized summaries & MIS Reports, Creating Dynamic HR, Sales & Financial Dashboards, Automating regular reports with Macros and Creating Interactive Dashboards using Power BI

Have conducted sessions in corporates such as Ferrari, Landmark, National Bank of Fujairah, Roche, King Span and many other companies in UAE, India, Saudi Arabia, Oman, Qatar, Malaysia & Maldives with excellent feedback.
Have trained more than 55,000+ people from various companies from Junior to Senior management across GCC locations.
Ramzan helps answering business questions using data in creative ways.

You may not believe me, but you can believe them

Experiences shared by people who previously attended my workshop

Time is running out! Register Now for FREE Webinar

  • 00Hours
  • 00Minutes
  • 00Seconds

Fees will increase by Rs 2000 once this clock hits ‘ZERO’

Frequently Asked Questions

We have answered all common questions below that you might have about the workshop. For any further queries, please reach us at contact@upgradeskill.in

I made the registration but didn’t receive any email

Write to us at contact@upgradeskill.in and our support team will be able to resolve your issue in the shortest amount of time.

Will this be live or pre-recorded?

The workshop will be pre-recorded so that you can watch anytime – anywhere

How much experience do I need for this workshop?
There is no prior experience required for this workshop.
Will I get a certificate after completion?

Yes you will receive a certificate of completion. 

What is the time zone?

All the videos are pre-recorded, hence you can watch and your own time zone.