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.
Download the supporting documents we use in our videos: