Combine data from multiple files / sheets
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.
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
Just released Excel Tables comprehensive video. Have a look. It shows many benefits of using Tables like automatic formula copy, dependents update, structured formulas, automatic headers, easier import in Power
Best practices for conducting Teams Live Events. What I learnt the hard way while conducting a series of 15 live events.
This was conducted in March 2020, during the COVID lock-down. All videos are 15 minutes followed by Q&A from live attendees. 15 days, 15 topics, 15 minutes each. Live Event
I attended the Microsoft recently MVP summit – it was a three-day event conducted as a Teams online conference. 100’s of sessions, 1000’s of attendees. I want to share this
New and very useful feature for artists and designers. Specify accurate colour value using HEX code instead of RGB or HSL. What difference? Well, HEX codes are most commonly used.
Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
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.
