February 16, 2021
Recently I’ve had a few requests on how to create drop-down lists in Excel. These are really useful as (a) they are time saving; the user chooses from a pull-down list…
February 16, 2021
January 8, 2021
This has plagued me for years. Your home network is set up exactly as it should be, and folders shared as per instructions. You get prompted for network credentials, and nothing…
January 8, 2021
November 17, 2020
Could you be guilty of saving Word documents as an older version of Word? If so, you’re not alone; in the last 2 weeks I’ve been sent documents by different clients…
November 17, 2020
September 30, 2020
We’re quite excited at the prospect of running the first of our live online sessions on Outlook next week. We start with sessions for two good clients of ours, and to…
September 30, 2020
August 26, 2020
We’re really looking forward to running our ‘PowerPoint Essentials’ session this afternoon for a very good client of ours. It feels like we’ve got into the groove now with these 1¼…
August 26, 2020
August 14, 2020
Here’s a really quick, simple and effective way to create a picture frame for your photos in PowerPoint. You use the Eyedropper tool to ‘pick up’ a colour from your photo…
August 14, 2020
July 31, 2020
Having just finished 5 days work editing a PowerPoint project for a customer, I felt I must put together a few Help videos on some essentials when building presentations. The 5…
July 31, 2020
July 20, 2020
It looks like we’re not going back to classroom training any time soon. E-Learning has its place, but sometimes you need to ask questions and interact with the trainer. So with…
July 20, 2020
July 7, 2020
I’ll try to précis this from a long story. The problem appears to be common, and various not-entirely-convincing solutions are all over the Web in various help forums. Everybody has different…
July 7, 2020
April 21, 2020
You’re engrossed in a project and suddenly get an urgent phone call from another client about a different project. It’s only a ten-minute job so you break off from what you…
April 21, 2020
April 14, 2020
‘Ideas’ is one of Excel’s AI (artificial intelligence) tools that has been around for a couple of years; but is now greatly improved. Watch the video to see how it can…
April 14, 2020
March 4, 2020
Normally when you copy and paste data, Excel will also copy any ‘hidden’ data. But what if you don’t want to copy the hidden rows and columns? Watch the video to…
March 4, 2020
February 26, 2020
If there’s a few of you in your business, then it’s probably worth running a proper client–server network, with a central machine running Windows Server; and client machines running Windows Pro…
February 26, 2020
February 13, 2020
Have you ever needed to create a shortcut key for a special character or symbol that you use regularly in documents? This video will show you how to do just that,…
February 13, 2020
January 21, 2020
There’s not that many of us who remember it now but soon after the invention of the World Wide Web, in the second half of the nineties, all the excitement was…
January 21, 2020
January 15, 2020
For better or worse, everything is commoditised in the end. First it was web design then web hosting. Now it’s the turn of e-learning hosting: there is absolutely no excuse for…
January 15, 2020
November 25, 2019
Ever need to rearrange columns or rows in a list? Here’s a neat trick…
November 25, 2019
November 20, 2019
November 11, 2019
“Where did that data come from?”Sometimes it’s just the little things that can brighten your life. This week: ‘Trace Precedents’.
November 11, 2019
October 30, 2019
Had problems using Excel data in a Word mail merge? Does it change your European dates to US dates?
October 30, 2019
October 30, 2019
Price slashed to £4.99, Course completion certificate, Vastly improved interface and payment gateway
October 30, 2019
October 30, 2019
Two big announcements in this blog: a brand-new Excel PivotTables course, and our very own online academy.
October 30, 2019
October 30, 2019
There are some little-known features of PowerPoint that make a slideshow more interactive.
October 30, 2019
October 30, 2019
A combination of ‘Design Ideas’ and ‘Icons’ can save you time hunting for images.
October 30, 2019
October 30, 2019
Excel Threaded Comments – Comments are now Notes and Comments are something quite different! Watch the video…
October 30, 2019
October 30, 2019
October 30, 2019
October 30, 2019
How an evening at Milton Keynes Geek Night led me to a seahorse…
October 30, 2019
October 30, 2019
We’re doing a lot of ‘screencast’ videos for clients at the moment. These lack interactivity, but are quick and easy to produce.
October 30, 2019
October 30, 2019
If your staff are screaming at you to update a load of Office 2010 individual licences, you should consider Office 365. Learn more in plain English…
October 30, 2019
October 30, 2019
Remember this? Click on ‘Read more’ for my thoughts on working from a home office.
October 30, 2019
October 30, 2019
Click on ‘Read More’ to see if your ideas roughly tie-in with mine…
October 30, 2019
October 30, 2019
Please, always do a skills assessment or training needs analysis before booking somebody on to a course.
October 30, 2019
October 30, 2019
We all remember the Ratner’s debacle, don’t we? Are you sure?
October 30, 2019
October 30, 2019
Excel ‘dashboards’ seem to be the buzz word at the moment; but what, exactly, are they?
October 30, 2019
October 30, 2019
“Freda’s Fall” is now, for the time being, hosted here, at https://www.ldnh.co.uk/FredasFall. I still think it’s one of the best projects we’ve been involved with.
October 30, 2019
October 30, 2019
Too busy to add alt-text to all your photos and images? Now Word 2016 can add it for you automatically.
October 30, 2019
October 30, 2019
October 30, 2019
October 30, 2019
What would Florence Nightingale have made of Excel Charts?
October 30, 2019
October 30, 2019
We should all be using branching scenarios in our e-learning. Here are some pointers to get you started.
October 30, 2019
October 30, 2019
October 30, 2019
October 30, 2019
(First published by Linda on 20/06/2017) Harvard graduate Dan Bricklin (inventor) and Bob Frankston (programmer) first co-presented their idea back in 1977. VisiCalc was then published in June 1979. When asked if they were upset that they never…
October 30, 2019
October 30, 2019
Read about our extensive Microsoft Excel tutorial, which is based on our Excel 2016 classroom course.
October 30, 2019
October 30, 2019
What is that funny little button you see at the bottom of web pages?
October 30, 2019
October 30, 2019
Does it annoy you that every time you open or save a document in Word or Excel it takes more clicks than before? Click on ‘Read more’ for a (very) simple…
October 30, 2019
For archived blog entries, please follow this link.
— Stay up to date using our RSS feed. Not sure what this is? Follow this link to find out.