4.8 (5 ratings)
Microsoft Excel 2016 or newer version
For Excel 2010 & 2013 Power Query is available through a free download
Basic to Intermediary knowledge of Microsoft Excel.
1. What is Power Query ?
Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations.
2. What is the benefit of Power Query?
Business users spend up to 80 percent of their time on data preparation, which delays the work of analysis and decision-making. Several challenges contribute to this situation, and Power Query helps address many of them.
Because Power Query provides connectivity to hundreds of data sources and over 350 different types of data transformations, for each of these sources, you can work with data from any source and in any shape.
3. Who is this course for?
Once you make the payment, you will receive the credentials from our team to attend the same. As it is self paced learning with on-demand videos, you will need these credentials to join the training. You can attend this Masterclass from any Windows or Android based device - Laptop, Desktop, Tablet, Mobile, etc.
The lessons are self-paced, online videos. Most of the videos are shorter in length and these are nicely organized by topic. Since the videos are short, we recommend watching one or two videos during your lunch break, or maybe one in the morning before you open your email. Each video lesson gets right to the point and packs in just enough information to allow you to learn and practice the techniques.
We look at it like building a house… If you just need to patch a roof or repair a leaky tap, then YouTube is an awesome way to learn. But what if you need to build the entire house? Where do you even start? Probably not with the roof. But other than that you would be doing a lot of searching and piecemeal learning to figure it out. This training course helps a learner connect the dots between “learning excel” and producing a work product that the business needs. We want to help people connect the dots between learning the new skill and getting a specific job done. Eventually, at the end, you need results and transformation.
Don't Worry! These videos are designed for your Life Time access. You can view those videos at your own time, speed and convenience. So you will never miss a class.
Keeping in mind the majority of learners, it will be done in English. You will really find it easy to learn and enjoy the training since the course lessons are designed with simple yet in-depth explanations.
Drop in a mail to firstname.lastname@example.org and we shall be getting back to you.