Excel 2016 – 1.3.7 – Understand Calculation Mode
Watch this video and discover what it is meant by Calculation Mode – and get a better understanding of how Excel works when calculating values.
Excel 2016 – 1.3.6 – Calculate a % Of
Ever wondered how to calculate a percentage value of a number? Here we explain how – using Division, Number Formatting and Rounding – you can calculate a % value.
Excel 2016 – 1.3.5 – Division Using a Formula
In this video we demonstrate how to carry out a Division in Excel by setting up a simple formula.
Excel 2016 – 1.3.4 – Multiplication Using a Formula
Discover how – using the * symbol – you can carry out a Multiplication of values in your Excel Spreadsheet.
Excel 2016 – 1.3.3 – Subtraction Using a Formula
Watch this short video and learn how to carry out a Subtraction operation on our values using a basic formula.
Excel 2016 – 1.3.2 – Addition Using a Formula
This video shows you how to carry out a basic Addition using a formula.
Excel 2016 – 1.3.1 – Signs Used for Calculation
In this video we look at the different signs (or mathematical operators) that we will be using to help carry out our basic calculations.
Excel 2016 – 1.2.11 – Using Find & Replace
Just about ready to present your data but discover you’ve made a typo, or a name has changed? This video shows you how to Find and Replace multiple occurrences of an item in Excel.
Excel 2016 – 1.2.10 – Using Help
Where has Help gone? This video shows you the new way to access Help.
Excel 2016 – 1.2.9 – Issues With Deleting
Deleting in Excel is not as straightforward as it might appear! By using the ‘Clear’ set of commands, find out how you can remove data or remove cell formats from an Excel Spreadsheet.
Excel 2016 – 1.2.8 – Using Undo and Redo
Don’t panic! Use the ‘Undo’ button to go back a step (or a few steps) if you’ve made a mistake or would like to take different options. Gone back too far? Use ‘Redo’ to step forward and return to where you want to be.
Excel 2016 – 1.2.7 – Basic Alignment Features
Watch this video and learn how to apply the different features contained in the Alignment group.
Excel 2016 – 1.2.6 – Basic Font and Cell Formatting
Take a moment to view this video as we demonstrate how to apply the formatting features in the Font group – and how to remove them again.
Excel 2016 – 1.2.5 – Basic Keyboard Selection Techniques
Discover in this video some quick and easy ways to select specific Excel data using your Keyboard.
Excel 2016 – 1.2.4 – Basic Keyboard Navigation Techniques
When working with Excel it is extremely useful to know how to use the Keyboard to move around, as well as the Mouse. This video will get you started with some of the most commonly used navigation features.
Excel 2016 – 1.2.3 – Customise the Ribbon
Do you find yourself continuously searching through the Ribbon Tabs to find commands that you use regularly? Discover in this video how to create your own Tab and Ribbon content.
Excel 2016 – 1.2.2 – Customise the Quick Access Toolbar
The Quick Access Toolbar (or QAT) is a customisable toolbar that provides access to a set of commands that you frequently use. Find out here how to place commands on the QAT.
Excel 2016 – 1.4.6 – How To Use The COUNTA Function
In this video you will discover how to use the COUNTA Function to count both numbers and text in cells – but not blank cells! You will also learn how to use the Insert Function command (or fx) to apply Excel Functions.
Excel 2016 – 1.4.5 – How To Use The COUNT (Numbers) Function
Watch this short video to learn how to correctly use the COUNT Function when applied to a set of numbers.
Excel 2016 – 1.4.4 – How To Use The MIN Function
Do you need to find the lowest value in a column? Learn how to use the MIN Function and to effectively select the correct data range.
Excel 2016 – 1.4.3 – How To Use The MAX Function
Ever wondered how to find the maximum value in a column? Here we show you how to use the MAX Function and how to effectively select the correct data range.
Excel 2016 – 1.4.2 – How To Use The AVERAGE Function
In this video you will learn how to apply the AVERAGE Function and effectively select the correct data range.
Excel 2016 – 1.4.1 – How To Use The AutoSum Function
The AutoSum feature enables the fast application of the ‘Addition Function’. Rather than adding each individual entry in your spreadsheet, AutoSum facilitates ‘summing’ a large range of data with two mouse clicks.
Excel 2016 – 1.2.1 – Open an Existing Workbook & Move Between Two Workbooks
In this session we show the different ways to open Workbooks. Learn also, when you have two or more open, how easy it is to move from one to the other.
Excel 2016 – 1.1.7 – Create, Save, Close and Re-open a Workbook
Learn how to create your own folder and save your Workbook into it. Then see different ways of opening that Workbook.
Excel 2016 – 1.1.6 – Close a Workbook But Not Excel
If you have a single Workbook open and then use the X in the top right hand corner to close that book, you’ll find that Excel itself also closes. This video shows you how to avoid that scenario.
Excel 2016 – 1.1.5 – Adjust Column and Row Widths
Look at different ways to size our columns and rows, including auto-sizing. Also see how to deal with the ‘#hash sign issue’.
Excel 2016 – 1.1.4 – Enter a Table of Data
When it comes to typing up a table of data, there is a special relationship between the Enter and Tab keys, that will help speed up the process.
Excel 2016 – 1.1.3 – Basics of Entering Data
This video shows you some of the different ways that you can accept data entry into cells. Yes, there are different ways this can be done!
Excel 2016 – 1.1.2 – The Excel Screen
View the screen and learn the names of the different parts.
Excel 2013 – 1.11.5 – Printing Selected Cells
So the boss only wants a certain range from your Excel data to be printed? Discover the steps to print Selected Cells in this short video.
Excel 2013 – 1.11.4 – Check Spelling
Just about ready to present your data? It’s worth your while carrying out a Spell Check. Take a moment to watch this video and learn how.
Excel 2013 – 1.11.3 – Insert and Delete Page Breaks
Ever wondered how to manage the way your Excel data prints over a number of Pages? In this video we show you how the Page Break Preview feature helps you to do just that.
Excel 2013 – 1.11.2 – Print Titles Across Pages
Got a large amount of data to print? Discover in this video how to ensure that the column headings on the first page will also appear on all subsequent pages to be printed.
Excel 2013 – 1.10.7 – Specific Formats for Pie Charts
So you’ve created a Pie Chart and now wish to work on its presentation? Take a look at this video as we demonstrate how to focus on a particular slice of the Pie and how to explode the Pie for visual effect.
Excel 2013 – 1.10.6 – Create a Pie Chart
Pie Charts – a simple visual method to display information. Watch this video to learn how to create Pie Charts. We also show you how to vary the data being displayed on a Pie Chart.
Excel 2013 – 1.10.5 – The Special Printing Feature of Charts
Learn how – by simply selecting it – you can print a Chart independently of the source data.
Excel 2013 – 1.10.4 – Format a Chart Using the Chart Tabs
An alternative to using commands contained in the Design Tab is to use the Chart Tabs that appear on the Right Hand Side of a selected Chart. Of particular value here is the Chart Filters Tab.
Excel 2013 – 1.10.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 2013 – 1.10.2 – Format a Chart Using the Design Tab
Once your chart is created and you then select it – or click on it – three contextual Tabs are enabled on the Ribbon. In this video we demonstrate how – using the Design Tab – you can change the type, style and appearance of your Chart.
Excel 2013 – 1.9.4 – Scale Multiple Pages of Data to Fit Onto 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 2013 – 1.9.3 – Show the Same Worksheet on the Screen Twice
An alternative to applying a Split Screen is to display your worksheet twice – or side by side – on the same screen. Watch this video and find out how.
Excel 2013 – 1.9.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 2013 – 1.9.1 – Freeze Panes
Learn in this video how to effectively use the Freeze Panes feature to view information in a large list of data.
Excel 2013 – 1.11.1 – Using Find & Replace
Just about ready to present your data but discover you’ve made a typo, or a name has changed? Learn in this video how to Find and Replace multiple occurrences of text in Excel.
Excel 2013 – 1.10.1 – Create a Column Chart
So now you have your figures together, it may be useful to present this information in Chart format? First learn some basic steps to correctly select your data and then discover different techniques to quickly create a Column or Comparison Chart.
Excel 2013 – 1.8.7 – Conditional Formatting Using Dates
Here’s another useful feature associated with Conditional Formatting. Learn in this video how to highlight a date – or range of dates – that satisfy certain criteria based on today’s date.
Excel 2013 – 1.8.6 – Conditional Formatting Using Text
Have you ever needed to highlight particular cells in which the Text – or Labels – are the same? Watch this video and learn how to set this up.
Excel 2013 – 1.8.5 – Conditional Formatting to Show Top 40%
Take a look at this video and learn how to apply formats to cell values that fall with a certain range – such as the Top 40% of values.
Download the supporting documents we use in our videos: