Course Prerequisites

This manual assumes the user has completed or has an understanding of the materials covered in the first part of the Microsoft Office Excel 2016 courseware, including:

• Using absolute, relative, and mixed references
• Using formulas and functions in a worksheet
• Managing and organizing worksheets
• Editing and formatting Excel data
• Printing and saving Excel files
• Customizing the Excel interface

Course Overview

Welcome to the second part of our Microsoft Office Excel 2016 courseware. This version of Excel incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible.

This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.

Course Objectives

By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, inserting graphics, and enhancing workbooks.

How To Use This Book

This course is broken up into seven lessons. Each lesson focuses on several key topics, each of which are broken down into easy-to-follow concepts. At the end of each topic, you will be given an activity to complete. At the end of each lesson, we will summarize what has been covered and provide a few review questions for you to answer. Supplemental learning for selected topics is provided in the form of Lesson Labs at the end of this book.

Before you begin, download the course’s Exercise Files to a convenient location. They will be referenced throughout this course and are a key part of your learning experience.