2016

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.

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.

Learn how to apply formats to cell values that fall with a certain range – such as the Top 10% of values.

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.

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.

This short video takes you through the steps needed to apply gradient colour scales to a list of values.

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.

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.

Now that you’ve applied some formats to your Excel data – how do you remove them? Watch this short video and learn how.

To make your data that bit more presentable, there are a number of simple formatting options you can use. Learn those options here.

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.

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.

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.

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.

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.

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.

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.

If you need to Hide a Worksheet, then this video will show you how. But more importantly, it will also show you how to Unhide the Worksheet.

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

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.