Session 10 - PowerPoint Templates

We have covered most of the application stuff with Access, Excel and Word. We haven't covered any advanced PowerPoint because there just isn't really anything hard or advanced about PowerPoint.
Creating a PowerPoint theme
I am assuming that you all know a bit about PowerPoint and how to create a presentation and apply a theme to make a plain presentation look really swish, so today I will show you how to create your own theme.

Start by loading PowerPoint using a Blank Presentation.

To be able to create or change a Theme, you need to change the view to Slide Master. You can access this from the View tab.

Your presentation area will now contain the "Master" versions of all of your slides.

Once you are in Master Slide View, you can customise and create your own Template. Many organisations will have their own template for presentations - this allows a consistent look and feel within the organisation. Chisholm has one that staff can download from our Intranet and use for any Chisholm Presentations.

Start by deciding which elements you want on each slide - things like date and slide number

To create a nice background, you can add an image, shapes, gradient, or solid colour. Make sure you are at the top of the tree in the slide navigation pane.



You can start by changing the background colour. Use the various tools within the Background section of the ribbon. My example has a gradient background in yellow/red, an image in the top right hand corner, a small graphic in the bottom left corner (kinda like eggs), and the business name centre bottom.

A solid colour in the background also works well!! Make sure that you are on the top slide if you want all of the slides to have the same stuff on it.

In this sample, I used a solid background and placed some shapes on it to give it a bit of interest. To make sure that the shapes are behind any text, you can use the send backwards option.

Change the text styles and colours.

and finally, decide which layout slides you want to include in your theme.

You can also add your own custom layouts - I have one that I have moved the title to the bottom and added an online image

When you are happy with your new theme - Save it, but make sure you take a note of where it gets saved.

Now that you have your theme and saved it, you can use it. You can start a PowerPoint presentation using your template or apply your theme to a presentation you have previously created.

Useful Formatting Tools

When you are creating your theme, remember some of  the tools that will help you!!

Transparent Colour in Images

Remove Background

Grouping Shapes

Bringing Forward or sending Backwards

This will change the order of the items in a stack.

The following example has a starburst behind a shape. See what happens when it gets moved forward.

ASSESSMENT TASK

Create your own PowerPoint Theme for a fictitious library or if you don't have one, for Mysty River Regional Library Services.

Create a template/Theme that is suitable for your organisation

• Main Title slide to be slightly different
• Must include a custom slide

Marks awarded for:

• orignality and meets above specifications 10%
• Use of  Tools 5%
• Suitability for presentations 5%

Session 10 - Don't forget your Protection

I know we have completed Excel, but I just thought that I would quickly cover one last thing before we put it away.

Protection

Some of you may have already had "the talk" and be aware of the protection, but there may be a couple who haven't so this is a quick and nasty version.

Why Protection? The best reason to use protection (apart from the obvious) is so that all the great work you have done in preparing, formatting, and perfecting your spreadsheet is not ruined by someone putting information in the wrong spot.

By default, all of the cells in Excel are "protected", so if you want people to be able to edit cells, you need to unprotect them or unlock them. Any protection that is applied to individual cells is not enforced until the actual spreadsheet is protected.

To unprotect the cells, use Format Cells.

Once you have unprotected the cells that YOU want people to be ABLE to access - protect the sheet.

There are a few different levels of protection that you can apply. You will find these under Review.

OR from the Home Ribbon

 

You can be very specific about what you will allow others (or yourself) to change when using the spreadsheet and you can set a password which must be entered before the spreadsheet can be unprotected. Stay safe people!!

Session 9 - Validating cell data and advanced charts

Data Validation

Data Validation is simple in Excel 2013. You can access the data validation button from the Data ribbon.

For this example, I will be using the Pivot Table spreadsheet.

To start with, I am going to validate the Branch.

Click on the Data Validation button to load the dialog box.

We want to restrict the data that can be entered to ensure that a valid branch is entered. The easiest option is to choose List and allow the user to select the Branch from a drop down list. You can either type in the items for the list separated by a comma, or you can have the list items on the spreadsheet and put the range details in.

You can validate other data types such as numbers and dates.

You can also set up validation and check to see if there are any cells that do not meet the criteria. One way of doing this would be to copy and then using Paste Special, paste only the validation.

Validation with Form Controls

You can also use form controls to validate data. This is useful if you want to use one of the funky control slike spin buttons or check boxes.

Here is an example using a spin button

Combo Charts

Combo charts allow you to have different values in your chart represented using different chart types. Here are some examples.

ASSESSMENT TASK

Now for your Excel assessment task. I did tell you that it was easier than the Access one - It is. See assessment sheet on Moodle for details.