589544

Microsoft Excel 2016 Level 1 Bundle

R450.00 Ex.VAT 15%

29751 ,

Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This new version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins.

This course is intended to help all novice computer users get up to speed with Excel quickly. We will cover different features of the interface, show users how to print, cover some simple scenarios, and cover the basics of formatting.

Available!

Excel 2016 Level 1: Getting Started with Microsoft Excel 2016

Microsoft Office Excel is a powerful and easy-to-use spreadsheet application. Nearly everyone who works with numbers has likely used Excel or some other spreadsheet application (such as Lotus 1-2-3) in one form or another. If you are new to Excel and spreadsheets in general, the vast array of features and controls can seem quite daunting. However, once we cover the workings of a spreadsheet and how to deal with the basics, you will be well on your way to becoming an expert in Excel!

Excel 2016 Level 1: Performing Calculations

One of the most powerful features in Excel is the ability to perform real-time calculations on data within workbooks. Using these powerful features allows you to save time and reduce errors when trying to calculate complex and simple equations.

Excel 2016 Level 1: Modifying a Worksheet

One of most basic and common tasks that you will complete using Excel is modifying the contents of your worksheets. This topic covers various tools that you can use to work with the data in your worksheets in the most efficient ways possible.

Excel 2016 Level 1: Formatting a Worksheet

Excel contains many of the text formatting tools that you might be familiar with from other Microsoft Office applications, like Word or PowerPoint. In this topic, we will learn about a variety of different font options, as well as how to use the Format Painter, the mini toolbar, and more.

Excel 2016 Level 1: Printing Workbook Contents

It is often the case that printouts of your workbook (or parts of your workbook) will be required for one purpose or another. This is especially true for the workplace, where hard copies of data are often requested. Needless to say, knowing how to print data from your workbook is essential. In this topic, we will explore how to use the printing functionality in Excel.

Excel 2016 Level 1: Managing Large Workbooks

Large workbooks have unique challenges; in particular, navigation can be an especially difficult task. To help with this problem, you can format worksheet tabs to give them individual names and appearances. In this topic, we will learn all of the ways that you can format worksheet tabs. We will also learn how to manage worksheets and view worksheets and workbooks in different ways.

Excel 2016 Level 1: Customizing the Excel Environment

In this lesson, you will begin examining how to customize Microsoft Excel 2016 to suit your specific needs. This topic will teach you how to choose and apply various language options, as well as set some more general options.
Return to Store

Getting Started with Microsoft Excel 2016

In this module, students will learn how to identify the elements of the Excel interface, create a basic worksheet, and use the help system.

Performing Calculations

This module covers how to create formulas in a worksheet, insert functions in a worksheet, and reuse formulas.

Modifying a Worksheet

Next, students will learn how to manipulate data, as well as how to insert, manipulate, and delete cells, columns, and rows. Searching for and replacing data and how to spell check a worksheet are also discussed.

Formatting a Worksheet

This lesson covers how to modify fonts, add borders and colors to cells, apply number formats, align cell contents, and apply cell styles.

Printing Workbook Contents

In this module, students will learn how to define the basic page layout for a workbook, refine the page layout, and apply print options.

 

Managing Large Workbooks

This module will teach students how to format worksheet tabs, manage worksheets, and manage the view of worksheets and workbooks.

 

Customizing the Excel Environment

In this final module, students will learn how to customize general, language, formula, proofing, and saving options. It also covers how to use Excel’s version control features, customize the ribbon and the Quick Access toolbar, enable add-ins, and customize advanced and Trust Center options.

 

Not found