## 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

## 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.

## 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

## 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

## 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

## 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

## 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

## 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