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.
Lorem Ipsum for Word and PowerPoint
Generating Random Text for Word and PowerPoint
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 and check out different fonts and formatting options etc. Being an expert typist, I always used to type in double-encrypted blah, blah nonsense like this, “jkhj kefhkfh kjhjkhf hfshf jhkjhs” until I discovered random text functions. However, my typing speed has suffered, I was quite impressive typing “jkhj kefhkfh kjhjkhf” but now I’m back in the land of hunt and peck.
Random Text
To generate some random text, click on your document or on a PowerPoint text box, type in =RAND( ) and then press the ENTER key. Don’t forget the equals sign at the start and both the brackets at the end. You’ll get some paragraphs of random text. To control the number of paragraphs, enter a number inside the brackets. So, =RAND(5) gives you five paragraphs.
Lorem Ipsum
If you have a classical bent then you may prefer some Latin, in which case type in =LOREM( ) and you get paragraphs of lorem ipsum.
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Lovely!
To see how to create great presentations, come along on our PowerPoint Introduction Course.
Call 020 7920 9500 for full details.
Related Posts
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…
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…
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…
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…
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…