Stories are memory aids, instruction manuals and moral compasses.
Aleks Krotoskm, broadcaster, journalist, and social psychologist
Monthly Archives: November 2024
Webinar Feedback November 2024
Financial Functions Part Two
“This accounting webinar series is one of the best for practical CPD hours. It focuses on things we actually use in our day-to-day work, like Excel models and useful tips, instead of theory or topics we may never touch depending on your area of expertise.
It’s clear, easy to follow, and you come away with skills you can put into practice right away. Highly recommend it for anyone wanting CPD that’s actually helpful.”
10/10
C Walthew
November 2024
Grouping Images for Effect in Excel
Using textboxes by themselves can be a good way to add extra content to a spreadsheet. Combining a text box, an icon and an arrow with some colour may make it even better.
The road to success is always under construction.
Lily Tomlin
Excel Formula Updating Technique [Video]
A recent project required editing many formulas to insert an IF function to display the NA error in certain circumstances. Here’s how I did it.
You’re never going to kill storytelling, because it’s built into the plan. We come with it.
Margaret Atwood author of The HandMaid’s Tale
Are you Partial to Calculations?
Excel has re-badged one of the Calculation Options in the Formulas tab – see below. This is a change relating to the new Python capabilities.
The middle option used to ignore Data Tables (a What If feature on the Data ribbon tab).
The newly named Partial option also ignores Data Tables plus any Python calculations that may take a long time to calculate.
Python calculations are done in the “cloud” and require an internet connection.
Excel YTD Reporting Solution
Having Actuals, Budget and Variances for each month going across the page is a very common reporting construct. Here is an easy way to sum the correct YTD values as the year progresses.