Excel 2016 Level 1

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 and most importantly, how to Unhide them afterwards.

Learn different ways of quickly moving or copying sheets, from one Workbook to another.

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.

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.

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.

Fill Handling – without the Fill Handle! Wait until you see this feature!

Watch this video and discover how you can use the Fill Handle to quickly copy and apply a calculation down a column of data.

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 5). Here we show you how to use the Paste Values feature to retain those original figures.

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.

In this video we demonstrate 3 different methods which you can use to copy data in your Worksheet.

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.

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.

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.

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 […]

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.

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.

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.

Discover when using the Fill Handle and Relative Calculations how Excel can produce the wrong results.

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.

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.

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.