Skip to content
UdemyExcelPaid courseExpert levelCertificate

Excel 2016 Advanced (Udemy.com)

Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much more

Created by: Intellezy Trainers

Last updated April 2018

icon
What you will learn

  • Use Advanced IF Statements
  • Use Advanced Lookup Functions
  • Use Complex Logical and Text Functions
  • Auditing Formulas
  • Working with What-If Analysis Tools
  • Protecting Worksheet and Workbook
  • Use Advanced PivotTables and PowerPivot Tools
  • Automate with Macros
  • Work with Form Controls
  • Ensure Data Integrity
  • Collaborate in Excel
  • Import and Export Data to a Text File

icon
Course Description

This course will teach students advanced concepts and formulas in Microsoft Excel 2016. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions such as HLOOKUP and VLOOOKP and MATCH and INDEX, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features, as well as how to import and export data to and from their workbooks.


With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.


This course aligns with the CAP Body of Knowledge and should be approved for 2.25 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.


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.

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

Intellezy Trainers

Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individuals

Our library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need them.

In today’s rapidly evolving workplace, it is imperative to make sure your team members have the skills and expertise required to succeed. Intellezy offers custom content development to ensure learning materials, and the delivery approach is aligned to meet intended outcomes and address your specific training needs without covering topics that may be unnecessary or irrelevant.

icon
More courses by Intellezy Trainers

$13.99

$14.99

$15.99

$39.99

$11.99

$14.99

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.4

575 ratings on Udemy

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

By Anonymized User on 11/20/2020

This was a very informative course. Very flexible to jump right to the topics you want to learn; do not need to follow the order as presented. Ed is a fantastic instructor; clear, funny, and great presentation delivery.

By Angela Hegemann on 10/15/2020

This instructor is really, really good. He explains everything very well. His lessons are a nice length. Easy to work through the training between other responsibilities at work. Love his teaching methods. Not too flashy, but obviously knows what he is talking about very well. I will be looking for more by this instructor.

By Shiva wadhwa on 4/24/2020

Course name is misleading. As it is only overview of few key functions in very short time. You can find many elaborated courses at same price and much detailed discussion about each topic.

By Anonymized User on 2/9/2020

I went to Barnes & Noble last night to look for a book on Macros/VBA. Having found what I think is a pretty good one, I came home and purchased it for my eReader and now that I've finished this course, I'll study Macros/VBA. I've been avoiding this, but the Macros section of this course has inspired me to do this.

By Jennifer Danzer on 7/23/2019

Great content at the right speed, very clear examples. I appreciate how well versed the instructor is and how he has a way of guiding you and making everything seem easy. It is once you know the key words and some guidelines of what to do.

By Virginia Iliadou on 11/13/2018

Enjoed the course, it gives you key points to enrich your excel knowledge. Would recomend it to those that already have a basic level of excel, although it can be also used as a reference to search and find the areas you have to cover to get to the advanced. I finished it in 3 days, very satisfied, would definately recommend.

By Anonymized User on 10/23/2018

Once I hit the Formula Auditing Section, I was learning so many helpful things! Getting to learn a little about macros and VBA was really interesting as well. I would suggest though that the transcript program be double checked, there were some horrible things written by the system that were not what Ed was saying.

By Bettina Ferencz on 6/22/2018

It was easy. It would be useful if the training shows more examples about complex SUMIFS, COUNTIFS calculations and share the excel table before the training in which we can practice the same thing what the trainer shows us.

By Tim on 5/7/2017

I am still having some trouble with the VLookup and HLookup and the rate and grade tables that are used in the course. How to set up these tables is not included in the course like Name Range was in SumIF course. Udemy support was able to assist me with this but I still cannot come up with the same output as the instructor. I will go back and look at this again when I finish the course. Other than that, this has been very helpful in helping me take Excel to the next level.

By Tom O on 10/27/2016

This was truly a well presented course, Ed's delivery was great and a lot is covered. The only thing I think is missing is practice exercises and solution files. Other than that the course is excellent and easy to follow.

Showing all 10 reviews on CourseDuck

Read all 575 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

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

Overall Score : 88 / 100