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.
Excel 2013 – 1.8.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 2013 – 1.8.3 – Conditional Formatting 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 2013 – 1.8.2 – Conditional Formatting using Color Scales
This short video takes you through the steps needed to apply gradient colour scales to a list of values.
Excel 2013 – 1.8.1 – Conditional Formatting using Data Bars
Ever wondered how to graphically display and distinguish your data – particularly numbers? In this video we introduce you to the world of Conditional Formatting.
Excel 2013 – 1.7.9 – Using Wrap Text and Line Breaks
A very useful tip here. In this video we show you how to Wrap Text in a cell but … we also show you how you can control the number of lines your text appears on by using Line Breaks.
Excel 2013 – 1.7.8 – Using Merge & Center
Watch this video and learn how to present headings for your data using the Merge and Center feature. We also demonstrate how this feature can go wrong.
Excel 2013 – 1.7.7 – Remove Borders, Shading and Font Colour
Now that you’ve applied some formats to your Excel data – how do you remove them? Watch this short video and learn how.
Excel 2013 – 1.7.6 – Format Background and Font
To make your data that bit more presentable, there are a number of simple formatting options you can use. Learn those options here.
Excel 2013 – 1.7.5 – Add Borders
Adding Borders around and within the contents of an Excel Table can be a useful way to provide focus to your data. Watch this video and you will learn some simple methods to apply Borders.
Download the supporting documents we use in our videos: