Microsoft Excel is the most popular spreadsheet program on the market and an essential tool to organize, manipulate and analyze all kinds of data.
The TEXTJOIN is a new function introduced in 2019 and available in Microsoft Excel 2019, Excel 2021 and Excel for M365. The TEXTJOIN function combines the text from multiple strings …
How To Join Texts Using TEXTJOIN & IF Functions | Microsoft Excel Read More »
The String functions are used in computer programming languages to manipulate a string. Microsoft Excel also have many string functions which you can use to manipulate strings. The most basic …
String Functions : UPPER, LOWER & PROPER | Microsoft Excel Read More »
Microsoft introduced a new capability that will revolutionize how you build formulas in Excel. The new feature called LAMBDA is currently available to M365 Beta customers. LAMBDA allow you to …
Microsoft introduced LAMBDA: Turn Excel formulas into custom functions Read More »
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 value in the …
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 on the activities …
Basic Excel Functions you should know to make your work life easier Read More »
