This course is designed to teach advanced topics of MS Excel by building upon the topics covered in the course OL702 Excel Core. Students will learn how to create and analyze spreadsheets using PivotTables and PivotCharts, and Excel’s What-If analysis tools. Students also learn many of Excel’s advanced functions, including logical and conditional, financial, date and time, and database functions and also how to create their own custom functions. In addition, students learn how to protect and share their workbooks. This course helps prepare students wishing to pursue the MOS certification exams for Excel Expert (Excel Expert 2016 exam 77-728 and Excel Expert 2019 exam MO-201). Computer Software Requirements: MS Excel version 2016, 2019, 2021 or 365 for windows. MAC users are not supported in this course.
Sign UpExplore our available course intakes, designed to fit your schedule with flexible start dates. Whether you're studying online or in-class, each session is structured to provide a clear learning pathway.