Category - Intermediate Excel Tutorials

Change Inches to Feet in an Excel Template

Change Inches to Feet in an Excel Template

Learn how to change inches to feet in an Excel Template. Converting the number of inches in Excel to feet is an easy automated process …

Read More

Color Rows in Excel

Color Rows in Excel

Learn to quickly and easily color rows in Excel. If you are working with an Excel sheet with many rows of data that span across …

Read More

Excel Right Function

Excel Right Function

Learn how to use the Excel Right Function in your spreadsheets to get a portion of a piece of text starting from the last letter. …

Read More

Get Sum in Excel

Get Sum in Excel

Learn how to get sum in Excel spreadsheets from a group of numbers using simple formulas. When working with named ranges in Excel, you’ll be …

Read More

Calculate Days Left in the Year in Excel

Calculate Days Left in the Year in Excel

Learn how to calculate days left in the year in Excel spreadsheets to create your own countdown. Excel has stackable formulas you can use to …

Read More

Count Cells with Text in Excel

Count Cells with Text in Excel

Follow our guide and learn how to count cells with text in Excel spreadsheets. Excel has a formula that you can enter that will search …

Read More

Remove First Characters From Excel

Remove First Characters From Excel

Learn to remove first characters from Excel worksheets with a simple formula that can be easily adjusted to fit your needs. This formula can be …

Read More

Splitting Text in Cells

Splitting Text in Cells

Splitting text in cells in Excel spreadsheets is a good skill to learn, especially if you are importing data. Often, imported data ends up all …

Read More

How to Prevent Duplicates in Excel

How to Prevent Duplicates in Excel

Easily learn how to prevent duplicates in Excel simply by facilitating an existing tool already in Excel. By using this feature, you will quickly be alerted to …

Read More

Adding a Row or Column

Adding a Row or Column

Learn how to add a row or column to any Excel spreadsheet with this easy step-by-step process. Adding a row or column to an Excel …

Read More
Page 1 of 2