Alumni

Remove background (Images)

PowerPoint has a feature which allows you to remove the background from an image.  There are limitations such as needing a high-resolution, decent quality 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'  stock 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.

SmartArt

What is SmartArt?

Use SmartArt to quickly and easily make a visual representations of your information. You can choose from among many different layouts including: Lists, Processes. Cycles, Hierarchy and many more. Use their visual design to efficiently communicate your message or ideas. SmartArt graphics can be created in Excel, Outlook, PowerPoint, and Word.

Text box

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.

Text to Columns

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: 

Pivot tables

Pivot Tables

Introduction to pivot tables

Pivot tables can be used for many things however their best function is served by collating data for you. This is easier to create when the data is presented in log format.  What we mean by this is that you should log each transaction individually and not auto-sum or total anything as it will be done by the Pivot table for us.  

an example of a log entry with sales data could be: