by admin | Feb 14, 2023 | Excel Path - Step by Step
How to link external files into an Excel file and then change if required A common requirement is to pull data from one Excel file into another. You should begin by setting the scene. i.e. make sure you have all the files you need open. Let’s call those source...
by admin | Feb 22, 2022 | Excel Path - Step by Step, Excel | General
Excel has really upped its games around charts in the last couple of editions but there are some charts that are not so well known. In this blog post I am going to introduce you to two of them: The Tree Map and the funnel. You can use this file to practise on and here...
by admin | Oct 18, 2021 | Excel Path - Step by Step
I was recently asked in a class about grouping entries together. In that case it was fish lengths but what I show here applies to a wide range of options. The first method shows you how to use the inbuilt facilities of Excel pivot tables to group numbers into...
by admin | Jun 21, 2021 | Excel Path - Step by Step
In this tutorial what I am looking at is the alternative to Vlookup() – Index/Match which is – astonishingly enough – a combination of two functions: Index and Match. I give an explanation of Match in this tutorial as well. You can download the...
by admin | May 18, 2021 | Excel Path - Step by Step
This blog post came about as the result of my own incompetence. I made a rookie error – FORGOT TO PRESS RECORD….So this is an example of an exercise I would use in class. You can download the completed file here.. and if you are feeling full of enthusiasm...
by admin | May 15, 2021 | Excel Path - Step by Step
So for this I am going to walk you through one of the exercises I do with my learners when I am teaching Conditional formatting – particularly using the Highlight Cells Rules options. This is a file with the exercises in it. Here are the questions The number of...
