Master Excel 2016 Advanced Skills
Excel 2016 - Advanced
Excel 2016 - Advanced 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, 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 and import and export data to and from their workbooks.
Course Playlist
Recommended Courses
-
Intermediate
Creating Accessible Files
2h 16m
27 Videos
-
Advanced
Access 2016 - Advanced
1h 37m
26 Videos
-
Beginner
Access 2016 - Beginner
2h 56m
52 Videos
-
Intermediate
Access 2016 - Intermediate
2h 2m
43 Videos
-
Advanced
Access 2019 - Advanced
1h 24m
25 Videos
-
Beginner
Access 2019 - Beginner
4h 27m
54 Videos
-
Intermediate
Access 2019 - Intermediate
4h 10m
44 Videos
-
Advanced
Access 365 - Advanced
1h 49m
25 Videos
-
Beginner
Access 365 - Beginner
3h 3m
48 Videos
-
Intermediate
Access 365 - Intermediate
3h 44m
45 Videos
-
Beginner
Excel 2016 - Beginner
3h 45m
67 Videos
-
Beginner
Getting Started in Excel 2016
23m
6 Videos