The Microsoft Excel 2013 Certification Training program teaches students skills in Microsoft Excel 2013 and prepares them for the Microsoft Office Specialist (MOS) Certification Exam 77-420.
Students learn essential Excel skills, including creating and editing basic worksheets and workbooks, working with advanced formulas, using lists and illustrations, adding charts and advanced formatting, managing pivot tables, and auditing and analyzing worksheet data. Students will also utilize complex data tools and collaborate with other students at various points in the program. As students advance into the program, they will learn to create and manage macros.
Upon program completion, you will be able to perform the following tasks in Excel:
You will additionally be able to perform the following advanced Excel functions: