Advanced concepts, formulas and collaboration tools
schedule5h
4.6(95)
Intellezy Trainers
•
Offering eLearning and Instructor-led Training at your fingertips!
93 Courses
• 537 Reviews
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,...
Edward McCrae
•
Intellezy Instructor
Ed specializes in Excel Workbook development, Access Database Design, and SharePoint site creation and administration. Ed has been in the technical training industry since 2006 and has taught Microsof...
About this course
This course will teach students advanced concepts and formulas in Microsoft Excel 365. 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.