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 FOR BEGINNERS | HOW TO FIX A COLUMN IN EXCEL
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 row Excel Products...
FIX ROW IN EXCEL
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...
SUMIFS FUNCTION| SUMIF MULTIPLE CRITERIA PART 1 – TEXT AND NUMBERS
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...
SORTING IN EXCEL | EXCEL SORT
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:...
HOW TO FILTER IN EXCEL | FIND DATA IN YOUR LIST
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...
Case Studies – How To
Running up that hill : Using Excel to track running and recovery times
Quite recently I was teaching a class, afterwards I got chatting to one of the participants and it turned out that she does a lot of coaching with runners. Of course I picked her brains about some stretching techniques and she gave me some great tips about pre-running...
Marriage Equality and mixed charts
Well, in Ireland recently we had an historic day when same sex marriage was voted in (first country in the world to do so...). It was also known as the Thirty-fourth Amendment of the Constitution (Marriage Equality) Bill 2015. You can read more about it at...
Filter one list depending on contents of another plus intro to hurling
I recently met with a friend of a customer and after I let him into the secret of pivot tables, he asked me about helping him create two dropdown lists. The idea being that the contents of the second one would depend on what was chosen in the first one. In the example...
Only adding up what is visible and filtered.
I recently got asked this in class..one of the students had received a file from one of their customers (who had hidden some of the rows) and he wanted to only get the total for the visible, filtered rows. I tried a couple of things - including Visible Cells only (F5...
Time keeps on slippin’ slippin’….roundin’ on up to nearest 15 minutes
Anyone get that song reference? I give you a clue down the bottom of the post... Well have to say I do love my students (in a good way...not a weird way I hasten to add. :-).). I recently had a woman in class who had the following Excel conundrum... She needed to...
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.