Excel 2016 – 3.13.12 – Use Solver and Reports
This video shows you how to use Solver and how to create the different reports that it makes available.
Excel 2016 – 3.13.11 – Add Solver to Excel
Solver is NOT part of the default set-up of Excel, which means we need to add it in. This video shows you how.
Excel 2016 – 3.13.10 – About Solver
There are few things you need to be aware of, to use Solver. This video explains them.
Excel 2016 – 3.13.9 – Goal Seek
A lovely simple little feature, that is always handy to know.
Excel 2016 – 3.13.8 – Create a Summary Report
This video shows you the print out that you can get, or Summary Report, from the Scenario Manager.
Excel 2016 – 3.13.7 – Named Cells with Scenarios
This video shows you how to use Named Cells with your Scenarios, which means they are much easier to read and makes for a better print out.
Excel 2016 – 3.13.6 – The Scenario Manager
This video shows the Scenario Manager and how it’s commonly used.
Excel 2016 – 3.13.5 – Two-input Data Table
This video shows how to use two inputs into a Data Table.
Excel 2016 – 3.13.4 – Start-up Data Table
We are still looking at a One-input Data Table but this time we’re looking at a Start-up company. We want to show the Revenue, Profit and Variable Costs associated with differing sales amounts.
Excel 2016 – 3.13.3 – Data Table with Multiple Formulas
This video is still showing a One-input Data Table, but with multiple formulas which produces multiple results.
Excel 2016 – 3.13.2 – Create a One-input Data Table
This video brings you through the steps required to create a One-input Data Table.
Excel 2016 – 3.13.1 – About Data Tables
This video explains what a One-input Data Table and a Two-input Data Table are. It also shows the results after the Data Table feature has been applied.
Excel 2016 – 1.7.11 – Group Worksheets
This feature is one of those ‘must haves’. It allows you to carry out multiple actions, to multiple sheets, at the same time.
Excel 2016 – 1.12.5 – Print Comments or Notes
Back in Lesson 2 you learned how to create Comments or Notes; however, they don’t print automatically. This video shows you how to make them print.
Excel 2016 -1.13.6 – Delete a Style
We’ve created a Style that, I’m sure, you don’t want to keep. So now we’ll look at how to remove a Style, completely.
Excel 2016 – 1.13.5 – Return to the Normal Style
This shows you how to return all your data back to the Normal Style.
Excel 2016 – 1.13.4 – Copy a Style to Another Workbook
When you create your own Style, or edit an existing Style, that change takes place within the current Workbook only. This video shows you how to copy those changes to other Workbooks.
Excel 2016 – 1.13.3 – Create a Style by Example
Do you want to create your own Styles rather than use the built-in Styles? No problem, this video shows you how.
Excel 2016 – 1.13.2 – Edit a Style
This shows you how to edit a default Style and how that change automatically updates on all pages in the Workbook, that are using that Style.
Excel 2016 – 1.13.1 – Apply Cell Styles
This shows you how to apply the pre-made default Styles contained in Excel.
Excel 2016 – 1.2.12 – Create Comments or Notes
You can add comments to cells to help users to work with your data. Depending on the version of Excel that you are using, you might see the choice as Comments – or Notes – or both.
Excel 2016 – 1.8.13 – Custom Date Formatting
Dates are formatted separately to figures and text and this video will show you how to apply custom formatting to dates so that you can display them in the way that you want to see them.
Excel 2016 – 1.8.12 – Custom Format Example
This video shows a practical use of a custom format to display both text and a figure in the same cell. Why is this different to just typing our text directly into the cell? Well, done this way, the cell will remain calculable.
Excel 2016 – 1.8.11 – Create Custom Formats
Now we’re going to create and apply the custom formats that we saw in the last video.
Excel 2016 – 1.8.10 – About Custom Formatting
This video explains what custom formatting is, and that it can be applied to positive figures, negative figures, zero values and text – all at the same time.
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.8.4 – Create a Custom Show
You can create one overall presentation, then use subsets of that presentation, to create a Custom Show. Basically, it’s multiple presentations, in one presentation.
PowerPoint 2016 – 2.8.3 – Keyboard Shortcuts in Slide Show View
If you’re not connected to a projector or TV screen when you give the presentation, then you will go into Slide Show view. This video shows you some handy keyboard shortcuts that you can use.
PowerPoint 2016 – 2.8.2 – Presenter View
If your laptop is connected to a Projector or a TV screen, then you, the Presenter, will actually go into Presenter view, not Slide Show view. This video shows you what that looks like and explains the features available.
PowerPoint 2016 – 2.8.1 – Exclude Slides from a Slide Show
When giving the same presentation over and over, you will often find you want to leave some slides out of a given presentation. This video shows you how to hide, and unhide, slides.
PowerPoint 2016 – 2.7.8 – Make an Action Button Invisible
Sometimes, when I use an Action Button I like to make it invisible so that the audience doesn’t know that it is there. This video shows you how to do that.
PowerPoint 2016 – 2.7.7 – Use an Action Button
Using an Action Button to link to another Presentation, gives you the ability to select the specific slide that you would like to land on, rather than defaulting to landing on the first slide.
PowerPoint 2016 – 2.7.6 – Hyperlink to Another Presentation
If you want to link out to another presentation, from within the presentation you are giving, then this video shows you how.
PowerPoint 2016 – 2.7.5 – Hyperlink to a Website
If, as part of your presentation, you need to link out to a website, this video will show you how.
PowerPoint 2016 – 2.7.4 – Hyperlink to a PDF
You can create links in your presentation to a document that you want viewers to see. We’re linking to a PDF file, but the same steps are used to link to any document.
PowerPoint 2016 – 2.7.3 – Features of Sections
This video shows how you can use Sections – and even move slides, using them. It’s a great feature.
PowerPoint 2016 – 2.7.2 – Create and Name Sections
Creating Sections is a great way to divide up a presentation, particularly if it’s a large one.
PowerPoint 2016 – 2.7.1 – Copy Sildes from Another Presentation
There is an easy way to bring in copies of slides from another presentation to your current presentation – and it’s not Copy & Paste!
PowerPoint 2016 – 2.6.12 – Insert a Second Slide Master
You can actually have multiple Slide Masters, each with it’s own look and feel, behind a single presentation, in PowerPoint. This video shows you how.
PowerPoint 2016 – 2.6.11 – Create Your Own Template
If you find you always have specific slides in every presentation, containing specific text or images, then why not have those slides pre-created and saved as a Template. That way, when you open the Template, you don’t have to create those slides.
PowerPoint 2016 – 2.6.10 – Create Your Own Slide Layout
If you’ve been wondering how to go about creating your own Slide Layout, that will be available in the New Slide button, then wonder no more!
PowerPoint 2016 – 2.6.9 – Save Another Theme to Your Computer
If you’d like to save the Theme that your Company uses, to your computer, so that you can apply it to new, or existing presentations, then this video shows you how.
PowerPoint 2016 – 2.6.8 – Create Your Own Theme
We’re going to create our own rather distinctive Theme! When you create a Theme it can be applied to all future presentations.
PowerPoint 2016 – 2.4.11 – Play Audio Across Slides
So far, when we move to a new slide, the Audio automatically stops playing. If you would prefer that it kept on playing throughout the Presentation, then this video will show you how.
Download the supporting documents we use in our videos: