Excel 2016 Essentials
Excel 2016 can help you to improve your Core Data Analysis, Manipulation, and Presentation skills by learning the core skills needed to succeed with Microsoft Excel 2016.
You will gain an advanced level of understanding for the Microsoft Excel 2016 environment, and the ability to guide others to the proper use of the program’s full features – critical skills for those in roles such as accountants, financial analysts, and commercial bankers.
Create and Manage Worksheets and Workbooks
Worksheets live in workbooks in Excel 2016 and create the building blocks of documenting, analyzing, manipulating, and presenting data. This module will help you get started by creating worksheets and workbooks. You’ll also learn how to navigate your way around Excel worksheets and workbooks. We’ll take a look at formatting both worksheets and workbooks. Then you’ll learn how to customize your options and views while working within Excel 2016. Finally, we’ll take a look at distributing your worksheets and workbooks via printing or sharing.
Manage Data Cells and Ranges
This module introduces you to the tools you need to insert, format, summarize and organize your data.
Create Tables
Tables help you sort, filter, and summarize data. Tables data is managed independently from data in the other rows and columns on the worksheet. In this module, you’ll learn to create and manage tables, apply styles and configure table style options, and work with filtering and sorting strategies.
Perform Operations with Formulas and Functions
The power of Excel 2016 lies in its ability to make calculations that help you analyze data. This module explains how to build the formulas and use the functions that can help you make your calculations. You’ll learn about formulas, basic functions, conditional functions and using functions to format and modify text in Excel 2016.
Use Quick Analysis, Charts and Objects
Quick Analysis includes a number of formatting, charts, and totals shortcuts to help you visualize your data. Recommended Charts are another way of quickly visualizing your information. This module looks at these shortcuts, as well as creating and formatting your own charts and using and formatting other types of objects.
Course Objectives:
- Create worksheets and workbooks
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Change views and configurations
- Print and distribute worksheets and workbooks
- Manage data cells and ranges
- Create tables, charts and objects
- Perform operations with formulas and functions
After mastering Excel 2016 Essentials, check out Excel 2016 Expert to get full potential of Excel 2016.
Reviews
There are no reviews yet.