As I showed in my first Excel functions article, the serious meat in any spreadsheet is the formulas and functions that perform the calculations. Excel offers functions that you can use to make the ...

If the ERROR.TYPE function in Excel is not working on your Windows 11/10 PC, this post will help you fix the issue. The ERROR.TYPE() function is one of the most ...

If you would like to improve your Excel workflows and spreadsheets and in the process save a huge amount of time you might be interested in mastering Excel date functions. Once mastered this knowledge ...

Learn how Excel IMPORTCSV refreshes linked CSV data, handles locale formats, and switches to IMPORTTEXT for semicolon delimiters.

These four overlooked Excel features completely changed how I design spreadsheets.

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

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

This post explains how to use the new Excel TEXTSPLIT function. TEXTSPLIT() is a Text function in Excel. The purpose of this function is to split a given text string on the basis of one or more ...

Microsoft Excel 2010 is a powerful spreadsheet program that business owners can utilize to track everything from employee's schedules to inventory levels. If you find yourself in a situation where you ...

Microsoft Office's Excel application allows users to store, model and manipulate data sets. Excel spreadsheets organize this data into worksheets, each with a number of rows and columns. Each row or ...