Alumni

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 start with.

Inserting an Image

The first step to remove the background of an image is to insert the image you wish to remove the background from. If you are not sure how to add an image to your PowerPoint, there is a guide here.

PowerPoint - Zoom Slides

PowerPoint has a new feature which mimics the style of presentation of Prezzi, using one large slide to place all of the subsequent slides on. Throughout the presentation, these slides will be zoomed into when that slide is reached, giving the impression that the whole presentation is encapsulated into a single slide. 

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 spelling errors or typos and allows less chance for error whilst inputting 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 you then wish to replace a text string with your own input, en masse or individually.

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: 

There are multiple ways of highlighting or removing duplicates from an Excel worksheet. 

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 effectively communicate your message or ideas. SmartArt graphics can be created in Excel, Outlook, PowerPoint, and Word, and they can be used throughout Office.

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.

What is a bookmark/favourite?

A bookmark is a web browser feature used to save a web site's URL address for future reference. Bookmarks save user and browser time, which is especially useful for Web pages with long URLs or accessing a specific part of the site that might not be the homepage for the site. For instance a specific Moodle page instead of the Moodle homepage.

Content transferred.