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

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

Another way to “pivot” or “unpivot” – Excel style

by admin | Dec 14, 2020 | Excel | General

This year has been the year of the pivot – so many people have had to pivot in their lives, both personal and professional. Pivot is defined as the action of turning around a point but of course in Excel it invariably means pivot table – which is basically...

Planning a Pivot Table | Guidelines – from Debra Dalgleish MVP

by admin | Nov 4, 2016 | Excel | General

Debra Dalgleish (http://www.contextures.com) is one of my Excel heroines and the pivot table guru. She is someone whose work I regularly reference in class. I recently asked her to help me answer a question that regularly comes up in class when people ask about pivot...

What’s happening? | Powerpivot, Breaking Bad and Behind the Candlebra

by admin | Nov 24, 2014 | Excel | General

Well, have to say I’ve been off the grid (at least for this blog post) for the past while but my intention is certainly to begin blogging again – bringing you lots of tutorials and interesting tricks and tips from the world of Excel. Recently I have been...

02 Powerpivot | Installing Powerpivot – and how do I start?

by admin | Sep 10, 2014 | Excel | General, Powerpivot 2010

So if you have read my first post in this series on Powerpivot, and you are thinking about exploring it a bit more here are some resources to check out. Installing Powerpivot There are two versions one for 32 bit machines and the other for 64 bit machines. You can...
« Older Entries
Next Entries »

Excel shortcut keys – FREE

Recent Posts

  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style
  • Faster Filtering with Filter()
  • How to create a unique ID in Excel

Categories

  • 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

Like Excel Expert on Facebook

Recent Posts

  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style
  • Faster Filtering with Filter()
  • How to create a unique ID in Excel

Like Excel Expert on Facebook

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