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
09 – Colour code your entries using Conditional formatting
Conditional formatting Conditional formatting in Excel 2007 (and later) allows us to colour cells on a spreadsheet depending on whether or not they meet certain conditions. While it existed to some degree in Excel 2003, it has been seriously beefed up in Excel 2007...
HOW TO SUBTRACT IN EXCEL
Subtraction in Excel In this post we are going to learn how to subtract numbers from each other in Excel. Again, the key steps to remember are: Click where you want the answer to go Type in = (that tells Excel you are entering a formula) Click on the cell you want to...
04 – HOW TO MULTIPLY IN EXCEL
Multiply in Excel In this tutorial we are going to look at how to multiply in Excel. There are a couple of basic guidelines you should follow when you are using formulas in Excel. As always there is a practice file at the end that you can try out. One number per cell...
HOW TO MAKE A CHART IN EXCEL
Graphs in Excel In this post, I am going to show you how to create a chart in Excel. As always the download file is underneath for you to practise on. Also, the two shortcuts I mentioned were: F11 to create an instant chart on another sheet (after you have highlighted...
05 – FIXING A CELL AKA ABSOLUTE CELL REFERENCE
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...
Case Studies – How To
Clean up your dirty accounts data fast with Power Query | Find your files and folders fast
Excel Novice 5 min tip - Quickly access frequently used files and folders If you need to quickly access frequently used files and folders, use the File | Recent option to find them. Click on File, click on Recent. You will find a list of recently used files and...
Kearney Cycles Streets of Galway 2015 8k – results summarized via an Excel dashboard
Hope you are well. In this tutorial I want to show you how to clean up a data set with a view to analysing it. During the year I participated in my first 8k race and I found myself curious as to how people did etc. So I asked the organisers for the raw data which...
Using Power Query to get your data pivot ready in minutes!
Well, in this blog post I am going to cover a very common scenario - not having your data the right way around to do something with it i.e. make a pivot table from it. However I am going to show you how to do that with a not (as yet) well known add-in for Excel called...
Saving (Time and Date) entry – a useful technique for batches of dates and times
A reader of this newsletter (who wishes to remain anonymous), send me a really interesting file which he uses to quickly enter dates and times. Dates and times can be a bit fiddly to enter as they have to be entered with / for dates and : for times. He came up with a...
CSE – activating your inner Excel Horatio or how to array up your formulas…
Array formulas...one of those things I get asked about maybe once a year. Also the very word "array" makes me go looking for bad puns... One thing it tells me is that the questioner is a serious Excel head. They ain't no Excel sissy, no sirree. However it does mean...
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.