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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Ever wondered how to graphically display and distinguish your data – particularly numbers? In this video we introduce you to the world of Conditional Formatting.
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.
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.
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.
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.
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.
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.
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.