Mouse Training Blog

Mouse Training Blog

All the good stuff is in the Mouse Training Blog. Hints and tips, bits and pieces, handy Excel formulas, typographical tricks, on and on. Check it out!

See our Hints and Tips videos

Mouse Training Blog

Usually the formulas you need for percentages and differences are quite straightforward: divisions for percentages and a minus sign to take one value from another. But there are pitfalls for the unwary which we shall explore.

Read More »
Mouse Training Blog

I think the Excel FILTER function does the filter job better than AutoFilter. It’s a live formula and an extraction, you don’t have to filter your data in place. There’s no need for that clunky Advanced Filter…

Read More »
Mouse Training Blog

You can use the Excel UNIQUE function to extract a list of unique or distinct items from a range of Excel cell values. It’s really easy. See how to sort the results automatically when the data changes…

Read More »
Mouse Training Blog

You can use Excel’s ROMAN function in a formula whenever you need to express normal, Arabic numbers as Roman numerals. And you can use the ARABIC function to convert them back the other way…

Read More »
Mouse Training Blog

Generating random text or Lorem Ipsum for Word and PowerPoint. Do you ever need filler or placeholder text for Word documents or PowerPoint text boxes? It’s quite handy when you want to plan the design and layout of your document…

Read More »
Mouse Training Blog

Do you ever have to deal with those cluttered PowerPoint slides? You know; the ones crowded with layers of overlapping shapes and text boxes—and you need to change the one in the middle of the pile…

Read More »
Mouse Training Blog

I must say that I quite like Keynote, and prefer it to PowerPoint. But if there’s one thing that gets my goat, it’s those pesky text boxes! You can’t seem to resize them properly. What you need is an 8-handled text box…

Read More »
Mouse Training Blog

Text in browsers and documents usually wraps onto the next line at the first available space or hyphen. Which is fine most of the time, but not always. What if I have text where I need to keep the words together…

Read More »