How to use Power Query to import CSV files
In the previous article we saw the problem with importing CSV files. Here is how the new Power Query can be used to clean the data while importing. Estimated reading
In the previous article we saw the problem with importing CSV files. Here is how the new Power Query can be used to clean the data while importing. Estimated reading
This is a very common and dangerous inaccuracy. Big operational risk! Check all your dates imports after reading this article. Share it with your colleagues as well. Estimated reading time
Yes. You read it correctly. Everyone does it. But still.It is very dangerous. DO NOT do it. Read on to find out why. Estimated reading time 7 min
A very useful feature which is commonly not known. It requires a one-time configuration. Read it and do it immediately! Social updates can now be seen right within Outlook.
In the earlier article, we explored a new method of learning. In this article, we will find practical scenarios where the learning about Go To Special can be applied. Estimated
Here is a real, useful example of how to apply the learning from the previous article. We use these three Paragraph settings to get unbelievable results – instantly. Estimated reading
Learning all available features is necessary. But how exactly do you do it? Here is a simple but effective process. Estimated reading time 7 min
In the previous article, we saw how to create custom sorting order using a separate month table.Now we will see how a new type of table called Time Table can
Here is the Power Pivot way of customizing sort order for any column. We will continue with the month sorting order example. Read the previous article first. Estimated reading time
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.
