This post is the second in a series about controlling other applications from Excel using VBA. In the first part we looked at the basics of how to reference other applications using Early Binding or Late Binding. In this post, we will look at how we can control Word from Excel even though we don’t Read More
Note: This post was originally only shared with my newsletter subscribers, but I decided it was too good to only share once. Have you ever had a formula which looks like this? Of course you have, we all have. Just by looking at the formula you know it is going to take a while Read More
Whilst this site is primarily about using Excel, there are times when Excel is not the best tool for the job. Each Office application is designed for different tasks. Tables and charts may be easily prepared in Excel, but they are often exported to PowerPoint, Word or Outlook for the purposes of presentation and distribution. Read More
Imagine a situation where you have built a dynamic report or dashboard that you a really proud of. The user can make selections through a drop-down box and the report updates automatically, it’s a beautiful thing. There is just one issue with these types of dynamic reports/dashboards – not all the information is of the Read More
I have never been taught how to use ranges in Excel, I doubt you have either. They are just too basic for anybody to teach, right? Select some cells and there is a : (colon) symbol placed between the start cell and the end cell. Maybe we could throw in a few $ (dollar signs) Read More
Last week we looked at linking Excel directly to Word documents. This can create significant time saving as the Word document updates automatically whenever the Excel file changes. The problem comes when we want to change the file path of the linked document, as it is necessary to change the links one by one. But, 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 linking Excel files directly to your Word document Read More
In my opinion, one of the best functions in Excel is FORECAST. We can feed this function values from the past and it will use linear regression to forecast a value for a future point. We have seen this function previously when we considered how to interpolate a value for existing data. As we saw Read More
In this post, I would like to consider the use of colors in a dashboard (or, for that matter any analysis tool which uses colors to highlight areas of interest). Everybody believes they have good taste, even though everybody has different tastes. When choosing colors for a dashboard the key consideration is not your taste Read More