In this video tutorial I demonstrate how to add text to the beginning and/or end of a cell or multiple cells. I demonstrate three methods: Click here to download the featured file. Method 1: Custom Number Formatting Click here to see this part of the video. To add text to the beginning or end… Read More »How to Add Text to the Beginning and End of a Cell in Excel – 3 Methods
In this video tutorial I explain how to get data to sort automatically when that data is changed or added to. Download the featured file here. Method 1: Using a Formula to Auto Sort Data Click here to view this part of the video. Only use this formula if you don’t use Excel 365. … Read More »Excel: Automatically Sort When Data Changes or Added | Auto Sort Excel Formula | Auto Sort Macro
In this video tutorial I demonstrate how to apply a formula to multiple cells in Microsoft Excel. The are number of ways we can achieve this. Download the featured file here Method 1: Copy the Formula Using the Fill Handle Click here to view this part of the video You can copy a formula… Read More »Apply Formula to Multiple Cells in Excel | Use the Same Formula in Entire Column, Row or Table