How To Join Texts Using TEXTJOIN & IF Functions | Microsoft Excel
The TEXTJOIN is a new function introduced in 2019 and available in Microsoft Excel 2019, Excel 2021 and Excel for M365. The TEXTJOIN...
Powershell - Merge CSV files & Insert file name as a column
Scenario: The details of application installed on different machines need to be collected through PowerShell script in CSV file, named as...
String Functions : UPPER, LOWER & PROPER | Microsoft Excel
This video cover String functions UPPER, LOWER and PROPER. Please watch Youtube video to understand how these functions works.
Microsoft introduced LAMBDA: Turn Excel formulas into custom functions
Microsoft introduced a new capability that will revolutionize how you build formulas in Excel. The new feature called LAMBDA is...
Microsoft Excel: VLOOKUP Explained
VLOOKUP is a function in Excel that perform a vertical lookup by searching for a value in the first column of a table and returning for a
Basic Excel Functions you should know to make your work life easier
As an IT Professional you may have to deal with lots of data every day. I have seen many experienced IT admins spending quite lots of time