Overview A concise review of newer Excel functions from Microsoft, demonstrating how to use them and when they’re useful.

A Friday evening call from accounting saying, "The unit prices are wrong." It was past 5:00 PM on a Friday in October 2025. I received a call from the accounting department of a business partner. They ...

In this video, learn how to transform a simple list of events in Excel into a dynamic monthly calendar. Topics covered include: - Setting up dates with the SEQUENCE and WEEKDAY functions - Creating a ...

Excel remains one of the most important tools in data analysis. Yet most analysts use only a small fraction of its capabilities. Mastering the right functions can speed up reporting, improve accuracy, ...

It works. However, there is almost no reason to write it this way in Excel 2019 or later. CONCATENATE is an outdated function. There are now shorter and more flexible ways to write it. Because cells ...

If you often work with data that starts life as a text file or CSV, Microsoft Excel now has new built-in tools that simplify how that information gets pulled into a spreadsheet. The update introduces ...

Along with simple shortenings such as n. or num., one of the more curious methods is the number sign or hash symbol, #. And as that symbol gradually simplified and merged together over time, our ...

Have you ever spent countless hours wrestling with Excel formulas, trying to convert “one thousand two hundred” into “1,200” or vice versa? For years, this task has frustrated professionals across ...

Numbers is one of the most powerful spreadsheet tools available due to its intuitive design, excellent functionality, and iCloud syncing. It includes over 290 predefined functions that help you create ...

Apple's Numbers spreadsheet for Mac, iPhone, and iPad, is not as powerful as Microsoft Excel, but most users will be hard-pressed to find its limitations — and will immediately see how much easier ...