The Excel Expert Blog
Tracking Training Records in Excel
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Excel Path – Step by Step
EXCEL PIVOT TABLE | EXCEL PIVOT TABLE TUTORIAL – CREATE YOUR FIRST PIVOT TABLE
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...
COUNTIF FUNCTION
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 less...
EXCEL SUMIF FUNCTION
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 scenarios:...
EXCEL MIN FUNCTION – FINDING THE LOWEST VALUE IN A LIST
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 with The...
12 – COUNT TEXT IN EXCEL – USING THE COUNTA FUNCTION
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 ...
Case Studies – How To
Mind the gap – quickly fill in gaps for repeating data
Recently, I had a quite bizarre experience. In the space of an hour I was asked for help from two of my wonderful subscribers for help with the SAME PROBLEM... so that made me think that perhaps more of you would find this useful. Essentially this is the problem. You...
Calculating exam results : pass, fail, compensation pass
I recently got a request through LinkedIn from someone I met at a conference who wanted to know how she could do the following.. She wanted to calculate exam results given the following parameters. " If they do not fail any module but can now have up to a maximum of 3...
Part 2 – Make a table of all lists in Excel…looks good and makes updates simple
Well, here's the second part of this 2 part series on using tables for your data. You can read Part one here. I've decided to use the same data again from this file but in this video below you can see how I've (1) cleaned up the data a bit and you can also see how...
Part 1 – Make a table of all lists in Excel…looks good and makes updates simple
Well, folks, I've been off the blogging grid for a while. Not going to make any excuses about this. But plan to get back on the blogging horse again...me thinks I feel a joke about "blogging a dead horse" coming on...but I shall restrain myself. OK, so what are tables...
Calculating correct age for competitions with a cut off date
Got presented with an interesting dilemma recently. If you (or your children or any children you know) compete in anything there is usually an age cut off point. For example my son competes in music competitions and the cut off date for each year is 1st January i.e....
Excel – General
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Random
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.
Personal
No Results Found
The page you requested could not be found. Try refining your search, or use the navigation above to locate the post.