Edumall Preloader

Excel 2016 Essentials

Excel 2016 Essentials

mindmerge_PNGs HiRes-46
MM Certified Instructor
Last Update May 29, 2024
2 already enrolled

About This Course

Participants will gain an advanced level of understanding for the Microsoft Excel 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.

Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity.  Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.

Learning 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

Target Audience

  • All Employees

Curriculum

16h

Create and Manage Worksheets and Workbooks

Modify Worksheets

Add a Tool to the Quick Access Toolbar

Print

Manage Data Cells and Ranges

Format Cells and Ranges

Summarize and Organize Data

Create Tables

Manage Table Styles and Options

Filter Records

Perform Operations with Formulas and Functions

Perform Conditional Functions

Use Quick Analysis, Charts and Objects

Create Charts

Free
Level
Beginner
Duration 16 hours
Subject
Language
Arabic English
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare