2016
Lynda
Jennifer McBee
4:05
English

Demonstrate your knowledge of Excel by becoming a Microsoft Office Specialist. Study to pass the MOS Excel 2013 certification exam. This course, created by Microsoft Certified Trainer Jennifer McBee, helps test takers prepare for exam 77-420, which covers the five main skills on the MOS Excel 2013 exam: creating worksheets and workbooks, cells and ranges, formulas and functions, and charts and other objects.
The course first explores the MOS certification program, its cost, and its format. Jennifer then walks through all of the Excel certification objectives in detail. She includes free practice files so you can follow along as she demonstrates each skill. There are challenges to test your skills at the end of almost every chapter, and the full-length, 50-minute practice exam at the end of the course will ensure you're ready for the real exam.

Introduction
2m 9s
Welcome
51s
What you should know before watching this course
15s
Using the exercise files
32s
Using the challenges
31s
1. Microsoft Office Specialist Exam Overview
7m 7s
Compare the different Microsoft Office Specialist certifications
2m 0s
Prepare for the exam
2m 12s
Exam format and registration process
2m 55s
2. Create and Manage Workbooks and Worksheets
57m 52s
Create new workbooks
3m 20s
Add, copy, and move worksheets
5m 8s
Use hyperlinks to navigate workbooks
2m 52s
Use named ranges in navigation and formulas
4m 45s
Use Find and Replace for conditional formatting and data validation
3m 3s
Format using styles or themes
3m 35s
Format using the Page Layout ribbon
3m 27s
Insert headers and footers into worksheets
4m 47s
Insert columns and rows; hide and unhide data
3m 45s
Configure worksheets and workbooks for printing
6m 19s
Add values to workbook properties
6m 11s
Challenge: Worksheets and workbooks
1m 29s
Solution: Worksheets and workbooks
9m 11s
3. Create and Modify Cells and Ranges
56m 25s
Use Append to insert data into cells
5m 35s
Move data between cells, worksheets, and workbooks
8m 17s
Format worksheets using merge, cell styles, and number formats
6m 8s
Resize cells to accommodate text
6m 45s
Format cells using merge and align options
6m 21s
Apply conditional formatting
6m 32s
Create and use named ranges
4m 50s
Use Find and Replace
5m 28s
Challenge: Cells and ranges
32s
Solution: Cells and ranges
5m 57s
4. Create and Modify Tables
24m 3s
Create tables
6m 15s
Modify tables
4m 51s
Filter and sort tables
7m 0s
Challenge: Create and modify tables
35s
Solution: Create and modify tables
5m 22s
5. Apply Formulas and Functions
41m 19s
Use relative and absolute references in formulas
5m 55s
Understand the order of operations in formulas
3m 46s
Summarize data using functions
5m 35s
Utilize conditional logic in functions
7m 59s
Use the CONCATENATE function to combine text
7m 11s
Challenge: Formulas and functions
1m 6s
Solution: Formulas and functions
9m 47s
6. Create Charts and Objects
24m 56s
Create charts and add data series
7m 48s
Format charts
4m 44s
Insert and format graphic objects
6m 49s
Challenge: Charts and objects
51s
Solution: Charts and objects
4m 44s
7. Final Practice Exam
31m 42s
Challenge: Full-length practice exam
59s
Solution: Full-length practice exam
30m 43s
Conclusion
22s
Next steps
22s

lynda.com/Excel-tutorials/Excel-2013-Prepare-Microsoft-Office-Specialist-Certification-Exam-77-420/439680-2.html

Download File Size:711.75 MB

---