Learn how to convert serial numbers to date in Excel using TEXT function, number formatting, and VBA macro codes.| Spreadsheet Planet
Learn how to add a specific number of days to a date in Excel using simple formulas and the DATE() function. Easily calculate future dates for delivery, payroll, and more.| Spreadsheet Planet
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 add leading zeros in Excel using various methods such as apostrophe, custom number formatting, and functions. Find out how to retain leading zeros and apply these methods to multiple cells.| Spreadsheet Planet
Learn three easy ways to get unique values from a column in Excel: Remove Duplicates tool, Advanced Filter, and UNIQUE function.| Spreadsheet Planet
Learn how to find the last Monday of the month in Excel using a single formula, involving the EOMONTH and WEEKDAY functions.| Spreadsheet Planet
Learn how to sum only positive numbers in Excel using the SUMIF function or VBA. This tutorial provides step-by-step instructions for both methods.| Spreadsheet Planet
Learn how to format phone numbers in Excel for better readability and auto-formatting. Create custom number formats for international and local codes.| Spreadsheet Planet
Learn how to extract numbers from mixed text in Excel. Whether the number is at the beginning, end, or middle of the text, these formulas and functions will help you clean your data.| Spreadsheet Planet
Learn how to split one column into multiple columns in Excel using the 'Text to Columns' feature (step-by-step instructions)| Spreadsheet Planet
Learn how to flip data in Excel - columns, rows, and tables using different methods such as helper columns, formulas, and VBA.| Spreadsheet Planet