Category - Beginner Excel Tutorials

Proper Case Formulas

Proper Case Formulas

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 …

Read More

Len Formula

Len Formula

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 …

Read More

Autocorrect in Excel

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 …

Read More

Left Formula in Excel

Left Formula in Excel

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 …

Read More

Change Numbers to Dollars

Change Numbers to Dollars

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 …

Read More

Exact Match Function

Exact Match Function

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 …

Read More

CTRL + Shift Function

CTRL + Shift Function

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

Read More

Put Dashes in SSN in Excel

Put Dashes in SSN in Excel

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 …

Read More

Get Biggest Number in Excel Range

Biggest Number in Excel

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 …

Read More

Find Smallest Number in Excel

Find Smallest Number in Excel

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

Read More
Page 1 of 2