At the start of this year, I wrote a post entitled Turn a string into a formula with EVALUATE. This post used an Excel 4 Macro as a possible option for turning a string into a formula. These types of Macros were superseded when VBA was introduced in Excel version 5, hence why any macros … Read more
If you speak to anybody who works in the accountancy field, they will always be talking about the “month end”. In all medium and large companies there will be a process at each month end which requires statements to be issued and reports to be distributed. This monthly process fills most finance people with a … Read more
Happy Spreadsheet Day! What are your feelings about allocating days to celebration or awareness of certain things? Like International Talk Like a Pirate Day (19th September), Oatmeal Nut Waffles Day (11th March) or Bathtub Day (7th October)? Well, the 17 October is International Spreadsheet day. Normally, I would think these days are pointless, but I … Read more
There are a lot of circumstances where it is useful for a specific workbook, or workbooks to open whenever Excel starts: Save time by opening workbooks you always use To control the calculation mode To trigger VBA events when you open Excel This isn’t just something interesting you can do with Excel, it’s actually a … Read more
If there is one thing I am certain of, it is this: There is always something new to learn in Excel. Some of those things will be small little tips and tricks, which might help you a bit, but other things you learn will be game changers. These game changers are the things which save … Read more
A few weeks ago, I wrote a post about linking Excel files into PowerPoint. Whilst PowerPoint is probably the application I use most (after Excel of course), in third place would be Word. If, like me, you are regularly creating Word documents, or using standard templates, then learning how to link Excel to Word can … Read more
If you regularly create PowerPoint presentations that include information from Excel, you will know how frustrating it can be. Having to re-copy and re-paste the information every time a change is made in the original Excel documents. Have you come across the feature which enables you to link your Excel workbook directly into your PowerPoint … Read more
I was recently asked this question – “How can I make my workbook read-only?”. I gave the person an answer. However, the real question they were asking turned out to be “How can I make my workbook read-only for everybody but me”. In this post, we will explore some of the options available. Save the … Read more
We have now reached the end of the Mastering VLOOKUP series. Hopefully, you’ve picked up a few tips and tricks to take your VLOOKUP skills to the next level. If you’ve been following along you will have learned more than just VLOOKUP: Download the Advanced VLOOKUP Cheat Sheet There is a lot to remember, so … Read more
Today I would like to share with you the best tip I learned last year. Why has this had never occurred to me previously? I have no idea. But I can honestly say that this has already saved hours of my life. Given the long hours we are expected to work these days, I know … Read more