Outlook offers “Auto-Complete” suggestions for recipients in the To, CC and BCC fields when composing a new email. These can be very helpful, however it can sometimes result in errors when you’re composing a new email to multiple recipients or groups with similar...
Search results
Turn off the Auto-Complete List
How to create a text box
PowerPoint will generally create placeholders for text and images on each new slide unless you choose a blank slide specifically. However, sometimes you will want to create your own. The insert text-box tool is available for this situation.
In the 'Insert' tab of...
What is SmartArt?
Create a SmartArt graphic to quickly and easily make a visual representation of your information. You can choose from among many different layouts, to...
There are multiple ways of highlighting or removing duplicates from an Excel worksheet.
Conditional FormattingConditional formatting can be used to highlight duplicates ready for manual removal. This will use any formatting you select to overlay the data and show you any duplicates....
Excel provides a feature that is intended to split a single column of data into multiple columns. For instance, if you had a column of full names (first and last) and needed to separate these out into two columns:
Text to Columns'Text to columns' is found in the 'data'...
Excel - Find and Replace
Find and/or replace is a powerful feature that allows you to search for a text string within your data set. It will show you all of the times that Excel can see the text string in your document, allowing you to be taken to the next word by clicking the 'next' button. If...
Excel - Drop-down lists
Excel has a feature that allows you to format a cell so that it may only contain certain answers you have specified. These will be displayed as a drop-down list that displays when a cell with the formatting on is selected. This is useful for removing things such as...
PowerPoint - Exporting a PDF
Sometimes you may need to convert your PowerPoint presentation to a PDF for various reasons including printing. This is a very easy process and will duplicate your file assuming you have also saved as a PowerPoint file to start with. But it is reasonably well...
Many of the keyboard shortcuts used in PowerPoint are also used in the rest of the Microsoft office suite.
The following table itemizes the most frequently used shortcuts in PowerPoint.
To do this...
PowerPoint has a feature which allows you to remove the background from an image. Although it has limitations such as needing a high-resolution image and a clearly defined background/foreground, It still has many uses and can allow you to bypass the need for you to search for a cut-out image to...