Excel 2016 Intermediate

When it comes to creating visual representations of data, Excel is the universal favorite among professionals. This intermediate course is ideal for those with a rudimentary knowledge of Excel 2016, who are looking to expand their skill set and become more familiar with the program.

Self-Paced

Learning Style

Intermediate

Difficulty

3 Hours

Course Duration

Course Info

Download PDF

Certificate

See Sample

About Individual Course:
  • Individual course plan gives you access to this course
On Sale!
Now Only $10.00 Regular Price $29.00
Now Only $10.00 Regular Price $29.00
/ Each
When you subscribe, you get:
Learn Subscription plan gives you access to this course and over 833 other popular courses
On Sale!
Now Only $39.99 Regular Price $44.99
Now Only $39.99 Regular Price $44.99
/ Month
Team
Pricing
  • Buy 5-9 Enrollments And Save 68% ($12.74 monthly.)
  • Buy 10-19 Enrollments And Save 72% ($11.24 monthly.)
  • Buy 20-above Enrollments And Save 78% ($8.99 monthly.)
When it comes to creating visual representations of data, Excel is the universal favorite among professionals. This intermediate course is ideal for those with a rudimentary knowledge of Excel 2016, who are looking to expand their skill set and become more familiar with the program.

Course Information

About this course:

This course is intended help you advance you your features of Excel 2016. Cultivate a better understanding of formulas, conditional formatting, sorting data, filtering duplicates and much more. A basic knowledge of Excel 2016 is recommended before beginning this course. Microsoft Excel is the standard spreadsheet application for both personal and business use, so staying on top of the latest version is very important for anyone considering career advancement. Regardless of your level of understanding, you will benefit from this Microsoft Excel 2016 training course because it covers basic, intermediate and advanced competency levels. Our Microsoft Excel 2016 training course will help arm you with the knowledge to use it more effectively whether you are using it at home or in the workplace. Understand how to manipulate data within a spreadsheet, validate and present information using the built in structure and functions of Microsoft Excel.

Course Objective:

After completing this course, students will have a working understanding of:

  • Flash Fill
  • List Design & Single Level Sorting
  • Multi-Level Sorting
  • Custom Sorting
  • Filtering
  • Multi-Level Filtering
  • Table Style Options
  • Remove Duplicates
  • Convert to Range
  • Subtotal
  • Multi-Level Subtotaling
  • Remove Subtotals
  • Quick Analysis Charts
  • Inserting Data Charts

Audience: 

This course is intended for:

  • Anyone who is looking to gain understanding of Excel 2016 features and capabilities from a business productivity / analysis standpoint, such as charts, pivot tables, data linking etc.

Prerequisites:

  • There are no prerequisites for this online course, but it will be helpful if the learners gain basic overview of Excel 2016 as a baseline. 

Suggested prerequisites courses:

Outline

More Information

More Information
Brand Microsoft
Subjects Business Productivity
Lab Access No
Technology Microsoft
Learning Style Self-Paced Learning
Difficulty Intermediate
Course Duration 3 Hours
Language English
VPA Discount VPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Course Prerequisites
Sale
Microsoft Office Excel 2016- Level 2(091056) (Excel2016L2)
Microsoft Office Excel 2016- Level 2(091056) (Excel2016L2)
300%
  • Virtual Classroom
  • 1 Day
Now Only $695.00 Regular Price $995.00

Contact A Learning Consultant


click here