If your organization uses lists of any kind, you need to know how to use Microsoft Excel. Earning Microsoft Office Specialist and Expert certifications sets your professional skill set apart from other Excel users. This course will prepare you for the Microsoft Office Specialist (MOS) and Expert certification exams for Excel.
You will first learn to use Excel 2019 to create, modify, and format Excel worksheets, perform calculations, and print Excel workbooks. The course then moves on to teach you how to use advanced formulas, work with lists, work with illustrations and charts, and use advanced formatting techniques. You will also learn Excel's advanced features, such as pivot tables, audit worksheets, data tools, macros, and collaboration methods.
Upon completion of this course, you will be prepared for the Microsoft Office Specialist and Expert certification exams for Excel 2019. The certification exam for Microsoft Excel 2019 will be released mid 2019.