Category - Beginner Excel Tutorials

Learn proper case formulas including the lower case formula and the upper case function. Fix imported or poorly organized data in Excel to make it …

Learn how to use the Excel Len formula in your spreadsheet. The Len function will retrieve how many characters are in a cell or range …

Learn how to autocorrect in Excel. You can set up how you want Excel to read what you type and adjust it according to your …

Learn the left formula in Excel. The left function for Excel takes characters from another cell starting with the left side character. This function can …

Learn how to change numbers to dollars in Excel using a simple formula. When you import number data, or quickly type in number entries, you …

Learn to use the exact match function in Excel spreadsheets to find if two entries are exactly the same or not. This formula is easy …

Learn how to use the CTRL + shift function in Excel worksheets to select portions of data quickly and easily. This Excel shortcut will save …

Learn to put dashes in SSN in Excel spreadsheets with a simple formula. Follow our guide to learn how to input dashes in the right …

Learn how to find the biggest number in Excel worksheets. Excel has a formula that allows a user to select a group of cells and …

This formula is used to find smallest number in Excel spreadsheets. Learn how to find the smallest number in a range within an Excel worksheet. …