Excel Variance Techniques
When comparing actuals to budget or this year to last year you often calculate the variance and variance %. The variance calculation can be standardised with one simple trick and another function can make sure the variance % has the right sign.
(more…)Sharing a Power Query Between Files
If you have a created a power query to import data you can save it and have another file access it easily.
(more…)Updating Sentences in Excel with New Techniques
I wrote a blog post back in 2012 and showed how to use checkboxes to build a paragraph based on sentences you select. I thought I would update it with recent new techniques.
(more…)Excel Objects and Ctrl + A
Selecting all objects on a sheet in Excel is easy with Ctrl + A. Objects are things like textboxes, images, charts and slicers. If you select one object and press Ctrl + A all the objects on the sheet will be selected. When you select the object make sure the line around it is not dotted. Some objects like text boxes have a dotted line when you are editing the object. Ctrl key After you have selected all the objects…
Unique Entries in a Range in Excel
Sometimes the UNIQUE function won’t return what you’re expecting when you refer to a range of cells. You can use another function to allow you to extract the unique individual values from a range.
(more…)