Excel 2016 – 2.8.2 – Create a Subtotal
Learn how to use this very simple ‘must have’ feature – you’ll wonder how you ever did without it.
Excel 2016 – 2.8.1 – Why Use The Subtotal Feature?
This video will demonstrate why everyone should know how to use the Subtotals feature.
Excel 2016 – 2.7.4 – Filter and Copy Data To Another Worksheet
In this video learn the work-around that allows you to Copy and Paste the unique items from a column, into a different sheet, as part of the Advanced Filter.
Excel 2016 – 2.7.3 – Show Unique Items From a Column
In this video learn how to use the Advanced Filter feature to obtain a list of each unique item contained in a column.
Excel 2016 – 2.7.2 – Create An Advanced Filter
When you use a normal Filter, you learn how to set multiple criteria and by default they AND each other. In this video learn how to use the Advanced Filter feature to set two sets of criteria which OR each other.
Excel 2016 – 2.7.1 – Why Use An Advanced Filter?
In this video see an example of why you might need to use an Advanced Filter, when a normal Filter is unable to give us the result we are looking for.
Excel 2016 – 2.6.7 – Calculating With a Filter
Did you know that there are Functions in Excel that do not understand Filters? Learn what Functions they are and how they should be calculated. Also discover that if you carry out a Filter on data that already has Hidden Rows in it, this also causes a problem with those Functions.
Excel 2016 – 2.6.6 – Create Date Filters
In this video learn how to use some of the pre-defined Date Filtering features, as well as how to use the custom Date Filters.
Excel 2016 – 2.6.5 – Create a Top 10 Filter
In this video use the Top 10 Filter feature to find the top five most expensive cars, then change over to find the bottom five cheapest cars.
Excel 2016 – 2.6.4 – Create a Price Range Filter
In this video see how to Filter for all cars that fall within a specific price range.
Excel 2016 – 2.6.3 – Apply a Filter Using Multiple Criteria
In this video, learn how to Filter using more than one column. Also see how to quickly clear down a multi-filter, without having to clear each one individually.
Excel 2016 – 2.6.2 – Create a Quick Filter Using the Right Click
Another way to carry out a basic Filter, this time showing how you can use the right-click not only to carry out a Filter, but to actually turn the Filter feature on, at the same time.
Excel 2016 – 2.6.1 – Create a Basic Filter
This video shows you how to turn on the Filter feature, carry out a single Filter, clear the Filter down, then turn the Filter feature back off again.
Excel 2016 – 2.5.6 – Sort by Row
Excel likes its data laid out in Columns, with Column headings. But what do you do if you have to lay it out in Rows, with Row headings? Excel doesn’t make it easy for you! Watch this video to see how it is done.
Excel 2016 – 2.5.5 – Create a Custom Sort
You know how to Sort A to Z or Z to A. But what if you want to Sort using your own Custom Sort Order? Well this video will show you how.
Excel 2016 – 2.5.4 – Sort by Colour
Sunglasses at the ready? Here’s a different approach to sorting. You may have used a Fill or Font colour to highlight certain information in your data. You can now sort that data by colour.
Excel 2016 – 2.5.3 – Create a Multi-level Sort
In this video learn how to carry out a Sort by two columns, then change to Sorting by four columns, then remove two columns from the sort.
Excel 2016 – 2.5.2 – Create a Single Sort
In this video learn how to create a Single Column Sort using two methods – the right-click and the Ribbon.
Excel 2016 – 2.5.1 – How to Structure Your Data
Important information here! Watch this video and learn how to setup and structure data to get the best from Excel.
Excel 2016 – 2.4.8 – Mixed Reference Absolutes in a SUMIFS Function
In this video we show you how – using mixed references to cells – you can perform multiple criteria and range calculations to create a Table or Matrix of new data.
Excel 2016 – 2.4.7 – Use the COUNTIFS Function
In this short video we take you through the steps to create a logical COUNT Function that uses Multiple Criteria and Ranges.
Excel 2016 – 2.4.6 – Use the AVERAGEIFS Function
The AVERAGEIFS Function has a similar structure to the SUMIFS Function – but returns the Average of a selected range based on certain criteria.
Excel 2016 – 2.4.5 – Use the SUMIFS Function
So you’re familiar with the SUMIF Function? Add an ‘S’ to the end and you can now sum a range of values based on Multiple Ranges and Multiple Criteria. Watch this video and we’ll show you how.
Excel 2016 – 2.4.4 – Use the COUNTIF Function
This is a very useful Excel Function, designed to return the number of times a specific value or criteria occurs. Watch this video and learn how to apply the COUNTIF Function.
Excel 2016 – 2.4.3 – Use the AVERAGEIF Function
The AVERAGEIF is very similar in structure to the SUMIF Function. In this short video we show you how to create it.
Excel 2016 – 2.4.2 – How SUMIF Works
We provide here an explanation of how the SUMIF function does it’s job – and how to specify the three Arguments for this function
Excel 2016 – 2.4.1 – Use the SUMIF Function
Ever wondered how to add up a variety of values if they meet certain criteria? Watch this video and learn how to set up the SUMIF Function.
Excel 2016 – 2.3.8 – Explanation of IF Within IF
Some useful stuff here. In this video we deconstruct a Nested IF Function to show you how it all works. We also give you some useful tips to help you build a Nested IF Function.
Excel 2016 – 2.3.7 – Using IF with Nested IF
Taking it that bit further! If you need to apply multiple logical tests and will have multiple values returned if true, then nesting an IF Function within an IF Function allows you to delve deeper into your data.
Excel 2016 – 2.3.6 – Using IF with Nested OR
Watch this video and discover that the steps you take to Nest an OR Function within the IF Function are the same as those to Nest an AND Function. However the results generated will be different. Learn why here.
Excel 2016 – 2.3.5 – Using IF with Nested AND
Learn how to increase the power of the IF Function by combining it with the AND and the OR Functions. This feature is called nesting.
Excel 2016 – 2.3.4 – Using the AND Function
The AND Function is generally placed or ‘Nested’ inside the IF Function. In this video we demonstrate how the AND Function works.
Excel 2016 – 2.3.3 – Using the IF Function with Text
In this video we show you how to return some text based on a logical test using the IF Function. The key point when you wish to return some text is to surround it with double quotes, i.e., ” “.
Excel 2016 – 2.3.2 – Using the IF Function
Take a look at this video as we take you through the steps to create an IF Function. You will also learn how to check the result of an IF Function to ensure that the logical test is producing the right answer.
Excel 2016 – 2.3.1 – About IF
What a powerful device the IF Function is. But first things first. Take a few moments to watch this video as we demonstrate how the IF Function operates and how it depends on logic.
Excel 2016 – 2.2.4 – Edit/Delete Names
In this video you will learn how to change the Name of an existing Range of values. We also show you how to delete a Named Range – and the consequences of this action if the Named Range has been referred to in a calculation.
Excel 2016 – 2.2.3 – Auto-create Named Ranges
In this video we give you a really useful tip. We not only show you how to Name a Range of values but you will also learn how to Name multiple Ranges at the same time.
Excel 2016 – 2.2.2 – Name a Single Cell
Down to business! In this short video we show you how to Name a Cell. We also demonstrate how to refer to that Name in a calculation on a different Worksheet.
Excel 2016 – 2.2.1 – About Naming
A quick introduction here to the concept of Naming Cells. Also we take you through the 5 rules associated with Cell Names.
Excel 2016 – 2.1.9 – Nest VAT in the ROUND Function
Watch this video and learn how to set up – or nest – a calculation in the ROUND Function.
Excel 2016 – 2.1.8 – Visual Rounding Causing Incorrect Results
Decision time! In this video we demonstrate the subtle difference between Visual Rounding and Calculated Rounding using the ROUND Function.
Excel 2016 – 2.1.7 – Link a Constant VAT Value Across Sheets
Here’s a practical application of calculating across Worksheets using a formula. In this video you will learn how to reference a Value Added Tax (VAT) Rate across several Worksheets.
Excel 2016 – 2.1.6 – Calculate Across Workbooks Using a Function
On occasion you may need to create a calculation – such as Addition or Subtraction – across Excel Workbooks or Files. Discover here how to apply a formula across several Worksheets and return the answer in a different Workbook.
Excel 2016 – 2.1.5 – Calculate Across Workbooks Using a Formula
On occasion you may need to create a calculation – such as Addition or Subtraction – across Excel Workbooks or Files. Discover here how to apply a formula across several Worksheets and return the answer in a different Workbook.
Excel 2016 – 2.1.4 – Calculate Across Worksheets Using a Function
Take a moment to view this video and learn how to apply a Function – such as the AutoSum Function – across several Worksheets.
Excel 2016 – 2.1.3 – Calculate Across Worksheets Using a Formula
In this video we take you through the steps you can follow to add a number of values across several Worksheets in your Workbook. Use the same steps for any formula such as subtract, multiply or divide.
Excel 2016 – 2.1.2 – Link to Another Workbook
In this video we show you how to link information from one Excel file (or Workbook) to another.
Excel 2016 – 2.1.1 – Link to Another Worksheet
Have you ever needed to ‘pull information from’ or ‘link information across’ your Worksheets? Watch this video and discover how.
Download the supporting documents we use in our videos: