Certificate In Excel 2016 Expert Online Course

Learn to create, manage, and distribute professional spreadsheets

Certificate In Excel 2016 Expert Online Course

NOW ONLY

RM799

Save RM300 (27%)
OFF RRP RM1099
Get Info Pack

Learn to create, manage, and distribute professional spreadsheets

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:

  • Save a workbook as a template, with colors, fonts, cell styles and themes
  • Reference data using structured references or data in another workbook
  • Protect a workbook from further editing
  • Prepare a workbook for internationalization
  • Apply custom data formats and validation
  • Apply advanced conditional formatting and filtering
  • Use form controls
  • Work with macros

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: Manage Workbook Options and Settings

  • Manage Workbooks
  • Save a Workbook as a Template
  • Reference Data in Another Workbook
  • Reference Data by Using Structured References
  • Display Hidden Ribbon Tabs
  • Manage Workbook Review
  • Mark a Workbook as Final
  • Protect a Workbook with a Password
  • Protect a Worksheet to Restrict Editing
  • Protect Workbook Structure
  • Manage Workbook Versions
  • Setting Calculation Options

Module Three: Apply Custom Data Formats and Layouts

  • Prepare a Workbook for Internationalization
  • Apply International Currency Formats
  • Apply Locale to Date or Time Formats
  • Apply Custom Data Formats and Validation
  • Create Custom Number Formats
  • Populate Cells by Using Advanced Fill Series Options
  • Configure Data Validation
  • Apply Advanced Conditional Formatting and Filtering
  • Create Custom Conditional Formatting Rules
  • Create Conditional Formatting Rules that Use Formulas
  • Manage Conditional Formatting Rules
  • Create and Modify Custom Workbook Elements
  • Create Custom Color Formats
  • Create Custom Font Sets
  • Create and Modify Cell Styles
  • Create and Modify Custom Themes
  • Manage Multiple Options for Theme Fonts
  • Insert and Configure Form Controls
  • Work with Macros
  • Enable Macros
  • Record a Macro
  • Run a Macro
  • Edit a Macro
  • Copy Macros from One Workbook to Another

Module Four: Create Advanced Formulas

  • Define Named Ranges and Objects
  • Name Cells
  • Use Named Cells in a Formula
  • Manage Named Ranges and Objects
  • Apply Functions in Formulas
  • Perform the AND Function and the OR Function
  • Perform NOT Function
  • Perform Logical Operations by Using Nested Functions
  • Perform SUMIFS, AVERAGEIFS, and COUNTIFS Functions
  • Look Up Data by Using Functions
  • Look Up Data by Using the VLOOKUP Function
  • Look Up Data by Using the HLOOKUP Function
  • Look Up Data by using the MATCH Function
  • Look Up Data by Using the INDEX Function
  • Apply Advanced Time and Date Functions
  • Serialize Numbers by Using Date and Time Functions
  • Reference the Date and Time Using the NOW and TODAY functions
  • Perform Data Analysis and Business Intelligence
  • Import, Transform, Combine, Display, and Connect to Data
  • Consolidate Data
  • Perform What-If Analysis by Using Goal Seek
  • Perform What-If Analysis by Using Scenario Manager
  • Troubleshoot Formulas
  • Trace Precedence and Dependence
  • Monitor Cells and Formulas using the Watch Window
  • Validate Formulas by Using Error Checking Rules
  • Evaluate Formulas

Module Five: Create Advanced Charts and Tables

  • Create Advanced Charts
  • Add Trendlines to Charts
  • Create Dual-Axis Charts
  • Save a Chart as a Template
  • Create and Manage PivotTables
  • Create Slicers
  • Create PivotTables
  • Modify Field Selections and Options
  • Group PivotTable Data
  • Reference Data in a PivotTable by Using the GETPIVOTDATA Function
  • Add Calculated Fields
  • Format Data
  • Create and Manage PivotCharts
  • Create PivotCharts
  • Drill Down into PivotChart Details
  • Apply Styles to PivotCharts
  • Manipulate Options in Existing PivotCharts

Module Six: Wrapping Up

  • Words from the Wise

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 create, manage, and distribute professional spreadsheets

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:

  • Save a workbook as a template, with colors, fonts, cell styles and themes
  • Reference data using structured references or data in another workbook
  • Protect a workbook from further editing
  • Prepare a workbook for internationalization
  • Apply custom data formats and validation
  • Apply advanced conditional formatting and filtering
  • Use form controls
  • Work with macros

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: Manage Workbook Options and Settings

  • Manage Workbooks
  • Save a Workbook as a Template
  • Reference Data in Another Workbook
  • Reference Data by Using Structured References
  • Display Hidden Ribbon Tabs
  • Manage Workbook Review
  • Mark a Workbook as Final
  • Protect a Workbook with a Password
  • Protect a Worksheet to Restrict Editing
  • Protect Workbook Structure
  • Manage Workbook Versions
  • Setting Calculation Options

Module Three: Apply Custom Data Formats and Layouts

  • Prepare a Workbook for Internationalization
  • Apply International Currency Formats
  • Apply Locale to Date or Time Formats
  • Apply Custom Data Formats and Validation
  • Create Custom Number Formats
  • Populate Cells by Using Advanced Fill Series Options
  • Configure Data Validation
  • Apply Advanced Conditional Formatting and Filtering
  • Create Custom Conditional Formatting Rules
  • Create Conditional Formatting Rules that Use Formulas
  • Manage Conditional Formatting Rules
  • Create and Modify Custom Workbook Elements
  • Create Custom Color Formats
  • Create Custom Font Sets
  • Create and Modify Cell Styles
  • Create and Modify Custom Themes
  • Manage Multiple Options for Theme Fonts
  • Insert and Configure Form Controls
  • Work with Macros
  • Enable Macros
  • Record a Macro
  • Run a Macro
  • Edit a Macro
  • Copy Macros from One Workbook to Another

Module Four: Create Advanced Formulas

  • Define Named Ranges and Objects
  • Name Cells
  • Use Named Cells in a Formula
  • Manage Named Ranges and Objects
  • Apply Functions in Formulas
  • Perform the AND Function and the OR Function
  • Perform NOT Function
  • Perform Logical Operations by Using Nested Functions
  • Perform SUMIFS, AVERAGEIFS, and COUNTIFS Functions
  • Look Up Data by Using Functions
  • Look Up Data by Using the VLOOKUP Function
  • Look Up Data by Using the HLOOKUP Function
  • Look Up Data by using the MATCH Function
  • Look Up Data by Using the INDEX Function
  • Apply Advanced Time and Date Functions
  • Serialize Numbers by Using Date and Time Functions
  • Reference the Date and Time Using the NOW and TODAY functions
  • Perform Data Analysis and Business Intelligence
  • Import, Transform, Combine, Display, and Connect to Data
  • Consolidate Data
  • Perform What-If Analysis by Using Goal Seek
  • Perform What-If Analysis by Using Scenario Manager
  • Troubleshoot Formulas
  • Trace Precedence and Dependence
  • Monitor Cells and Formulas using the Watch Window
  • Validate Formulas by Using Error Checking Rules
  • Evaluate Formulas

Module Five: Create Advanced Charts and Tables

  • Create Advanced Charts
  • Add Trendlines to Charts
  • Create Dual-Axis Charts
  • Save a Chart as a Template
  • Create and Manage PivotTables
  • Create Slicers
  • Create PivotTables
  • Modify Field Selections and Options
  • Group PivotTable Data
  • Reference Data in a PivotTable by Using the GETPIVOTDATA Function
  • Add Calculated Fields
  • Format Data
  • Create and Manage PivotCharts
  • Create PivotCharts
  • Drill Down into PivotChart Details
  • Apply Styles to PivotCharts
  • Manipulate Options in Existing PivotCharts

Module Six: Wrapping Up

  • Words from the Wise

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 RM799 Save RM300 (27%)
OFF RRP RM1099
Delivery Method Online
Get Info Pack

Special Offer

 

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

 

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.: 020E2016OC
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