Start Applying M Query and Understanding the Logic In this video few common functions are explained Keep watching! 😎

Power Query is the Data Transformation engine which can be used in many applications, and Power Query Editor is the Graphical User...

In this Video , I have Explained how to create a very quick video using the Power Query Model in Excel. How to create a Custom Column in...

As promised, I have started the Series - Learn Power Query and Power Query Editor. What is the difference between these two?! Power Query...

Power Query is a data transformation and data preparation engine. Power Query comes with a rich GUI for getting data from different...

I have create a Playlist with 6 Videos showing how to create a comprehensive report using Simple DAX Functions. Also Explained how to...

Managing and Staging Measures in a Proper Folders is one of the best Practices in Report building in Power BI. Please watch to know how...

In Excel, you can quickly sort your data by using the A-Z and Z-A Sort buttons on the Ribbon's Data tab. Also you can Sort Data in a...

During one of Training Programs few participants are from Finance (predominantly, who deal with Receivables and Payables) , asked about...

During one of my regular workshops , one participant asked whether he can add any animated pictures viz., gifs etc. instead of regular...

While Analyzing Data using Excel, Sometimes we require some Extra customized Charts to help us to tell the story of the data,much more...

How to import and Get connected Google Sheets to Excel. A simple Trick helps us to import Google Sheet Data to Excel . Also How to use...

How to use Drill Down With Hierarchy in Power BI , also use Book Marks to make the Visual Impact much Better !To know how to manipulate...

Some times we requires some Special or Customized Functions in Excel but we may not get them. For Example if you want get Total Values,...

Creating Reports with Excel Charts is quite Easy and Effective. Whenever we create a Chart in Excel we need to keep in view the end...

Register Now https://valq.com/webinars/scenario-planning-foreseeing-how-your-big-picture-could-change-so-you-can-get-the-details-right/

Some time you wish you have different colors for each month and Years in a Chart where the Axis is shared by both Year and Month (Chart...

While working on Excel Files, many times due to various reasons you may find many sheets piled up containing sheets which are really not...

DAX Functions give us a great Scope to get the insights from the Large Datasets. A simple functionality will allow us to get multiple...