by admin | Apr 26, 2021 | Case Studies - How To
In this video I want to show you how you would set up a calendar to use in Excel. We will be using the Text() function to extract days and months and then Conditional Formatting to show up the different types of leave. You can download the completed file here. You can...
by admin | Apr 5, 2021 | Case Studies - How To
What happens if you get a list of names and emails from a colleague/customer but they are in a format that you can’t use e.g. someone has CC’d you on the email but you need to have them in proper cleaned up format… In this video I use a file from my...
by admin | Mar 22, 2021 | Case Studies - How To
In this video I show you how to calculate a location allowance but only when certain conditions are met – the Ref number has to be higher than a certain figure and it’s only paid when the employee is from one of four departments. However it also has to be...
by admin | Mar 15, 2021 | Case Studies - How To
In this blog post I want to walk you through the creation of a dashboard in Excel. We will be using Slicers, dropdown lists, pivot tables and the lesser known function – GetPivotData. Oh and we might throw in a chart or two and traffic lights for extra...
by admin | Mar 1, 2021 | Case Studies - How To
Like many of my blog posts this came from a request from an attendee at one of my classes. She wanted to get a better understanding of how to clean up unwanted spaces in Excel – that’s the Trim() function. She also wanted to learn how to combine multiple...
by admin | Feb 15, 2021 | Case Studies - How To
One of my main sources for these blog posts are questions I get from my subscribers and class participants. Recently I had one of my participants ask for help. He had applied conditional formatting to numbers – the idea would be that if the number was greater...
