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.
Excel 2016 – 1.12.4 – Print a Selection
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 2016 – 1.12.3 – Use Spell Check
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 2016 – 1.12.2 – 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 2016 – 1.12.1 – 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 2016 – 1.11.7 – Specific Formats For Pie Charts
In this video as we demonstrate different ways to present a Pie Chart. For example, how to focus on a particular slice of the Pie, or how to explode the Pie for visual effect.
Excel 2016 – 1.11.6 – Create a Pie Chart
Pie Charts provide us with a simple, visual method to display information. In this video we show you how to create Pie Charts. We also show you how to change the data being displayed on a Pie Chart.
Excel 2016 – 1.11.5 – The Special Printing Feature Of Charts
So you’ve now created your Chart and need to print it. Here we demonstrate the different options available when printing charted data.
Excel 2016 – 1.11.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 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.
Excel 2016 – 1.9.7 – CF With 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 2016 – 1.9.6 – CF With 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 2016 – 1.9.5 – Show Top 10%
Learn how to apply formats to cell values that fall with a certain range – such as the Top 10% of values.
Excel 2016 – 1.9.4 – Create Multiple Conditions
Have you ever needed to highlight data that meets more than one condition? We show you here the steps to take to create up to 64 conditions upon which you can apply a format.
Excel 2016 – 1.9.3 – Using Icon Sets
In this video we take you through the steps to graphically display and distinguish your numerical data with icons. We also demonstrate how you can specify the values which trigger a particular icon.
Excel 2016 – 1.9.2 – Using Color Scales
This short video takes you through the steps needed to apply gradient colour scales to a list of values.
Download the supporting documents we use in our videos: