Category - Intermediate Excel Tutorials

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …

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 …