I ran a webinar in January 2019 where I presented and explained a budget challenge file I had submitted in November 2018. I mentioned during the session that I didn’t like the layout of the Data tab. Well someone asked how should it look? So here is how I would have arranged it. (more…)
In January 2019 I presented a webinar that examined a solution to a 4 dimension budget challenge. Download the materials using the button below and watch the video. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. Download Webinar Materials https://vimeo.com/313089374 NOTE: This is not a beginner’s session. This webinar is based on a budget scenario which you…
The Data Validation dialog allows you to limit or control what a user enters into a cell. There are two keyboard shortcuts to open it. (more…)
Let’s say you have a weekly roster. You have a date and you need to identify the Monday start date for the week that contains that date. The formula is fairly easy. (more…)
Do you use Indenting in reports? Example below. If you do, you make like this keyboard shortcut. To increase Indenting press Alt H 6 pressed in sequence, not held down. To decrease Indenting press Alt H 5 (is that an Outdent?)
Sometimes when writing code you use the same text string in multiple places in your code. To make things easier you should capture that text string in a variable. (more…)
There is a complicated way to extract the entries from a slicer but there is also an easy way to do it. (more…)