top of page
Create account
+91 96113 44773
Search
Excel Formulas - CHOOSE - To create interactive Chart
To Create any Advanced chart you need to know few basic Excel Formulas and with clear understanding about the outcome, which can result a...
Vijay Perepa
Jan 31, 20211 min read
Interactive Excel Chart in 5 Minutes
Creating Reports with Excel Charts is quite Easy and Effective. Whenever we create a Chart in Excel we need to keep in view of the end...
Vijay Perepa
Jan 26, 20211 min read
Simple IF Function, Data Validation, Conditional Formatting to get a Quick Dynamic Report (Chart)
Some times, you can use simple basics of Excel to show best results and within no time. In this video I have explained how to use...
Vijay Perepa
Jan 24, 20211 min read
How to Create Butterfly Chart (Also called as Tornado, Pyramid Chart)
Telling a Data Story with Visualization in Excel much is quite interesting. Watch this video to understand how to achieve that in just 15...
Vijay Perepa
Jan 23, 20211 min read
Vijay Perepa
Jan 22, 20210 min read
Customized Tool-tip in Power BI || Create Custom Tool-tip with Dynamic Image on Mouse Hover
IF you have below Questions - What is Tooltip in Power BI - How to change background color of tooltip in Power BI - How to show chart on...
Vijay Perepa
Jan 9, 20211 min read
Reporting TIPS in PowerBI : More With Book Marks in PowerBI
Creating Simple Reports with Power BI and make your Teams feel WoW!!
Vijay Perepa
Jan 7, 20211 min read
Import Power Pivot model to Power BI
If you have already created a Data Model in PowerPivot and if you wish to migrate to Power Bi , it is just easy! Watch this Video to know...
Vijay Perepa
Jan 7, 20211 min read
Learn VBA in PowerPoint New Series Part 1
You might be knowing how to use Excel Macros easily because in Excel Macros you can record a Macro easily. But in case of PowerPoint you...
Vijay Perepa
Jan 6, 20211 min read
Power BI - Filters on this Page - Avoid Filtering specific visual when page level filter is on!
In Power BI, To Filter the Data Externally you can find Filters Pane where you have 3 different options as shown in the below picture:...
Vijay Perepa
Jan 6, 20211 min read
Creating real 3D Text in After Effects in Seconds
Welcome to my new Channel - PerepaEdu - VFX I am going to teach you VFX , 3D modelling and many more. How to create real 3D Text in After...
Vijay Perepa
Jan 3, 20211 min read
Power Query Editor Tips & Tricks
While performing ETL understanding the data behavior is important. Also need to know which feature helps us to do better transformation...
Vijay Perepa
Dec 31, 20201 min read
Hide or Un-hide sheets based on selection using VBA in Excel
This is a most common question asked across the Groups. How to Hide or Unhide Sheets based on Selection. There are two ways 1 .by...
Vijay Perepa
Dec 20, 20201 min read
Vijay Perepa
Dec 15, 20200 min read
𝐒𝐜𝐚𝐭𝐭𝐞𝐫 𝐏𝐥𝐨𝐭 𝐚𝐧𝐝 𝐁𝐚𝐫 𝐏𝐥𝐨𝐭 𝐏𝐲𝐭𝐡𝐨𝐧 𝐕𝐢𝐬𝐮𝐚𝐥𝐬 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐏
In this video you will learn : - Adding Scatter Plot , Bar Plot - Adding Data Labels using For Loop and Zip Function - Few important...
Vijay Perepa
Dec 14, 20201 min read
Free Excel Add-in for easy work in Excel
Download Free and Enjoy!
Vijay Perepa
Dec 12, 20201 min read
Vijay Perepa
Dec 12, 20200 min read
Get Data , ETL and Report Creation using Python in Power BI
This video will help you understand the value brought by Python integration with Power BI Desktop and how it provides a powerful tool for...
Vijay Perepa
Dec 10, 20201 min read
Using 3D Animated Characters in PowerPoint and Creating Movie Effect
Easy Method of Creating Animation Scene in PowerPoint using 3D Paint, Mixamo This is a short tutorial on How To Make An Animation Scene...
Vijay Perepa
Dec 9, 20201 min read
DATA VISUALIZATION IN POWER BI USING PYTHON
Python is a Great Tool for Data Science and Power BI is a Great Reporting Tool and even more. If you can combine both then the outcome...
Vijay Perepa
Dec 7, 20201 min read
bottom of page