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