Enrol in Microsoft Excel Expert
Course Code: COMP164
Building on the introductory Excel course, you will create and analyze spreadsheets using PivotTables and PivotCharts, and use Excel's What-If analysis tools. You will explore many of Excel's advanced functions, including logical and conditional, financial, date and time, and database functions and also how to create your own custom functions. In addition, you will learn how to protect and share their workbooks. Prerequisite: Excel - Core/Specialist or equivalent experience. Software: Microsoft Excel 2016, 2019 or 365 for Windows. Not suitable for MAC users. This course is designed for the Windows operating system.