Be sincere, be brief, be seated.
Franklin D. Roosevelt (FDR) 32nd US President
Be sincere, be brief, be seated.
Franklin D. Roosevelt (FDR) 32nd US President
The SORT function allows you to specify which column to sort by. You can also include a hierarchy to sort by more than one column.
Stories are memory aids, instruction manuals and moral compasses.
Aleks Krotoskm, broadcaster, journalist, and social psychologist
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
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
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
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.
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.