by John MacDougall | Jan 15, 2017 | Charts
Get The Completed Workbook Adding symbols into your tables or charts can be a great visual aid to your numbers. In this example we’ll look at how we can add up and down arrows into our number formatting to show increases or decreases in our data. The symbols...
by John MacDougall | Jan 8, 2017 | VBA
If you get a lot of emails and you need to analyse the data in them, then importing your emails from Outlook into Excel with VBA will save you a lot of time. In this post we’re going to explore a way to import all emails in a given folder that were received...
by John MacDougall | Jan 8, 2017 | Charts
Get The Completed Workbook If you want to view your performance versus a target for some metric like sales then a thermometer style chart is a great way to do this. In this example we have a table with columns for the sales person, their target sales and...
by John MacDougall | Jan 2, 2017 | VBA
In this post we’re going to explore how we can make our very own functions (a user defined function or UDF) in Excel that will act very similar to those native to Excel such as SUM, VLOOKUP, INDEX, MATCH etc. You might find you want to create your own formulas...
by John MacDougall | Jan 1, 2017 | Tips
Did you know you can move items in the ribbon around? It can be very useful if you don’t find the default ribbon organization intuitive and you want the change it. This is a trick I happen to use a lot as it’s great for getting the items I need into...