#Excel

Jun 11 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...

2 views0 comments

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

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

May 1, 20231 min read

𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 |

𝑯𝒐𝒘 𝒕𝒐 𝒈𝒆𝒕 𝒂 𝑫𝒓𝒊𝒍𝒍 𝑫𝒐𝒘𝒏 𝑬𝒙𝒑𝒆𝒓𝒊𝒆𝒏𝒄𝒆 𝒊𝒏 𝑬𝒙𝒄𝒆𝒍 𝑪𝒉𝒂𝒓𝒕𝒔 || 𝐒𝐭𝐨𝐫𝐲 𝐓𝐞𝐥𝐥𝐢𝐧𝐠 𝐰𝐢𝐭𝐡...

9 views0 comments

Jun 24, 20211 min read

𝐄𝐱𝐜𝐞𝐥 𝐕𝐁𝐀 𝐂𝐨𝐥𝐮𝐦𝐧 𝐀𝐮𝐭𝐨 𝐖𝐢𝐝𝐭𝐡 𝐉𝐮𝐬𝐭 𝐛𝐲 𝐬𝐞𝐥𝐞𝐜𝐭𝐢𝐧𝐠 𝐂𝐞𝐥𝐥

Few Excel habits are Die Hard and Some times they are going to hamper your productivity. While entering Data in Excel , Majorly when you...

92 views0 comments

Oct 10, 20201 min read

Pivot Tables with VBA - New Video Series

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

36 views0 comments

Aug 14, 20201 min read

Hide or Un-hide sheets based on selection using VBA in Excel: A Most common question Asked in in VBA

This is a most common question asked across the Groups. How to Hide or Un-hide Sheets based on Selection. There are two ways One, by...

37 views0 comments