4.7  551 reviews on Udemy

Excel 2016 Advanced

Take Excel to the next level with advanced formulas, What-If Analysis tools, advanced PivotTables, Macros and much more
Course from Udemy
 2249 students enrolled
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

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.

This IAAP-certified counts for 2.25 recertification points for the CAP certification under the Technology and Information Distribution content area.
Email [email protected] with proof of completion of the course to obtain your certificate.

Excel 2016 Advanced
$ 39.99
per course
Also check at

FAQs About "Excel 2016 Advanced"


Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.