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...
top of page
Create account
+91 96113 44773
Search
Vijay Perepa
May 251 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
4 views0 comments
Vijay Perepa
May 222 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...
8 views0 comments
Vijay Perepa
May 191 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...
4 views0 comments
Vijay Perepa
May 101 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...
8 views0 comments
Vijay Perepa
May 31 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....
10 views0 comments
Vijay Perepa
Jan 311 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...
14 views0 comments
Vijay Perepa
Jan 301 min read
Custom Formulae using LAMBDACURRENT YEAR and SAMEPERIODLASTYEAR in EXCEL#lambda #customized #excel #timeseriesanalysis
https://www.youtube.com/shorts/oPR9GGS1bko
15 views0 comments
Vijay Perepa
Dec 28, 20231 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...
31 views0 comments
Vijay Perepa
May 20, 20231 min read
𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐌𝐚𝐠𝐢𝐜 𝐨𝐟 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬
𝐔𝐧𝐥𝐨𝐜𝐤 𝐭𝐡𝐞 𝐌𝐚𝐠𝐢𝐜 𝐨𝐟 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐚𝐧𝐝 𝐏𝐨𝐰𝐞𝐫 𝐀𝐩𝐩𝐬: 𝐋𝐞𝐚𝐫𝐧 𝐇𝐨𝐰 𝐭𝐨 𝐄𝐚𝐬𝐢𝐥𝐲 𝐅𝐢𝐥𝐭𝐞𝐫 𝐚...
10 views0 comments
Vijay Perepa
May 4, 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...
11 views0 comments
Vijay Perepa
May 1, 20231 min read
𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 |
𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 || 𝐒𝐭𝐨𝐫𝐲 𝐓𝐞𝐥𝐥𝐢𝐧𝐠 𝐰𝐢𝐭𝐡...
9 views0 comments
Vijay Perepa
Apr 16, 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...
39 views0 comments
Vijay Perepa
Mar 19, 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 !
7 views0 comments
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...
16 views0 comments
Vijay Perepa
Mar 19, 20230 min read
2 views0 comments
Vijay Perepa
Nov 11, 20221 min read
𝐇𝐨𝐰 𝐭𝐨 𝐂𝐫𝐞𝐚𝐭𝐞 𝐋𝐨𝐥𝐥𝐢𝐩𝐨𝐩 𝐂𝐡𝐚𝐫𝐭 𝐢𝐧 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈
Creating Lollipop Chart in Power is just few click away!! Charticulator visual provides easy to use Templates to create such custom...
14 views0 comments
Vijay Perepa
Nov 10, 20221 min read
Charticulator Templates
Charticulator a best Visual available from the market place - Power BI You can create many tailor-made visuals and if you wish you can...
170 views0 comments
bottom of page