Excel 2016 Level 1

If you’re in the position that you regularly have to print out information from a file for others and each time you do you have to carry out certain tasks, such as hiding some columns or rows, then this feature is definitely for you!

Back in Lesson 2 you learned how to create Comments or Notes; however, they don’t print automatically. This video shows you how to make them print.

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.