Category - Intermediate Excel Tutorials

How to do an IF Statement in Excel

How to do an IF Statement in Excel

Learn how to do an IF Statement in Excel with our easy guide. An IF statement is when you enter a formula into Excel that …

Read More

Combining Names in Excel

Combining Names in Excel

Follow this tutorial to learn about combining names in Excel, such as first and last names. The formula for putting two cells (that may contain …

Read More

Tutorial: Prepend Text in Excel

Tutorial: Prepend Text in Excel

Follow our Tutorial: Prepend Text in Excel to learn how to easily add text to existing information in new columns and rows. Learn the simple …

Read More

Formula for Appending Text in Excel

Formula for Appending Text in Excel

Learn the formula for appending text in Excel with our guide. The act of appending text within an Excel spreadsheet means you are taking existing …

Read More

Applying Conditional Formatting Tutorial

Applying Conditional Formatting Tutorial

Applying conditional formatting to an Excel spreadsheet is great feature to know. The example in the tutorial shows how the Excel program can track birthdays …

Read More

Excel Text Function Tutorial

Excel Text Function Tutorial

Excel’s text functions can be used for charts, presentations, and general data organization. Follow the Excel Text Function Tutorial to learn how to utilize this …

Read More

Chart Creation in Excel

Chart Creation in Excel

Multiple types of charts can be easily created using Excel. Chart creation in Excel includes bar graphs, pie graphs, and many more. Using the tutorial …

Read More

How to Sort and Filter in Excel

How to Sort and Filter in Excel

With Excel, you can sort and filter through any amount of data. These functions can help to find data patterns, display specific information, or create …

Read More

How to Create Pivot Tables in Excel

How to Create Pivot Tables in Excel

Creating a pivot table in Excel allows the user to quickly and easily summarize and arrange large amounts of data, and then pull certain details …

Read More

Calculating Averages in Excel Tutorial

Along with basic math formulas, Excel also has the ability to calculate averages. Since solving averages by hand is boring and tedious, let a computer …

Read More
Page 2 of 2