Excel 2013 – 1.7.4 – Format as Time
If you need to perform Time calculations in Excel your data must be formatted appropriately. Here we show various time formats that will facilitate future calculations.
Excel 2013 – 1.7.3 – Format as Dates
In this video we demonstrate how Excel works with Date information. You will also learn how to change the standard Date style to a different format.
Excel 2013 – 1.7.2 – Format Figures as Percentages
Take a look at this video and learn how to convert figures into percentages. You will also discover how Excel rounds percentage figures up or down – and how you can reformat percentage values to show more or less decimal places.
Excel 2013 – 1.7.1 – Format Figures as Currency
Ever wondered how to quickly apply currency formats to figures in your Excel Worksheet or Table? Take a look at this video and discover different methods to apply currency formats as well as different presentation styles.
Excel 2013 – 1.6.7 – Insert Headers & Footers
Watch this video to learn how – using the Page Layout feature – you can place information at the top and bottom of your printed sheets. We also show you how to select and set page numbers.
Excel 2013 – 1.6.6 – Adjust Page Margins
Want to create more professional printouts of your Excel data? In this video we show you how to set and change the page margins.
Excel 2013 – 1.6.5 – Change the Page Orientation
Using Print Preview check how many pages your data will be printed on and discover how to change the printed page orientation from Portrait to Landscape.
Excel 2013 – 1.6.4 – Hiding and Unhiding Rows, Columns and Sheets
Got a large amount of information in your Excel worksheet but don’t wish to view or print everything? Watch this video and find out how to Hide Columns, Rows and Sheets – and how to Unhide them afterwards.
Excel – 1.6.3 – Moving and Copying Sheets Within a Workbook
Have you ever needed to change the position of a Worksheet or make a copy of an existing Worksheet in your Workbook? In this video you will learn how to move or copy Worksheets using different techniques.
Excel 2013 – 1.6.2 – Insert, Rename and Delete Sheets
Learn how to quickly insert a new Worksheet into your Excel Workbook. Also discover how you can rename Worksheets and remove them from your Workbook if necessary.
Excel 2013 – 1.6.1 – Inserting and Deleting Columns and Rows
Working with existing data in Excel? Discover efficient ways of inserting additional Columns and Rows and learn which formats will be adopted by your data. Find out also how to quickly delete Columns and Rows.
Excel 2013 – 1.5.8 – Using the Fill Handle
Watch this video and discover how you can use the Fill Handle to quickly copy and apply a calculation down a column of data.
Excel 2013 – 1.5.7 – Paste Values
When Copying and Pasting numbers that have been calculated you will lose the original values – all due to Relative Referencing (take a look at Lesson 4). Here we show you how to use the Paste Values feature to retain those original figures.
Excel 2013 – 1.5.6 – Transpose
Here’s a scenario. You have a table in Excel but wish to turn the Column headings into Row headings or vice versa? Watch this video and learn how to use the Transpose feature in conjunction with the Copy and Paste commands.
Excel 2013 – 1.5.5 – Paste Column Widths
Ever been frustrated by having to resize every Column in a Table you’ve copied from one Worksheet to another? In this short video we’ll show you a very useful tip on how to quickly resize the Column Widths to match the original Table.
Excel 2013 – 1.5.4 – Different Ways to Copy and Paste
In this video we demonstrate 3 different methods which you can use to copy data in your Worksheet.
Excel 2013 – 1.5.3 – Different Ways to Cut and Paste
Want to move information around your Sheet? There are several different ways to Cut and Paste data in Excel. Watch this video to discover which technique suits you.
Excel 2013 – 1.5.2 – Series Fill using Numbers and Dates
In this video we show you some useful tips to help you create an increasing sequence of Numbers or Dates. We also demonstrate how the SmartTag feature can be used to change a sequence of Days to Weeks, Months or Years.
Excel 2013 – 1.5.1 – Create a Series Fill using Text
In this video you will learn how the Fill Handle can be used to create a series of Labels such as Months of the year or Days of the week. You will also learn how to copy a cell format across a number of adjacent cells.
Excel 2013 – 1.4.8 – Convert Blank Cells to Text
Careful now! The logical approach to converting Numbers to Text might be to simply format the selected range of Numbers as Text. However this will not work. Formatting as Text only works when you format a range of Blank Cells as Text and then enter Numbers in these Cells afterwards.
Excel 2013 – 1.4.7 – Convert Multiple Numbers to Text
In the previous videos in this Lesson we’ve looked at what can go wrong when Excel treats Text as Numbers – and we’ve seen how to spot these issues and resolve them. What happens if you wish to convert a list of Numbers to Text that are not developed sequentially? Watch this video and learn […]
Excel 2013 – 1.4.6 – Explanation of Number Conversion
In this short video we show you how Excel treats Numbers (or Values) differently to Text (or Labels). We also demonstrate how to spot these differences in a Worksheet.
Excel 2013 – 1.4.5 – Convert Single Numbers to Text
Occasionally data presented in Excel is poorly designed and structured. Bad design can lead to serious errors when performing calculations. In this video we demonstrate a typical result of bad design – where Text is mistaken for number Values – and how to correct it.
Excel 2013 – 1.4.4 – Understand Absolute Calculation
Need to calculate figures based on set values such as Income Tax, Value Added Tax, Sales Commissions, Exchange Rates etc? Learn how to set up an Absolute Calculation – and use the F4 key – to quickly create and apply your formula.
Excel 2013 – 1.4.3 – When NOT to use Relative Calculation
Discover when using the Fill Handle and Relative Calculations how Excel can produce the wrong results.
Excel 2013 – 1.4.2 – Relative Calculation Problem
In this video you will discover how Relative References can produce the wrong information in Excel. But you will also learn how to anticipate and correct calculation problems caused by Relative References.
Excel 2013 – 1.4.1 – How Relative Calculations Work
The concept of Relative References when performing Excel calculations can be a bit confusing. In this video we explain what Relative Referencing means and provide a simple guide to Relative Calculations in Excel.
Excel 2013 – 1.3.8 – Calculating Functions by Row
Have you ever needed to use the AutoSum, AVERAGE, COUNT, MAX or MIN Functions across a Row of data – instead of on a Column? Learn how to effectively select the correct data range to apply these functions to.
Excel 2013 – 1.3.7 – How to use the COUNTBLANK Function
Have you ever wondered how to find the amount of blank cells that are contained in your data? In this short video we show you how to apply the COUNTBLANK Function to return the number of blank cells in a selection.
Excel 2013 – 1.3.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 2013 – 1.3.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 2013 – 1.3.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 2013 – 1.3.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 2013 – 1.3.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 2013 – 1.3.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 2013 – 1.2.8 – Calculate the % Difference Between Two Values
Watch this short video and learn how to calculate the percentage difference between two values, e.g., the difference in sales between two years.
Excel 2013 – 1.2.7 – Understand the Order of Operations
Have you found that Excel sometimes produces a different answer than what you would expect? Find out how Excel orders calculations and discover what the acronym BOMDAS means.
Excel 2013 – 1.2.6 – 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 2013 – 1.2.5 – 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 2013 – 1.2.4 – Division using a Formula
In this video we demonstrate how to divide in Excel by setting up a simple formula.
Excel 2013 – 1.2.3 – Multiplication using a Formula
Discover how – using the * symbol – you can multiply values in your Excel Spreadsheet.
Excel 2013 – 1.2.2 – Subtraction using a Formula
Watch this short video and learn how to subtract values using a basic subtraction formula.
Excel 2013 – 1.2.1 – Addition using a Formula
In this video we show you how to create a simple formula to perform an Addition.
Excel 2013 – 1.1.10 – Using Help
Watch this video and discover how specific you need to be when searching for information using the Microsoft Help feature. Or …. why not search through your video library on the Knowledge Market site? Simply type your topic into the ‘COURSE OR SUBJECT SEARCH’ box below this video.
Excel 2013 – 1.1.9 – Saving a Workbook
Now that you have begun working with Excel, watch this video to learn how to Save your information. Discover also how to create a Folder in a particular location on your computer.
Excel 2013 – 1.1.8 – Issues with Deleting Content and Formats
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 2013 – 1.1.7 – 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 2013 – 1.1.6 – Basic Keyboard Selection Techniques
Discover in this video some quick and easy ways to select specific Excel data using your Keyboard.
Excel 2013 – 1.1.5 – Basic Keyboard Navigation Techniques
In this video we show you some basic keyboard navigation techniques in Microsoft Excel. You will also learn how to quickly move from Worksheet to Worksheet.
Excel 2013 – 1.1.4 – Basic Entering and Editing of Data
Take a look at this video and learn how – by using the Enter and Tab keys on the keyboard – you can efficiently enter information in Excel.
Download the supporting documents we use in our videos: