Excel 2016 – 3.2.4 – Apply Pivot Styles
The default PivotTables Style is based on a blue colouring – but if blue isn’t your colour, then you can easily change the Style to any of the other pre-created Styles that Microsoft provides.
Excel 2016 – 3.2.3 – Change the Pivot Layout
Maybe you’d like to remove the Grand Totals or add Subtotals to each Group. Maybe you’d like to add space between each Group to make it easier to read. Learn how to quickly and simply alter the layout of your PivotTable.
Excel 2016 – 3.2.2 – How to Rename Field Headings
This video shows you how to change the field headings to be more understandable. It will also show you how to overcome a very common problem that you will encounter when renaming those field headings.
Excel 2016 – 3.2.1 – How to Display Blank Cells
Learn how to display the blank cells that appear in a PivotTable – as zeros.
Excel 2016 – 3.1.11 – Set a PivotTable to Refresh on Open
By default, PivotTables have to be manually Refreshed. However, there is a way that you can set them up to automatically Refresh whenever the Workbook is opened. In this video we’re going to see how you turn on that feature.
Excel 2016 – 3.1.10 – Refresh the Data
This video shows you that if you increase your original dataset you then need to Refresh the PivotTable so that it picks up the new data. If your original dataset was turned into a Table before being made into a PivotTable we’ll see that the Refresh is very simple. However, if the dataset was not […]
Excel 2016 – 3.1.9 – Insert and Use Slicers
Slicers are an excellent feature for filtering a PivotTable. In this video learn how to create, modify and delete Slicers.
Excel 2016 – 3.1.8 – Create a PivotChart
This video shows you how easy it is to create a PivotChart. PivotCharts, like PivotTables, are dynamic and you’ll see that reflected in this video.
Excel 2016 – 3.1.7 – Drilldown Into Pages
This video will show you how to quickly drilldown the Location field to show a separate Worksheet and PivotTable for each of the individual Locations. A very powerful feature of PivotTables.
Excel 2016 – 3.1.6 – Drill into Pivot Data
This video shows you how you can drill into any of your figures and get a breakdown of the sales that make up a figure. We’ll show a single drill-down, but you can drill-down on as many figures as you like.
Excel 2016 – 3.1.5 – Filter and Ungroup Pivot Data
This video shows you filtering and how it works differently with Grouped information. You’ll also see that Grouping stays with data, even when removed from the PivotTable, so if you want data to be Ungrouped, you have to manually carry it out.
Excel 2016 – 3.1.4 – Group a PivotTable by Date
The dates in the Date column span 2 years. This is the correct way to input dates in your dataset, if you want to create a PivotTable. However, to display the information by Year we need to know how to Group those dates. We’ll take it a step further and Group by Quarter, within Year.
Excel 2016 – 3.1.3 – Add Currency Style to Pivot Data
Believe it or not, there is a correct way and a wrong way, to turn on the Currency style in a PivotTable. Learn the correct way, but also discover why the wrong way – is wrong.
Excel 2016 – 3.1.2 – Create a Basic PivotTable
This video shows you how easy it is to create a basic PivotTable. We’ll then build on this PivotTable over the rest of videos in this lesson.
Excel 2016 – 3.1.1 – View and Setup Data
Data to be used in a PivotTable must be structured in a way that Excel understands, or it just won’t work properly. This video will show you how to correctly set up your data, in the ‘Tabular’ way, that PivotTables understand.
PowerPoint 2016 – 2.5.10 – Use the Animation Painter
If you want to apply the same Animations to multiple objects, then you can use the Animation Painter to do so.
PowerPoint 2016 – 2.5.9 – View Special Effects for Charts
There are extra effects available specifically for charts – but be aware you can only access them with some, but not all, of the Entrance Effects.
PowerPoint 2016 – 2.5.8 – View Special Effects for Bullets
Bullets have extra effects attached to them. Learn what those effects are.
PowerPoint 2016 – 2.5.7 – Change the Order of Animations
Sometimes we need to change the order that our Animations take place in. This video shows you how.
PowerPoint 2016 – 2.5.6 – Use Multiple Animation Effects
If you want to have an Entrance effect, an Emphasis effect AND an Exit effect, then this video shows you how.
PowerPoint 2016 – 2.5.5 – Remove an Animation
The type of Animation you have used, determines how you remove it. See how it’s done.
PowerPoint 2016 – 2.5.4 – Understand the Motion Paths Effects
Motion Path effects deal with the way an object moves around the screen. Never seen a penguin fly? Keep watching!
PowerPoint 2016 – 2.5.3 – Understand the Exit Effects
Exit effects deal with the way that an object leaves the screen. Let’s take a look at some of those effects.
PowerPoint 2016 – 2.5.2 – Understand the Emphasis Effects
Emphasis effects take place on objects that are already on the screen. Let’s take a look at some of those effects.
PowerPoint 2016 – 2.5.1- Understand the Entrance Effects
Entrance effects deal with the way that an object appears onto the screen. Let’s take a look at some of those effects.
PowerPoint 2016 – 2.4.10 – Play and Hide Audio Automatically
We are going to set up our Audio so that it starts playing automatically, when we go into Slide Show view. That means we don’t need to see it, so we’ll also hide it.
PowerPoint 2016 – 2.4.9 – Trim Audio
If you only want to use a piece of an audio track, then you have the capability to trim it down. This video shows you how.
PowerPoint 2016 – 2.4.8 – Insert Audio
This video brings you through the steps required, to insert an Audio track into a Presentation.
PowerPoint 2016 – 2.4.7 – Insert a Video from YouTube
This video shows you the steps to insert a video from YouTube. But just because you can, it doesn’t mean you should! This video will also explain why it’s not always a good idea.
PowerPoint 2016 – 2.4.6 – Set a Poster Frame on a Video
Rather than starting with a black screen on the video, we can set an image to be the Poster Frame, the starting image. This video shows you how to do just that.
PowerPoint 2016 – 2.4.5 – Play a Video Full Screen
Rather than having the video sitting very obviously on the slide – we’re going to set it up, so that the video takes up the full screen, when we go into Slide Show view.
PowerPoint 2016 – 2.4.4 – Start Video Automatically
When you go into Slide Show view, you might prefer the video to start playing automatically. This video shows you how.
PowerPoint 2016 – 2.4.3 – Fade Video Sound
When a video is trimmed, you’ll find that the sound cuts in very sharply. Fading in and out the sound, will take care of that problem.
PowerPoint 2016 – 2.4.2 – Trim a Video
If a video is too long, it can be trimmed down here, directly in PowerPoint. This video brings you through those steps.
PowerPoint 2016 – 2.4.1 – Insert a Video from File
Learn how to connect to a video that is stored on your computer.
PowerPoint 2016 – 2.6.7 – Remove a Logo from the Title Slide
This video shows you how we can treat one Slide Layout differently from the others, by working on the specific Master, belonging to that slide.
PowerPoint 2016 – 2.6.6 – Add a Logo to the Slide Master
If you want to add your company logo to all the slides in your presentation, then you should do so, on the Slide Master.
PowerPoint 2016 – 2.6.5 – Adjusting Bullets on the Title Slide Master
In this video we’re going into the Slide Master to change the bullet style and colour, and also the colour of the text. This change will then be reflected on all slides that have a bullet section.
PowerPoint 2016 – 2.6.4 – Change the Title Master Only
Learn how to make changes to an individual Slide Layout using the Master that is specific to that layout.
PowerPoint 2016 – 2.6.3 – Change the Main Slide Master
We’re going to make a change to the overarching Master and see that change flow through to all the Slide Layouts, on the front end of PowerPoint.
PowerPoint 2016 – 2.6.2 – View the Slide Master
Find out how to access the Slide Master – which is a group of slides that act as the template behind PowerPoint.
PowerPoint 2016 – 2.6.1 – View and Understand Themes
Themes help control the look and feel of a PowerPoint presentation. In this video we’re going to view some of the Themes that are provided by Microsoft.
PowerPoint 2016 – 2.5.10 – Use the Animation Painter
If you want to apply the same Animations to multiple objects, then you can use the Animation Painter to do so.
PowerPoint 2016 – 2.5.9 – View Special Effects for Charts
There are extra effects available specifically for charts – but be aware you can only access them with some, but not all, of the Entrance Effects.
PowerPoint 2016 – 2.5.8 – View Special Effects for Bullets
Bullets have extra effects attached to them. Learn what those effects are.
PowerPoint 2016 – 2.5.7 – Change the Order of Animations
Sometimes we need to change the order that our Animations take place in. This video shows you how.
PowerPoint 2016 – 2.5.6 – Use Multiple Animation Effects
If you want to have an Entrance effect, an Emphasis effect AND an Exit effect, then this video shows you how.
PowerPoint 2016 – 2.5.5 – Remove an Animation
The type of Animation you have used, determines how you remove it. See how it’s done.
PowerPoint 2016 – 2.5.4 – Understand the Motion Paths Effects
Motion Path effects deal with the way an object moves around the screen. Never seen a penguin fly? Keep watching!
PowerPoint 2016 – 2.5.3 – Understand the Exit Effects
Exit effects deal with the way that an object leaves the screen. Let’s take a look at some of those effects.
Download the supporting documents we use in our videos: