Excel 2016 – 1.11.3 – Format a Chart Using The Format Tab
If you want to take the presentation of your Chart that bit further take a moment to look at the features that are available in the Format Tab.
Excel 2016 – 1.11.2 – Format a Chart Using The Design Tab
Once your chart is created you can then select it – or click on it. This enables three contextual Tabs on the Ribbon. In this topic we demonstrate how – using the Design Tab – you can change the type, style and appearance of your Chart.
Excel 2016 – 1.11.1 – Create a Column Chart
So now you have your figures together, it may be useful to present this information in Chart format? Watch this video and learn some basic steps to correctly select your data. Also discover different techniques to quickly create a Column or Comparison Chart.
Excel 2016 – 1.10.4 – Scale Multiple Pages To Fit On One Page
In this video we show you some tips to organise your data on to one page for printing – as a means of viewing or checking the appearance of your Excel information.
Excel 2016 – 1.10.3 – Display Two Copies Of The Same Workbook
An alternative to applying a Split Screen is to display your worksheet twice – or side by side – on the same screen. Learn the steps here.
Excel 2016 – 1.10.2 – How To Split a Screen
This is a very useful feature when working with large amounts of data. Splitting a screen allows you to work with data in one part of a large Table whilst viewing the consequences of your changes in a different part.
Excel 2016 – 1.10.1 – Freeze Panes
Scrolling down or across a large list of data can be frustrating when we lose sight of our Column and Row Headings. Watch this video and learn how the Freeze Panes feature allows us to ‘lock’ Column or Row Headings as we scroll.
PowerPoint 2016 – 1.8.8 – Carry out a Spell Check
Spell Check is vital! It’s so embarrassing to spot a spelling error that you have made – when you’re giving the presentation. This video brings you through the different choices that the Spell Check offers.
PowerPoint 2016 – 1.8.7 – Make Final Changes
Our slides are nearly ready to have animations applied to them, so we’ll take one last look through each slide to make sure everything sits on the slides the way it should.
PowerPoint 2016 – 1.8.6 – Remove Footer & Slide Number from the Title Slide
You don’t always want to see Footers and Slide Numbers on the Title Slide of a presentation, so this video shows you how to leave them out, of that slide only.
PowerPoint 2016 – 1.8.5 – Create Headers, Footers & Slide Numbers
Headers and Footers allow you to put in information in one place, that repeats across all slides.
PowerPoint 2016 – 1.8.4 – Remove a Theme
Discover in this video how to remove a Theme – whether it is an in-built PowerPoint Theme or your Company Template.
PowerPoint 2016 – 1.8.3 – Change Colours, Fonts & Effects in a Theme
The Theme we’ve applied is very ‘in your face’ colour-wise! Let’s see how we can make adjustments and tone down the look and feel of the presentation.
PowerPoint 2016 – 1.8.2 – Apply a Presentation Theme
In a working scenario you will apply your ‘Company Template’ to your presentation, which is actually a Theme. We are going to apply a PowerPoint Theme to our Presentation. This video explains Themes and what they affect, and show you how to apply one.
PowerPoint 2016 – 1.8.1 – Apply a Background Colour
Most users will be applying a Company Theme to their presentations. However, we do have the ability to apply our own backgrounds, if we need to. This video takes a quick look at where those backgrounds are – and how to apply them.
PowerPoint 2016 – 1.7.4 – Slide Show View
Slide Show View gives you full screen mode, which is what you will be using on the day you give your presentation.
PowerPoint 2016 – 1.7.3 – Notes Page View
Keep any extra notes about items that you want to mention, in the Notes area. These do not appear in Full Screen mode, so will not be seen by others.
PowerPoint 2016 – 1.7.2 – Slide Sorter View
Slide Sorter View is great for getting an overall view of the layout of the slides. We’ll be looking at moving slides around – and deleting slides.
PowerPoint 2016 – 1.7.1 – Outline View
A number of different views are provided within PowerPoint and it’s a good idea to familiarise yourself with each of them, then use the one that is appropriate at any given time. Outline View is a text based view only.
PowerPoint 2016 – 1.6.6 – Format Flowchart Shapes
Learn how to select and format the main Shapes and then, separately, the Connector Lines.
PowerPoint 2016 – 1.6.5 – Create Arrow Connectors and Text Boxes
This video shows you how to use and add different types of Arrow Connectors and also how to put in a Text Box for rejection of ideas.
PowerPoint 2016 – 1.6.4 – Place Text into Shapes
Each part of the Flowchart has a specific purpose so we need to write up that purpose in our Shapes.
PowerPoint 2016 – 1.6.3 – Different Ways to Align Shapes
We’ve seen how the Ruler, Grid and Guidelines help with our Shapes and now we’re going to look at some of other ways provided to help with the alignment of our Shapes.
PowerPoint 2016 – 1.6.2 – Create Flowchart Shapes
There are specific shapes provided for creating a Flowchart and this video will show you how to use them.
PowerPoint 2016 – 1.6.1 – Turn on Grid and Guides
When working with Shapes it helps to have visual alignment guides turned on.
PowerPoint 2016 – 1.5.5 – Remove Style and Crop a Photo
The middle photo could do with being cropped at the top and bottom to remove parts that are unnecessary. To use the Crop feature, we must first remove the Style.
PowerPoint 2016 – 1.5.4 – Resize and Style Photos
Our photos look too big and clunky on the slide, so we’ll resize them and attach a different style to each, to give them a more polished look.
PowerPoint 2016 – 1.5.3 – Insert Photos
We’re going to show three new products that we’re testing, so will insert three photographs onto the one slide.
PowerPoint 2016 – 1.5.2 – Change the SmartArt Layout and Style
The SmartArt Graphic that we’ve chosen doesn’t look as good as we’d like it to, so let’s take a look at some of the other Layouts and Styles that are provided for us.
PowerPoint 2016 – 1.5.1 – Create a SmartArt Graphic
SmartArt is a pre-created Graphic structure that can be used to great affect within PowerPoint.
PowerPoint 2016 – 1.4.7 – Create a Chart from existing Excel data
If you already have the data typed up in Excel then you do not want to re-type it in PowerPoint. This video shows you how to bring in your information from Excel, to create a PowerPoint Chart.
PowerPoint 2016 – 1.4.6 – Change Chart Design
See how you can format the chart either using pre-created designs or by manually changing the colour of the Columns or the text.
PowerPoint 2016 – 1.4.5 – Switch Between Columns and Rows
If you want to ‘turn the data around’ in the chart – in other words the Legend becomes the X axis and vice-versa, then there is a button that does that. However, it can be a little quirky to get it working…
PowerPoint 2016 – 1.4.4 – Change the Chart Layout
PowerPoint has some pre-created Layouts available for you to select. We’re going to look at some of those Layouts.
PowerPoint 2016 – 1.4.3 – Change the Chart Type
We went with the default Chart Type which is a Column Chart. But maybe you’d prefer a Bar Chart or a Line Chart. This video shows you that you can change your mind very quickly, at any time.
PowerPoint 2016 – 1.4.2 – Edit Chart Data
If you want to add new data to the Chart or change some of the existing data, then you need to re-open that Excel data sheet. This video shows you how to make those changes.
PowerPoint 2016 – 1.4.1 – Create a Chart
This video brings you through the steps required to create a chart from within PowerPoint itself.
PowerPoint 2016 – 1.3.9 – Create a Table from Existing Excel data
If you already have the data for your Table in Excel there should be no need to create it again in PowerPoint. Discover in this video how to place existing Excel data into a Table in PowerPoint.
PowerPoint 2016 – 1.3.8 – Create a Table from Existing Word Data
If you have a Table already created in Word, you do not want to re-create it again, in PowerPoint. Learn how to bring that existing data into your PowerPoint presentation.
PowerPoint 2016 – 1.3.7 – Use Table Design Styles
Use the Table Design Styles that are provided with PowerPoint to change the look of your Tables.
PowerPoint 2016 – 1.3.6 – Align Text in a Table
See some of the formatting features that we can apply to our text such as how to centre our headings both horizontally and vertically.
PowerPoint 2016 – 1.3.5 – Adjust Table, Column and Row Size
Easily adjust the size of the Table itself, then look at adjusting the Columns and Rows within the Table. When it all turns into a mess, see how to quickly fix it all up again.
PowerPoint 2016 – 1.3.4 – Delete Columns and Rows
Now that we know how to insert Columns and Rows, we need to learn how to delete unwanted Columns and Rows.
PowerPoint 2016 – 1.3.3 – Insert Columns and Rows
This video will show you two different ways to insert Rows and one way to insert Columns.
PowerPoint 2016 – 1.3.2 – Populate the Table
In this video we’ll add some data to our Table using a mix of text and figures.
PowerPoint 2016 – 1.3.1 – Create a Table
Discover in this topic how to create a Table and learn how to move around the Table using the keyboard.
PowerPoint 2016 – 1.2.5 – Adjust the Line Spacing
Learn the correct way to adjust the Line Spacing in your text boxes, so that the text is clear and easy to read.
PowerPoint 2016 – 1.2.4 – Indent Bullets Using the Keyboard
In this video we demonstrate how to ‘indent’ and ‘outdent’ bulleted text using the keyboard.
PowerPoint 2016 – 1.2.3 – Create and Indent Bullets
In this topic we show you how to ‘indent’ and ‘outdent’ bulleted text using commands on the Ribbon.
PowerPoint 2016 – 1.2.2 – Basic Text Formatting
Watch this video and learn how to use some basic text formatting features, at the end of which we’ll be using the Undo button.
Download the supporting documents we use in our videos: