New Event: Excel Efficiency Transformation for Finance
Online Courses Power BI & Pivot Tables
Learn how to create a simple, but informative and interactive dashboard from daily updated data sourced from Johns Hopkins Institute. This uses on-cloud import using Power BI Dataflow. Interact with
Using Power Query, this type of work is extremely painless and quick. What’s more it refreshes data in just a click when more files are added.
While working with Power BI we often need to convert Seconds to Duration. This is easily done in Excel just by applying the formatting code “HH:MM:SS”. Unfortunately in Power Query
A brilliant new feature is now available in Power BI – Split column into rows. To understand why we need it, you must go and read the article – Analyzing
Here is a quick post to show the practical scenario when the Remove Top and Bottom Rows options are useful while cleaning up data using Power Query. Remove Top Rows
Here is another short but power packed video which explains how analytics can drive growth. Read the related articles here. [youtube https://youtu.be/W2sP3n7LYMo]
Often we get data which is distributed in multiple column sets. Here is how you can convert it to good data (tabular column format) using Power Query. Watch the video.
This is a simple check sheet. Usually done on paper. But with ubiquitous tablets being available, it can be done on Excel as well. Photo credit: The U.S. Army /
This is the worst type of input data to get. Each row has been split into two (or sometimes more) rows. We want those to be combined into a single
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
Join the Free Excel Efficiency Transformation for Finance Event
Sat 27th Feb, 3 pm IST
