Excel for Finance and Accounting – Best Practices
Finance and Accounting departments use Excel extensively. Advanced Excel is still the most sought after topic for training programs globally. We conducted this live event on 27th Feb 2021. This
Finance and Accounting departments use Excel extensively. Advanced Excel is still the most sought after topic for training programs globally. We conducted this live event on 27th Feb 2021. This
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
Grouping is a common requirement for summarizing and reporting data. We explore Power BI grouping in this series of videos. This is a companion article for the video series. Ideally,
We have already learnt how to import and clean data from various sources using Power Query (Transform). Once the data is inside Power BI Data tab (or Excel Data Model
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.
This is a part of data clean up series based upon the 10 rules for clean data. This video covers rules 1, 5, 6, 10 – cross-tabs, data growing horizontally
Starting a new video series on Power BI. Here is the first video: Power BI Data Import.
We spend lot of time in data cleaning. But there is no simple definition of exactly what clean data means. Therefore, I created a simple 10 item checklist. If all
I have noticed that most customers are reluctant to pay the 9$ license cost for Power BI. Here is how you can use Power BI free of cost. I am
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.
