The Excel Expert
  • Welcome to the Excel Expert
  • Blog
  • Books for sale
    • Your Excel Survival Kit
      • Get the e-book plus bonuses here!
      • Buy on Amazon.co.uk
      • Buy on Amazon.com
      • Create Great Reports in Excel
      • Create Great Reports in Word
    • Get and Transform your data
  • Products for Sale
  • Free Webinars
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

Aging debtors analysis | Using Today() and vlookups or how to know who you need to send to the Sopranos

by admin | Jun 2, 2014 | Excel Pivot tables | Introduction, Excel | Case Studies, Excel | Useful tricks

I was recently teaching a class on Powerpivot and the subject came up of how to use Excel to construct an aging analysis. The person had already created some serious serious formulas to do what he needed to do so no point in re-inventing the wheel. His big interest...

INTRODUCTION TO PIVOT TABLES | 08 – USING THE SLICER (EXCEL 2010 ONLY)

by admin | Feb 12, 2013 | Excel Pivot tables | Introduction, Excel | General

So this is the final installment in the series of pivot tables. You can check out parts one, two, three, four, five ,six and seven here. A new feature of Excel 2010 is the Slicer – which looks rather like a grater but which allows you to easily “slice and...

INTRODUCTION TO PIVOT TABLES | 02 – PREPARE USING A TABLE

by admin | Jan 16, 2013 | Excel Pivot tables | Introduction

This is part two of my introduction to pivot tables. You can have a look at part one here. A new feature in Excel 2007 is called the table. While it is not essential to convert your list to a table, doing so means that you can then work more efficiently with your data...

INTRODUCTION TO PIVOT TABLES | 01 – WHAT IS A PIVOT TABLE?

by admin | Jan 8, 2013 | Excel Pivot tables | Introduction, Excel | General

This is the first in a series of blog posts about pivot tables in Excel. A pivot table is a tool in Excel which allows you to move around your data so you can see it under different headings e.g it can take a list of sales and allow you to show you sales by country,...

EXCEL PIVOT TABLE | EXCEL PIVOT TABLE TUTORIAL – CREATE YOUR FIRST PIVOT TABLE

by admin | May 14, 2012 | Excel Pivot tables | Introduction

How to create pivot tables If you are working with any sort of lists in Excel and you want to be able to extract meaningful data out of it, a key skill you should have in your toolbox is how to create a pivot table. Essentially a pivot table allows you to move around...

Excel shortcut keys – FREE

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Categories

  • Excel – From The Beginning
  • Excel Formulas | Essential formulas
  • Excel Formulas | Essential Functions
  • Excel Functions | Useful
  • Excel Lists | List basics
  • Excel Lists | Sorting and Filtering
  • Excel Pivot tables | Introduction
  • Excel | Advanced Lessons
  • Excel | Case Studies
  • Excel | Conditional Formatting
  • Excel | Excel Beginner Lessons
  • Excel | Excel for Small business
  • Excel | General
  • Excel | Intermediate Lessons
  • Excel | Useful tricks
  • Personal
  • Powerpivot 2010
  • Training Records Management
  • Using Excel for tracking training

Like Excel Expert on Facebook

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Like Excel Expert on Facebook

  • Resources
  • Welcome to the Excel Expert
  • About
  • Blog
  • Contact
® 2019. All Rights Reserved