Two years ago, I created my first Excel Add-in. It had just one button, it copied the selected range of cells and pasted it as a picture into a PowerPoint slide. The picture would be in exactly the right place and exactly right size. There was no more copying, pasting, moving and resizing to do, Read More
Creating advanced charts in Excel can take a bit of time, as there are so many things to change. Recently, I had to prepare a financial presentation quickly, like really quickly. I knew exactly which charts were required (I had been given very clear instructions) and I knew how to do them (which is always Read More
“With great power comes great responsibility”, or so we are told in the Spider-man comic book and movies. Microsoft, in Excel, has given us some very powerful features; features which save time, features which make Excel easier to use, features to produce amazing documents. However, these features, in the wrong hands (or even in the Read More
A few months ago I wrote a review of Jordan Goldmeier’s Advanced Excel Essentials. I had a project recently, which I thought this approach would be ideal for. This post is to tell you how I got on. Since reading Advanced Excel Essentials I have also taken Jordan’s Excel Dashboard Pro video course. This course Read More
Updated 01/08/2017 to take into account Excel 2016 updates. If you have ever used copy and paste whilst recording a Macro you will have seen the code which refers to the CutCopyMode: Application.CutCopyMode = False You may wonder why is it there? If you use the copy and paste code without that statement it still Read More
Recently, I wrote a post about what causes Excel’s calculation mode to change. Many users experience the issue where it changes without them realizing it. Due to the way Excel handles the calculation mode, the problem can easily be transferred to other workbooks, which can result in users issuing error filled reports and quoting incorrect Read More
Often when creating a macro, we may need to know the save status a file we are working with. This post explores some of the options available for understanding and controlling this important aspect of file control. Using the .saved property Within the Visual Basic Editor we can view the Saved property of a Read More
Whenever I see promotional images for expensive BI Dashboard software, they always show the same thing – a map with countries or regions highlighted in different colors. It sends the subtle message that maps are the pinnacle of Business Intelligence (whether they are or not is a different matter altogether). Until Excel 2016, these Map Read More
There are times in Excel when we may want to display or use the file name of the current workbook, or maybe the name of a specific worksheet. Whilst there are a variety of options none of them are particularly obvious. This post will consider some of the possible options: Header/Footer section CELL Function VBA Read More
You’re probably aware that Excel has two main calculation modes: automatic and manual. Automatic calculation re-calculates the workbook each time a value changes, or based on specific actions (such as inserting, deleting, hiding rows/columns, or renaming a worksheet). Manual calculation only re-calculates when specifically requested by the user. Formulas -> Calculation -> Calculate Now (shortcut Read More