Learn to convert inches to feet in Excel, making manual math equation processes useless. If you have a list of inches in an Excel spreadsheet, you can use a simple formula to convert them…
Intermediate Excel Lessons
Highlight Rows in Excel
Learn how to highlight rows in Excel with this function. If you are viewing, editing, or sorting through rows of data, it can be difficult to follow down the row and not accidentally…
Change Case of Text in Excel
Follow our guide on how to change case of text in Excel. Learn to correct capitalization in names, clean the format of an email address, and make data all capitalized. This is a…
Excel Right Trim
Learn to use the Excel Right Trim function with this guide. Get the last letters of a name or word with this easy formula. This function allows an Excel user to extract an…
Named Ranges in Excel
Learn to create named ranges in Excel spreadsheet to generate the sum of a range of numbers. This is useful when you are working with multiple numbers that you want to total up,…
Calculate Day of the Year in Excel
One of the best features of Excel is that it can easily become a calendar that will let you track days, create count downs, and much more. Learn to calculate days left in…