From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Welcome
From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)
Welcome
- [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.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.