Skip to content
Write a review
UdemyExcelPaid courseIntermediate levelCertificate

Excel 2016 Intermediate (Udemy.com)

Expand your Excel abilities with charts, outlines, workbooks and much more.

4.6
238 reviews

Created by: Intellezy Trainers

Last updated April 2018

icon
What you will learn

  • Custom Excel
  • Link Workbooks and Worksheets
  • Work with Range Names
  • Analyze Data with Common Logical Functions
  • Analyze Data with Common Lookup Functions
  • Sort and Filter Range Data
  • Analyze and Organize with Tables
  • Use Conditional Formatting
  • Outline with Subtotals and Grouping
  • Display Data Graphically
  • Understand PivotTables and PivotCharts and Filter with Slicers
  • Work with Flash Fill
  • Work with Date and Time Functions
  • Work with Common Text Functions

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.6 out of 5higher than 63% of them
  • Reviews238#286 of 356 by number of reviews
  • Length4 hoursshorter than 64% of them
  • Last updatedApril 2018earlier than 83% of them

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

icon
Course Description

This course is designed to be the intermediate level of Excel 2016. Students will learn how to link workbooks and worksheets, create named ranges and utilize them in formulas, build Logical functions such as IF, AND, and OR, and use Lookup functions to locate and compare data. Students will also be introduced to and work with Excel's Table feature, learning to create and modify Tables. Students will also create and modify PivotTables and PivotCharts to analyze large data sets, sort the data, and use Slicers and Timeline Slicers to filter the data. Additionally, students will create and modify Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.

This IAAP-certified counts for 4.0 recertification points for the CAP certification under the Technology and Information Distribution content area.

Email info@intellezy.com with proof of completion of the course to obtain your certificate.

Who this course is for:
  • Students who want to take their Excel knowledge to the next level.
Read More Intermediate Intermediate Level product length iconTime: 4h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

placeholder

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today's rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.

Read More

icon
More courses by Intellezy Trainers

$13.99

Original price $69.9980% off

$14.99

Original price $79.9981% off

$15.99

Original price $99.9984% off

$11.99

Original price $39.9970% off

$11.99

Original price $69.9983% off

$14.99

Original price $64.9977% off
All courses by Intellezy Trainers

icon
Reviews

4.6

238 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By K Lakshminarayan Shenoy

Explained the intermediate concepts in detail and with a proper well defined pace. Received lot of inputs much required to improvise my excel skills

By Brett Faure

easy to follow and understand. However, the view in Mac is different.

By Sicelo Mtshali

5 STARS

By Eunice Alao

Yes it is easy to understand

By Katarzyna Tarnowska

Easy to follow, straight to the point

By Anonymized User

Well explained. Easy to follow.

By Chase Roberts

Fun course

By Jonathan Fuller

keep up the good work :)

By Gabriela Franchi de Paiva Mendonca

The presenter is excellent! I just think this part of the training (personalising the ribbon) is not really relevant to this training. I think this should be in a separate course or at the end, when we already know the formulas and how to apply them to our necessities.

By Elidier Andrés Sibaja Acosta

Excellent very clear

By Jacqueline Gonski

I consider myself intermediate/advanced in excel. I was not expecting to learn as much as I have so far. Some quick refreshers and helpful hints go a long way in excel. I would highly recommend this course for anyone who is a beginner, would benefit from a refresher, or wants to learn more about excel. The videos are laid out in a way that you can select the topics you want to focus on easily. The instructor is very well spoken and communicates very clearly. One thing that stands out especially is that there is a data set provided with these classes – so you can use the reference excel spreadsheets and follow along with the videos. Not every training class for excel provides this, far too few in my opinion. For the price, quality and quantity of this course it’s a 5 star.

By Dulce Molina

The instructor explained the subject very clear. Thank you.

Showing 12 of 68 reviews

Excel 2016 Intermediate
$11.99Original price $54.9978% off
Visit course on Udemy Write a review
  • Video Duration: icon 4h
  • Price: $11.99
  • Provider: icon Udemy
  • Updated: icon April 2018
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com