Learn about the five basic data types in Excel - Number, Date and Time, Text, Logical, and Error. Understand how to use and manipulate each data type effectively for creating useful worksheets.| Spreadsheet Planet
Learn how to count non-blank cells in Excel using various formulas such as COUNTA, COUNT, SUBTOTAL, COUNTIF, SUMPRODUCT, and more.| Spreadsheet Planet
Learn everything about the Formula Bar in Excel - where to find it, how to show/hide, shortcuts, and how it makes working with large formulas easier!| Spreadsheet Planet
Learn how to effectively get the cell address of a specific value in Excel using built-in functions like ADDRESS and CELL. (absolute or relative address)| Spreadsheet Planet
Learn how to use the COUNTIF function in Excel for partial matching, including wildcard characters, with helpful examples and explanations.| Spreadsheet Planet
Learn 5 methods to count unique values in Excel using formulas. Find out how to exclude empty cells and improve performance for large datasets.| Spreadsheet Planet
Learn how to remove apostrophes in Excel with three fool-proof methods (using Text to columns, a multiplication trick, and simple VBA code)| Spreadsheet Planet
Learn how to count the number of 'Yes' in Excel using the COUNTIF function, whether it appears as text or in a checked checkbox.| Spreadsheet Planet
Learn how to count negative numbers in Excel using COUNTIF formulas and a simple VBA macro code.| Spreadsheet Planet
Learn how to extract text after the space character in Excel using formulas, VBA code, and Text to Columns (step-by-step instructions).| Spreadsheet Planet
Learn how to count cells less than a specific value in Excel using COUNTIF, SUM, and IF functions, as well as the SUMPRODUCT function.| Spreadsheet Planet
Learn how to easily count cells with values greater than 0 in Excel using a simple COUNTIF formula.| Spreadsheet Planet
Learn how to reverse a text string in Excel using formulas and VBA scripts. This tutorial provides step-by-step instructions for both methods.| Spreadsheet Planet
Learn 3 methods to remove text after a specific character in Excel, including Find and Replace, Formulas, and VBA. Also, remove text after the nth instance of a character.| Spreadsheet Planet
Learn how to easily count how many times a word appears in Excel using simple formulas and VBA.| Spreadsheet Planet
Learn 4 easy ways to add text to the beginning or end of all cells in Excel using ampersand, CONCATENATE, Flash Fill, and VBA.| Spreadsheet Planet