top of page
Create account
+91 96113 44773
Search
ππ¨π°ππ« π¨π ππ²ππ‘π¨π§ π’π§ ππ¨π°ππ« ππ! π
ππ ππ’π΅π€π© π΅π©π¦ π§πΆππ π΅πΆπ΅π°π³πͺπ’π π©π¦π³π¦: https://lnkd.in/ggJYPin5 ππ I am sharing here my video link where I have...
Vijay Perepa
Jan 2, 20251 min read
Β
Β
Β
The Most Powerful VBA Tricks: UDF Secrets
User-Defined Functions (UDFs) in VBA (Visual Basic for Applications) are custom functions that you can create to perform calculations or...
Vijay Perepa
Jun 1, 20241 min read
Β
Β
Β
Click for a Chart in Excel using VBA.
Do you wish to have a tutorial for this? Please comment below. #vba #excelvba #excelcharts #exceltipsandtricks
Vijay Perepa
May 25, 20241 min read
Β
Β
Β
Microsoft Fabric: From CSV to Delta Table with Spark and SQL Magic!
What is Covered: Introduction to Microsoft Fabric: Learn what Microsoft Fabric is and how it can revolutionize your data management and...
Vijay Perepa
May 22, 20242 min read
Β
Β
Β
Understanding Advanced Formulae in Excel:
#excelworld #exceltricks #excel #microsoft Understanding Advanced Formulae in Excel: Learn how to utilize the TAKE() function To extract...
Vijay Perepa
May 19, 20241 min read
Β
Β
Β
How to Create Fiscal Calendar using LAMBDA Function in Excel
In this tutorial, we have explained how to create fiscal calendar with the powerful LAMBDA function in Excel. A fiscal calendar, unlike a...
Vijay Perepa
May 10, 20241 min read
Β
Β
Β
Understanding Calculation Groups (CG) in Power BI
Understanding Calculation Groups (CG) in Power BI is a valuable skill that can help you reduce the number of measures you need to create....
Vijay Perepa
May 3, 20241 min read
Β
Β
Β
CURRENTMONTH( ) FUNCTION in EXCEL?
The CurrentMonth function in Excel!? This custom function using LAMBDA will a quick help to get summary. Stay tuned for a full tutorial...
Vijay Perepa
Jan 31, 20241 min read
Β
Β
Β
Custom Formulae using LAMBDACURRENT YEAR and SAMEPERIODLASTYEAR in EXCEL#lambda #customized #excel #timeseriesanalysis
https://www.youtube.com/shorts/oPR9GGS1bko
Vijay Perepa
Jan 30, 20241 min read
Β
Β
Β
ππ Transforming Insights: Elevate User Experience with Dynamic SVG Animations in Power BI πΌπΌ
Animated SVGs (Scalable Vector Graphics) offer a dynamic and interactive dimension to your Power BI reports, enhancing user engagement...
Vijay Perepa
Dec 28, 20231 min read
Β
Β
Β
ππ§π₯π¨ππ€ ππ‘π πππ π’π π¨π ππ¨π°ππ« ππ ππ§π ππ¨π°ππ« ππ©π©π¬
ππ§π₯π¨ππ€ ππ‘π πππ π’π π¨π ππ¨π°ππ« ππ ππ§π ππ¨π°ππ« ππ©π©π¬: ππππ«π§ ππ¨π° ππ¨ πππ¬π’π₯π² π
π’π₯πππ« π...
Vijay Perepa
May 20, 20231 min read
Β
Β
Β
Unlocking the Power of VBA Visuals: See How to Create a Quick Bookmark Chart in less than 5 Minutes
When you have a summary Visual which shows Revenue by Country, for which you may want to show the sub plots / visuals by City for...
Vijay Perepa
May 4, 20231 min read
Β
Β
Β
π―ππ ππ πππ π π«ππππ π«πππ π¬πππππππππ ππ π¬ππππ πͺπππππ |
π―ππ ππ πππ π π«ππππ π«πππ π¬πππππππππ ππ π¬ππππ πͺπππππ || πππ¨π«π² πππ₯π₯π’π§π π°π’ππ‘...
Vijay Perepa
May 1, 20231 min read
Β
Β
Β
How to Create a Lollipop Chart in Power BI less than 10 minutes
#powerbi#python#lollipop In this video, I'll show you how to create a lollipop chart in Power BI in less than 10 minutes. Power BI is a...
Vijay Perepa
Apr 16, 20231 min read
Β
Β
Β
Configuring Slicer Settings in Power BI - New Formatting Experience
There are quite few changes in the Latest Power BI update Mar 2023. This is quick tip to the beginners !
Vijay Perepa
Mar 19, 20231 min read
Β
Β
Β
Uncovering the Secrets of Power BI: Learn How to Create a Dynamic CAGR!
CAGR (Compound Annual Growth Rate) commonly used to Calculate and compare the past performance of investments or to project their...
Vijay Perepa
Mar 19, 20231 min read
Β
Β
Β
Vijay Perepa
Mar 19, 20230 min read
Β
Β
Β
Vijay Perepa
Mar 12, 20230 min read
Β
Β
Β
Power BI Training - for PL 300
Register
Vijay Perepa
Dec 10, 20221 min read
Β
Β
Β
ππ¨π° ππ¨ ππ«ππππ ππ¨π₯π₯π’π©π¨π© ππ‘ππ«π π’π§ ππ¨π°ππ« ππ
Creating Lollipop Chart in Power is just few click away!! Charticulator visual provides easy to use Templates to create such custom...
Vijay Perepa
Nov 11, 20221 min read
Β
Β
Β
bottom of page