JMD Training and Consultancy

26/08/2026

https://ifonlyidknownthat.wordpress.com/2026/08/26/microsoft-word-editing-links-to-other-files-when-file-path-has-been-changed/

20/08/2026

https://ifonlyidknownthat.wordpress.com/2026/08/20/microsoft-excel-new-school-year-2026-2027-working-out-relevant-school-year-from-childs-date-of-birth/

School years in the UK run from September to August, so in general it depends on both the month that a child is born in as well as the year. So if you have a list of dates of births and need to wor…

11/08/2026

https://ifonlyidknownthat.wordpress.com/2026/08/11/microsoft-project-2016-changing-defaults-for-saving/

06/08/2026

https://ifonlyidknownthat.wordpress.com/2026/08/06/microsoft-excel-forecast-sheet/

Forecast Sheet, which you will find on the Data tab in the Forecast group, looks at past data and the trends within it, to allow you to forecast what is likely to happen in the future. Open a workb…

03/08/2026

https://mailchi.mp/97ad2fff2738/jmd-training-and-consultancy-august-2026-newsletter

If only I had £50 for every time someone says to me during a training session ‘If only I’d known that last week…’  So, I have set up a blog with some of the answers that have proved very useful to people. You can see this at http://ifonlyidknownthat.wordpress.com/

29/07/2026

https://ifonlyidknownthat.wordpress.com/2026/07/29/microsoft-excel-linking-formulas-to-checkboxes/

I was asked recently if formulas could be linked to checkboxes, so that if something was true, the box would get checked. You can easily do this with an IF function. In the above example, I first i…

21/07/2026

https://ifonlyidknownthat.wordpress.com/2026/07/21/microsoft-excel-functions-used-for-working-out-prizes-in-local-flower-show-sort-choosecols-vstack-and-filter/

I am the Treasurer of our local village show, in which there are 99 classes in which people can win prizes. This then becomes 8 Divisions in which people can win cups. One of my jobs is to work out…

08/07/2026

https://ifonlyidknownthat.wordpress.com/2026/07/08/microsoft-excel-xlookup-and-selecting-returned-columns/

One of the big advantages of XLOOKUP over VLOOKUP is the ability to return several columns at once. However, it may be that we want to bring in the columns in a different order. This is where the n…

05/07/2026

https://mailchi.mp/a847bdafd94c/jmd-training-and-consultancy-july-2026-newsletter

If only I had £50 for every time someone says to me during a training session ‘If only I’d known that last week…’  So, I have set up a blog with some of the answers that have proved very useful to people. You can see this at http://ifonlyidknownthat.wordpress.com/