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. Rather than throw more fancy words at you, here’s a few visuals to explain further:You want to depict the Mobile Phone […]

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,[a1])Above you’ll see the syntax in Excel language, the part in brackets is where the magic happens so let’s break these both down and explain what each element does, but before we do, let’s explain what the […]

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 function prematurely and easily sort data. This includes both alphabetizing provides of strings (i.e. getting them in alphabetical order), and ordering exact […]

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 contain the Full name in a single column. So what do you do then? Simply follow the options mentioned below to separate the user name as first name […]

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 learn some interesting and lesser used methods to subtractNote: This will help you Subtract in all […]

Continue reading