Introduction to Pivot Tables

  • 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, ...
  • 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 ...
  • Introduction to Pivot Tables – Part 3 - In this final blog post, we'll look at the Pivot Design tab, the Pivot Table Analyze tab, sorting data, and formatting Pivot Tables and have a quick look at formatting Slicers. By the end, you'll be able to make your Pivot Tables look more professional.

Data Validation

  • How to Control User Input Using Data Validation Part 1 - In this first blog post, in a two-part series of blog posts on Data Validation, we are going to look at how to control data input by a user using the Data Validation list feature. Data Validation limits the type of data that someone can enter into a cell. We'll also look at how to ...
  • How to Control User Input Using Data Validation Part 2 - In this second part of a two-part series of blog posts on Excel Data Validation, we are going to look at how to control data input by users using the whole numbers, decimal, date, time, and text length Data Validation options. We'll also look at how you can set minimum and maximum limits on the ...