by admin | May 14, 2012 | Excel Path - Step by Step
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...
by admin | May 14, 2012 | Excel Path - Step by Step
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...
by admin | May 8, 2012 | Excel Path - Step by Step
Countif Function Again, Excel Countif is a function (not always so well known in Excel that has many uses. Let me give you a couple of examples.. You want to count the number of Nos or Yeses in a list… You want to count the number of items in a list that are...
by admin | May 8, 2012 | Excel Path - Step by Step
Using Sumif One of the more useful (but lesser known functions in Excel is the SumIF function. This has been available in most versions (unlike the SumIFs function – which I am going to cover in another post). So what does it do? Let me give you a couple of...
by admin | May 3, 2012 | Excel Path - Step by Step
Excel min In this post we are going to look at the min function (which finds the lowest value in a list) [flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/05_min_demo.m4v’] As always, here is a file you can practise...
by admin | May 2, 2012 | Excel Path - Step by Step
Excel count text If we want to count the number of names (or list of entries with mixed text and numbers), the count function will not work – simply because it is designed to count NUMBERS only. In this case we have to use the CountA function. See video below...
