News & Tips
Creating A Simple Macro In Excel (Step-By-Step)
Creating a simple macro in Excel is not a daunting task. Now it may seem contradictory, but you do not need to learn Visual Basic for Applications (VBA) to record simple macros in Excel. VBA does however, come in handy…
Microsoft Excel: How To Email An Excel File Without Leaving Excel
If you frequently email your colleagues Excel files (and how doesn’t) this is a quick tip to speed things up by doing that directly from Excel. You don’t need to hop across to Outlook. How To Share your Excel Work…
(Ultimate Guide) Create Random Numbers In Excel!
Seeking to extract a sample out of a diversified population? Or working on some stuff and looking for ways to generate precisely random numbers? In either case, if you want an unbiased set of random numbers, the Excel random number…
How To Remove The White Background From A Picture: Adobe InDesign
Removing a white background from an image in Adobe InDesign is a straightforward and important process. The same process can be used for backgrounds of any colour. It can be useful when dealing with multiple, overlapping images, or if your…
Creating and Using Named Ranges in Excel
How would your data look if it had clear written descriptions instead of general titles? It would be easier to present, and for others to work with. Named ranges are one of the most unutilised features of Excel. A named…
Why Are My Images Fuzzy And Low Res In InDesign?
When I started using InDesign, I thought something was wrong. All my images were blurry and low-res. I couldn’t understand what was going on. It turns out that this is a great feature of InDesign’s once you have learned more…
Comprehensive Guide To Outline View In PowerPoint
What is this unknown and brilliant Microsoft PowerPoint view I hear you cry? It’s the PowerPoint Outline view, found in the View Ribbon in the Presentation Views group. I’ve circled the View tab and the Outline view command below so…
Add Simple Borders [Quick Guide]
Learning to present the data in your spreadsheets clearly is extremely important. Unclear and poorly laid out spreadsheets are much more likely to contain errors. Excel contains lots of data validation tools but it is better to get your calculations…
How To Use The Ruler And Showing Paragraph Marks In Word
Although some people use the space bar to format their documents, things rarely line up correctly. Whilst this may be okay for informal documents, if you are creating professional documents like reports and brochures, you will want to make sure…
Creating Columns For A Newsletter – Word
Columns are a great way to format your text in a unique way in Microsoft Word and an important part of your document. When creating a Word Document, attention must be paid to making your text accessible and are used…
How to Create and Use Building Blocks in Microsoft Word
When using Microsoft Word, there will be times you want to re-use a certain picture or text in different documents. There is a handy tool where you can save the content you want to re-use. This is known as a…
Using Find and Replace and Using GoTo in Word
Although you can easily navigate through Word documents with your keyboard and mouse, if you’ve got pages and pages to scroll through, it can take quite a while. What’s even more time consuming is when you realise you need to…