Excel Pivot Table| Excel pivot table tutorial – create your first pivot table

Published: Fri, 05/18/12


The Excel Expert
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users


Excel Pivot Table| Excel pivot table tutorial – create your first pivot table- 2012-05-14 06:53:48-04

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 the [...]
Read more...


How to filter in Excel | find data in your list- 2012-05-14 06:54:55-04

Excel Filter If you are using a list in Excel, a key skill to have is the ability to filter. Filtering allows you to extract records that meets certain criteria out of your list, so for example if you wanted to find all the transactions you had with a particular company between certain dates, a [...]
Read more...


Sorting in Excel | Excel sort- 2012-05-14 06:56:21-04

  Welcome to this post about sorting in Excel. This tutorial refers to Excel 2007/2010 and later. A couple of things about sorting before you start. The whole experience will be pretty painless if you tidy up your list to make sure you have the following: Formatted headers No gaps of empty rows/columns Have the [...]
Read more...


SumifS function| SumIf multiple criteria Part 1 – text and numbers- 2012-05-14 07:15:42-04

The SumifS function is a new function that was brought in in Excel 2007. Essentially, it is an upgrade for the SumIf function in the sense that it allows you to sum numbers based on more than one criteria. I plan to do another post on this to show you how to use SumIFS with dates. [...]
Read more...


FIX ROW IN EXCEL- 2012-05-17 06:46:17-04

How to fix/lock a reference to a row in Excel In another post I have shown you how to create a reference to a locked/fixed cell. However at times we need to be able to fix a reference  to a row. For example if you need to calculate a set of daily numbers against a [...]
Read more...


HOW TO FIX A COLUMN IN EXCEL- 2012-05-17 06:50:17-04

Fixing a column in Excel Sometimes we need to be able to use the contents of a column over and over again in our formulas. In order to do this easily we need to fix the column. In other posts, I have shown you how to fix a cell and also how to fix a [...]
Read more...


ABSOLUTE CELL REFERENCE- 2012-05-17 06:50:35-04

Fixing a cell in Excel – Absolute Cell Reference Sometimes we want to use the same cell over and over in Excel. The way we do that is by creating an absolute cell reference. You may have come across it already when you have seen dollar signs ($) in formulas. In the video below I [...]
Read more...