Using the AUTOFILTER function in Excel will help you create a table for your data sets. This is a great way to organize larger sets of information in an Excel spreadsheet. The main…
Beginner Excel Lessons
Len Function Excel
Learn how to use the Len function Excel offers. The Len function is a simple formula that will tell you how many characters are in a cell or range of cells. It can…
Excel Autocorrect Guide
The Excel Autocorrect guide will show you how to customize your Excel spreadsheets to recognize what you type and correct anything you want. This is great for people who work in Excel consistently…
Excel Left Function
Learn the Excel left function formula to create a new cell with data from another cell. The left function will take a certain amount of characters from the left-most side of a cell…
Excel Dollar Function
Learn to use the Excel dollar function to convert numbers into readable currency. This formula is short and simple and can be easily applied to any numbers entered into your Excel spreadsheet. Download…
Using Exact Function
The Exact Function in Excel spreadsheets allows you to enter a formula that will ask Excel if two cells are identical, and Excel will return a true or false answer. This is a…