How to Write Relative and Absolute Cell References

In this blog post, I’m going to explain what relative and absolute cell references are, some of the advantages and disadvantages of each type of reference, the situations when each can be used, and, of course, some examples.

Continue Reading →

Introduction to Pivot Tables – Part 2

In this second blog post, of a three-part series, introducing Excel Pivot Tables, we’ll take a look at what you can do when you have multiple fields in one area of the Pivot Table Builder menu, filtering and some of the different ways you can calculate and summarize your data. These techniques will enable you to manipulate your data and extract information quickly.

Continue Reading →

How to Use the Excel Name Feature

The power of the Excel Name function is a personal favourite method of mine for saving time and improving quality when working in Excel.

In this blog post, I’m going to explain what the Excel Name functions is, why it is useful, and give you a few examples of how they can be used.

Continue Reading →

Conditional Formatting Icon Sets

Hi and welcome to this blog post on Excel Conditional Formatting Icon Sets. In this blog post, I’ll describe what Icon Sets are, describe how you can edit the Conditional Formatting rules associated with Icon Sets, then finish up with a couple of examples.

Continue Reading →

Introduction to Pivot Tables – Part 1

Welcome to the first blog post in a series of three blog posts introducing Excel Pivot Tables. Pivot Tables are one of Excel’s most powerful features but they are perhaps also one of its most confusing to understand at first.

In this series of blog posts, I’ll aim to get you started with Pivot Tables, explain some of the basic functionality, and the importance of preparing your data. For this first blog post, we’ll start by explaining what a Pivot Table is, how to access the functionality, and get you started with a simple example.

Continue Reading →

Page 5 of 7