The Tech Edvocate

Excel VLOOKUP function explained

Spread the loveYou’ve probably heard of Excel. It’s the ubiquitous spreadsheet program that powers everything from household ...
Excel Dictionary on MSN

XLOOKUP basics for smarter Excel searches

Once you learn XLOOKUP you will use it every single day! In this video, I'll break down everything you need to know about ...
Excel Dictionary on MSN

Excel function combo beyond VLOOKUP

Ask any Excel pro what their go-to lookup formula is and they'll all tell you the same thing - INDEX MATCH. It's more powerful than XLOOKUP, more flexible than VLOOKUP, and once it clicks you'll never ...

10 Powerful Excel Tips and Tricks for Complex Spreadsheets

Improve data management workflows with ten genius Excel techniques. Quickly format large numbers in millions without altering ...

Unlocking Bing Search Hidden Features you didn’t know existed

Unlock Bing Search's hidden features, including search operators, Visual Search, Copilot Search, flight tracking, currency ...
note

Output a copy-pasteable formula to remove the character 'yen' from the string in cell B2 so it can be treated as a number (using SUBSTITUTE and VALUE functions)

You want to perform addition or calculate averages on amounts that are currently strings The SUBSTITUTE and VALUE functions are useful for these situations. The SUBSTITUTE function replaces the 'yen' ...
note

Output a copy-pasteable formula to extract and display only the 'day' from a date entered in cell B2 (DAY function)

I want to display only the 'day' from an invoice date I want to check a list of which day of the month an application date falls on I want to separate the year, month, and day from a date into ...