Some you may get bit complex Data in Excel. The Data with Merged Cells, Blanks, Multiple Column Headers, Some Time Data Title as Column...

While Presenting Any Report you must keep the Audience in view because they are your customers and you need to incorporate their...

New #VBA #Series is Coming up! Please be the #member of www.perepaedu.com and Subscribe to www.youtube.com/perepavijay Keep watching for...

Some times, even after applying Page / Report Level Filters, we may require few visuals should not interact with that Filter and they...

M Query is a Functional Language. While Transforming Data in Power Query knowledge of Table Functions and other Functions is an added...

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,...