Description

In this Introduction to Microsoft Excel 2016 training course, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

This Intermediate Microsoft Excel 2016 training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations. Learners will also work with charts and advanced formatting including styles.

Audience profile

This course is intended for students who have little or no familiarity with Microsoft Excel 2016 or more experienced Excel users who want to learn the topics covered in this course in the 2016 interface.

At course completion

After completing this course, students will be able to:

• Create basic worksheets using Microsoft Excel 2016.
• Perform calculations in an Excel worksheet.
• Modify an Excel worksheet.
• Modify the appearance of data within a worksheet.
• Manage Excel workbooks.
• Print the content of an Excel worksheet.
• Learn how to use handy features new in 2016.

Prerequisites

• Experience installing PC hardware and devices.
• Basic understanding of TCP/IP and networking concepts.
• Basic Windows and Active Directory knowledge.
• The skills to map network file shares.
• Experience working from a command prompt.
• Basic knowledge of the fundamentals of applications. For example, how client computer applications communicate with the server.
• Basic understanding of security concepts such as authentication and authorization.
• An understanding of the fundamental principles of using printers.