Learn the Excel Right Formula with our easy guide. The Right Function allows you to extract letters from a piece of text in a cell starting from the last character. You can use…
Intermediate Excel Lessons
Excel Right Formula
Find the Sum in Excel
Use this guide to find the sum in Excel spreadsheets when dealing with multiple numbers. This guide will teach you the steps to create named ranges in Excel and using that information, find…
Calculate Days Left in Excel
Learn to calculate days in Excel spreadsheets, starting with establishing the date, then the day of the year, and finally using that information to create a countdown of the days left in the…
Split Text in Excel
Learn to split text in Excel to separate data into new columns. This guide is useful if you need to split information such as first names and last names into new columns. Imported…
Prevent Duplicate Entries in Excel
Learn how to prevent duplicate entries in Excel by using a simple tool within the Excel program. You can use this feature to have the program search through massive amounts of information and eliminate…
Excel If Statement
The Excel If Statement formula is very valuable when doing math within Excel. It is most often used when you have a large amount of numbers and need to decide the status and…