Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

- [Instructor] Hi, my name is Jen McBee, and I'm here to help you prepare for the Microsoft Office Specialist Exam for Excel 2016. We'll start with an overview of the different MOS certifications and how to prepare for the exam. Next, we'll cover all of the objectives for the Excel 2016 exam. We'll review how to create and manage worksheets and workbooks, how to format worksheets, insert headers and footers, and import data. We'll also learn about creating and managing tables, using basic summary functions, such as sum, average and count numbers, and we'll learn about conditional operations, such as if, count if, sum if, and average if.

We'll learn how to use text functions, such as upper and concatenate, and we'll then work with creating and modifying charts and working with shapes and pictures. I'll give you opportunities for hands-on practice throughout the course, and we'll finish with a full length practice exam to test your skills and your speed. Thanks for joining me on this journey to certification.