Using the COUNTIF function in Excel: Beginner to Advanced

The COUNTIF Formula is used to count the number of cells that match a specific condition. It's hands down a game changer of a formula because at it's very basic it can give you some basic stats on data

Continue reading

How to Make a Pie Chart in Excel 2010

I’m a big fan of Pie Charts because they are a great visual representation of ‘spread’ or ‘distribution’ of data. By this I mean you can understand how different parts contribute to the whole.

Continue reading

Combine Cells and Columns in Excel with Merging

Excel, unfortunately doesn’t have a button to push to Merge two columns and still maintain the data. However, there are three different ways to combine columns. The easiest is to use the Merge Cells

Continue reading

The Excel INDIRECT function

What does it do?In brief summary, the Excel INDIRECT function returns a reference specified by a text string.Syntax explained=INDIRECT(ref_text, element to FALSE (R1C1 style), you’ll see from adding

Continue reading

What I learned about Online Excel Courses After Training 1000 students

There are countless resources online for improving your Excel skills, it’s overwhelming to say the least. So how do you wade through it all and make some progress? If you are thinking of learning online

Continue reading

Dollar $ in Excel – Absolute and Relative References

Excel’s default is to use relative reference when using formulas. That means that when a formula is copied and pasted into another cell the formula will change its reference points by the exact number

Continue reading

How to Alphabetize in Excel 2010

Introduction Alphabetizing set of data means sorting a listing alphabetically in MS Excel! It can be carried out both ways, either in ascending get or in descending order. The application has still another

Continue reading

How to Use Conditional Formatting in Microsoft Excel 2016

IntroductionConditional Formatting is a powerful tool and can change how a cell appears, based on the cell’s value. It enables you to identify critical data at a glance. Colors, icons, data bars and

Continue reading

How To Separate First And Last Names In Excel

​You will often receive spreadsheets with  names. Sometimes these spreadsheets have the first name and the second name within different cells in different columns. However, spreadsheets usually

Continue reading

How To Subtract In Excel: Quick Guide

One of the most basic uses of an excel spread sheet is to subtract values in order to get a result.In this tutorial we will cover how to subtract in Excel and get progressively more advanced and in addition

Continue reading