Certificate In Excel 2016 Essentials Online Course

Learn to Gain an advanced level of understanding for the Microsoft Excel environment

Certificate In Excel 2016 Essentials Online Course

NOW ONLY

US$199

Save US$70 (26%)
OFF RRP US$269
Get Info Pack

Learn to Gain an advanced level of understanding for the Microsoft Excel environment

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. You 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. 

By the end of this Course, you will be able to:

  • 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

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Module One: Getting Started

  • Course Objectives

Module Two: Create and Manage Worksheets and Workbooks

  • Create Worksheets and Workbooks
  • Create a Workbook
  • Open a Comma Separated Values File
  • Add a Worksheet to An Existing Workbook
  • Navigate in Workbooks and Worksheets
  • Search for Data
  • Navigate to a Named Cell
  • Insert and Remove Hyperlinks
  • Hide or Unhide Columns and Rows
  • Hide or Unhide Sheets
  • Modify Worksheets
  • Insert and Delete Table Rows and Columns
  • Adjust Row Height and Column Width
  • Insert Headers and Footers
  • Change Worksheet Tab Color
  • Rename Worksheet
  • Format Workbooks
  • Copy and Move Worksheets
  • Modify Page Setup
  • Change Workbook Themes
  • Customize Options and Views for Worksheets and Workbooks
  • Add a Tool to the Quick Access Toolbar
  • Zoom
  • Change Workbook Views
  • Change Window Views
  • Modify Document Properties
  • Show or Hide Formulas
  • Configure Worksheets and Workbooks for Distribution
  • Print
  • Set a Print Area
  • Save in Another File Format
  • Repeat Columns or Rows Across Multiple Pages
  • Inspect a Workbook for Hidden Properties and Personal Information
  • Inspect a Workbook for Accessibility Issues
  • Inspect a Workbook for Compatibility Issues

Module Three: Manage Data Cells and Ranges

  • Insert Data in Cells and Ranges
  • Replace Data
  • Cut, Copy and Paste Data
  • Paste Data Using Paste Options
  • Fill Cells using Autofill
  • Insert and Delete Cells
  • Format Cells and Ranges
  • Merge Cells
  • Align and Indent Cell Contents
  • Wrap Text Within Cells
  • Apply Number Formats
  • Apply Cell Formats
  • Apply Cell Styles
  • Apply Conditional Formatting
  • Format Cells using the Format Painter
  • Summarize and Organize Data
  • Insert Sparklines
  • Grouping Data
  • Adding Subtotals
  • Outline Data
  • Viewing Grouped and Outlined Data

Module Four: Create Tables

  • Create and Manage Tables
  • Create an Excel Table from a Cell Range
  • Add or Remove Table Rows and Columns
  • Convert a Table to a Cell Range
  • Manage Table Styles and Options
  • Apply Styles to Tables
  • Configure Table Style Options
  • Insert Total Rows
  • Filter and Sort a Table
  • Filter Records
  • Clear Filters
  • Use a Number Filter or Text Filter
  • Change Sort Order
  • Sort Data by Multiple Columns
  • Remove Duplicate Records

Module Five: Perform Operations with Formulas and Functions

  • Building Formulas
  • Understand Math Basics of Excel
  • Build a Formula
  • Edit a Formula
  • Copy a Formula
  • Understand Relative vs. Absolute References
  • Perform Basic Functions
  • Understand Formulas vs. Functions
  • Calculate Using Status Bar
  • Perform Basic Functions
  • AutoComplete a Function
  • Create Functions using Formulas Tab
  • Perform Conditional Functions
  • Perform the IF Function
  • Perform the SUMIF Function
  • Perform the AVERAGEIF Function
  • Perform the COUNTIF Function
  • Format and Modify Text Using Functions
  • Format Text Using UPPER, LOWER, and PROPER Functions
  • Format Text Using the CONCAT Function
  • Format Text Using LEFT, RIGHT and MID Functions

Module Six: Use Quick Analysis, Charts and Objects

  • Analyze Data with Quick Analysis
  • Format with Quick Analysis
  • Create Charts with Quick Analysis
  • Calculate Totals with Quick Analysis
  • Create Charts
  • Use Recommended Charts
  • Create a New Chart
  • Add Additional Data Series
  • Switch Between Rows and Columns in Source Data
  • Format Charts
  • Resize Charts
  • Add and Modify Chart Elements
  • Apply Chart Styles and Layouts
  • Move Charts to a Chart Sheet
  • Add Data to Chart on a Chart Sheet
  • Insert and Format Objects
  • Insert Shapes
  • Insert Text Boxes
  • Format Shapes and Text Boxes
  • Insert Pictures
  • Add Alternative Text

Module Seven: Wrapping Up

  • Words from the Wise
  • Completion of Action Plans and Evaluations

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

About this Course

Learn to Gain an advanced level of understanding for the Microsoft Excel environment

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. You 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. 

By the end of this Course, you will be able to:

  • 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

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Module One: Getting Started

  • Course Objectives

Module Two: Create and Manage Worksheets and Workbooks

  • Create Worksheets and Workbooks
  • Create a Workbook
  • Open a Comma Separated Values File
  • Add a Worksheet to An Existing Workbook
  • Navigate in Workbooks and Worksheets
  • Search for Data
  • Navigate to a Named Cell
  • Insert and Remove Hyperlinks
  • Hide or Unhide Columns and Rows
  • Hide or Unhide Sheets
  • Modify Worksheets
  • Insert and Delete Table Rows and Columns
  • Adjust Row Height and Column Width
  • Insert Headers and Footers
  • Change Worksheet Tab Color
  • Rename Worksheet
  • Format Workbooks
  • Copy and Move Worksheets
  • Modify Page Setup
  • Change Workbook Themes
  • Customize Options and Views for Worksheets and Workbooks
  • Add a Tool to the Quick Access Toolbar
  • Zoom
  • Change Workbook Views
  • Change Window Views
  • Modify Document Properties
  • Show or Hide Formulas
  • Configure Worksheets and Workbooks for Distribution
  • Print
  • Set a Print Area
  • Save in Another File Format
  • Repeat Columns or Rows Across Multiple Pages
  • Inspect a Workbook for Hidden Properties and Personal Information
  • Inspect a Workbook for Accessibility Issues
  • Inspect a Workbook for Compatibility Issues

Module Three: Manage Data Cells and Ranges

  • Insert Data in Cells and Ranges
  • Replace Data
  • Cut, Copy and Paste Data
  • Paste Data Using Paste Options
  • Fill Cells using Autofill
  • Insert and Delete Cells
  • Format Cells and Ranges
  • Merge Cells
  • Align and Indent Cell Contents
  • Wrap Text Within Cells
  • Apply Number Formats
  • Apply Cell Formats
  • Apply Cell Styles
  • Apply Conditional Formatting
  • Format Cells using the Format Painter
  • Summarize and Organize Data
  • Insert Sparklines
  • Grouping Data
  • Adding Subtotals
  • Outline Data
  • Viewing Grouped and Outlined Data

Module Four: Create Tables

  • Create and Manage Tables
  • Create an Excel Table from a Cell Range
  • Add or Remove Table Rows and Columns
  • Convert a Table to a Cell Range
  • Manage Table Styles and Options
  • Apply Styles to Tables
  • Configure Table Style Options
  • Insert Total Rows
  • Filter and Sort a Table
  • Filter Records
  • Clear Filters
  • Use a Number Filter or Text Filter
  • Change Sort Order
  • Sort Data by Multiple Columns
  • Remove Duplicate Records

Module Five: Perform Operations with Formulas and Functions

  • Building Formulas
  • Understand Math Basics of Excel
  • Build a Formula
  • Edit a Formula
  • Copy a Formula
  • Understand Relative vs. Absolute References
  • Perform Basic Functions
  • Understand Formulas vs. Functions
  • Calculate Using Status Bar
  • Perform Basic Functions
  • AutoComplete a Function
  • Create Functions using Formulas Tab
  • Perform Conditional Functions
  • Perform the IF Function
  • Perform the SUMIF Function
  • Perform the AVERAGEIF Function
  • Perform the COUNTIF Function
  • Format and Modify Text Using Functions
  • Format Text Using UPPER, LOWER, and PROPER Functions
  • Format Text Using the CONCAT Function
  • Format Text Using LEFT, RIGHT and MID Functions

Module Six: Use Quick Analysis, Charts and Objects

  • Analyze Data with Quick Analysis
  • Format with Quick Analysis
  • Create Charts with Quick Analysis
  • Calculate Totals with Quick Analysis
  • Create Charts
  • Use Recommended Charts
  • Create a New Chart
  • Add Additional Data Series
  • Switch Between Rows and Columns in Source Data
  • Format Charts
  • Resize Charts
  • Add and Modify Chart Elements
  • Apply Chart Styles and Layouts
  • Move Charts to a Chart Sheet
  • Add Data to Chart on a Chart Sheet
  • Insert and Format Objects
  • Insert Shapes
  • Insert Text Boxes
  • Format Shapes and Text Boxes
  • Insert Pictures
  • Add Alternative Text

Module Seven: Wrapping Up

  • Words from the Wise
  • Completion of Action Plans and Evaluations

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

Adobe Acrobat Reader

We provide a 7 Day Money Back Refund on all Courses

Now Only US$199 Save US$70 (26%)
OFF RRP US$269
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value $600)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 020E2016EOC
Delivery Mode: Online
Course Access: Lifetime Course Access
Time required: Study at your own pace
Course Duration: 6-8 Hours
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner