Excel 2016 Level 1

Excel 2016 – 1.12.6 – Create Custom Views

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!

DETAIL

Excel 2016 – 1.7.11 – Group Worksheets

This feature is one of those ‘must haves’. It allows you to carry out multiple actions, to multiple sheets, at the same time.

DETAIL

Excel 2016 – 1.12.5 – Print Comments or Notes

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.

DETAIL

Excel 2016 -1.13.6 – Delete a Style

We’ve created a Style that, I’m sure, you don’t want to keep. So now we’ll look at how to remove a Style, completely.

DETAIL

Excel 2016 – 1.13.5 – Return to the Normal Style

This shows you how to return all your data back to the Normal Style.

DETAIL

Excel 2016 – 1.13.4 – Copy a Style to Another Workbook

When you create your own Style, or edit an existing Style, that change takes place within the current Workbook only. This video shows you how to copy those changes to other Workbooks.

DETAIL

Excel 2016 – 1.13.3 – Create a Style by Example

Do you want to create your own Styles rather than use the built-in Styles? No problem, this video shows you how.

DETAIL

Excel 2016 – 1.13.2 – Edit a Style

This shows you how to edit a default Style and how that change automatically updates on all pages in the Workbook, that are using that Style.

DETAIL

Excel 2016 – 1.13.1 – Apply Cell Styles

This shows you how to apply the pre-made default Styles contained in Excel.

DETAIL

Excel 2016 – 1.2.12 – Create Comments or Notes

You can add comments to cells to help users to work with your data. Depending on the version of Excel that you are using, you might see the choice as Comments – or Notes – or both.

DETAIL

Excel 2016 – 1.8.13 – Custom Date Formatting

Dates are formatted separately to figures and text and this video will show you how to apply custom formatting to dates so that you can display them in the way that you want to see them.

DETAIL

Excel 2016 – 1.8.12 – Custom Format Example

This video shows a practical use of a custom format to display both text and a figure in the same cell. Why is this different to just typing our text directly into the cell? Well, done this way, the cell will remain calculable.

DETAIL

Excel 2016 – 1.8.11 – Create Custom Formats

Now we’re going to create and apply the custom formats that we saw in the last video.

DETAIL

Excel 2016 – 1.8.10 – About Custom Formatting

This video explains what custom formatting is, and that it can be applied to positive figures, negative figures, zero values and text – all at the same time.

DETAIL

Excel 2016 – 1.12.4 – Print a Selection

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.

DETAIL

Excel 2016 – 1.12.3 – Use Spell Check

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.

DETAIL

Excel 2016 – 1.12.2 – 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.

DETAIL

Excel 2016 – 1.12.1 – 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.

DETAIL

Excel 2016 – 1.11.7 – Specific Formats For Pie Charts

In this video as we demonstrate different ways to present a Pie Chart. For example, how to focus on a particular slice of the Pie, or how to explode the Pie for visual effect.

DETAIL

Excel 2016 – 1.11.6 – Create a Pie Chart

Pie Charts provide us with a simple, visual method to display information. In this video we show you how to create Pie Charts. We also show you how to change the data being displayed on a Pie Chart.

DETAIL

Excel 2016 – 1.11.5 – The Special Printing Feature Of Charts

So you’ve now created your Chart and need to print it. Here we demonstrate the different options available when printing charted data.

DETAIL

Excel 2016 – 1.11.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.

DETAIL

Excel 2016 – 1.11.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.

DETAIL

Excel 2016 – 1.11.2 – Format a Chart Using The Design Tab

Once your chart is created you can then select it – or click on it. This enables three contextual Tabs on the Ribbon. In this topic we demonstrate how – using the Design Tab – you can change the type, style and appearance of your Chart.

DETAIL

Excel 2016 – 1.11.1 – Create a Column Chart

So now you have your figures together, it may be useful to present this information in Chart format? Watch this video and learn some basic steps to correctly select your data. Also discover different techniques to quickly create a Column or Comparison Chart.

DETAIL

Excel 2016 – 1.10.4 – Scale Multiple Pages To Fit On 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.

DETAIL

Excel 2016 – 1.10.3 – Display Two Copies Of The Same Workbook

An alternative to applying a Split Screen is to display your worksheet twice – or side by side – on the same screen. Learn the steps here.

DETAIL

Excel 2016 – 1.10.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.

DETAIL

Excel 2016 – 1.10.1 – Freeze Panes

Scrolling down or across a large list of data can be frustrating when we lose sight of our Column and Row Headings. Watch this video and learn how the Free Panes feature allows us to ‘lock’ Column or Row Headings as we

DETAIL

Excel 2016 – 1.9.7 – CF With 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.

DETAIL

Excel 2016 – 1.9.6 – CF With 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.

DETAIL

Excel 2016 – 1.9.5 – Show Top 10%

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

DETAIL

Excel 2016 – 1.9.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.

DETAIL

Excel 2016 – 1.9.3 – 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.

DETAIL

Excel 2016 – 1.9.2 – Using Color Scales

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

DETAIL

Excel 2016 – 1.9.1 – 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.

DETAIL

Excel 2016 – 1.8.9 – 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.

DETAIL

Excel 2016 – 1.8.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.

DETAIL

Excel 2016 – 1.8.7 – Remove Formatting

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

DETAIL

Excel 2016 – 1.8.6 – Add Background and Font Colouring

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

DETAIL

Excel 2016 – 1.8.5 – Add Borders To Excel Data

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.

DETAIL

Excel 2016 – 1.8.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.

DETAIL

Excel 2016 – 1.8.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.

DETAIL

Excel 2016 – 1.8.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.

DETAIL

Excel 2016 – 1.8.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.

DETAIL

Excel 2016 – 1.7.10 – 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.

DETAIL

Excel 2016 – 1.7.9 – Change 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.

DETAIL

Excel 2016 – 1.7.8 – 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.

DETAIL

Excel 2016 – 1.7.7 – Hide/Unhide Sheets

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.

DETAIL

Excel 2016 – 1.7.6 – Hide/Unhide Rows

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.

DETAIL

Knowledge Market in Your Business

Knowledge Market is a great source for online video tutorials. We have developed a range of topics based on the applications that you use every day.
So whether you wish to refresh your existing knowledge - or you want to learn something new - we've got everything you need when you need it and where you need it.

Membership

Our Membership options have been developed to suit your specific needs. Contact us today to find out how we can be part of your office support infrastructure.

CONTACT

Email: kelly@knowledgemarket.ie

Performance Support and Learning for:
Microsoft Office – Excel, PowerPoint, Project, Word

Privacy & Cookies

This website uses Cookies. Continued use of the site will be deemed as your acceptance of this necessity.

Please read our Privacy Policy