From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Welcome

From the course: Cert Prep: Excel 2016 Microsoft Office Expert (77-728)

Start my 1-month free trial

Welcome

“

- [Instructor] Hi, my name is Jen McBee, and I'm here to help you prepare for the Microsoft Office Specialist Expert exam for Excel 2016. I'm a certified MOS master instructor, and I've been mentoring students in Microsoft Excel since 2006. 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 Expert exam. We'll review how to manage workbook options, reference data in another workbook using query, create formulas using structured references and protect worksheets, ranges and workbooks. We'll also learn about advanced functions such as sumifs, countifs and averageifs. We will learn how to create nested functions, how to use lookup functions and how to use date and time functions. We'll learn how to create named ranges, create and modify pivot tables and pivot charts and how to use the getpivotdata function. I will 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. When you can finish the practice exam in under 40 minutes, then you're probably ready to take on the live Excel 2016 MOS Expert exam. Thanks for joining me on this journey to certification.

Contents