📽 New Video Upload : Introduction to Excel Pivot Tables
Sometimes, we use functionality in an Office App and forget that what is easy for…
Office 365
Productivity
Office 365
Productivity
📽 Introduction to Power Query: it’s simple than you may think
What is Power Query? Power Query is a data transformation and data preparation engine. source: https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query This…
Office 365
Productivity
How to fix a dirty data in Excel? (using PowerQuery)
The issue: More than once, you have received a spreadsheet with hundreds of rows and…