In this video, learn how to contact the course instructor for further questions.
- [Narrator] Your next steps are to make sure you can … complete the challenge exercises within the allotted time, … and keep practicing with the final challenge. … Once you're comfortable with all the objectives … covered throughout the course, … you'll be ready to begin your final preparation … for the Excel Associate exam. … Once again, I'm Jen McBee, thanks for watching. … …
Resume Transcript Auto-Scroll
Author
Jennifer McBee
Released
7/1/2019
Demonstrate your knowledge of Excel 2019 by becoming a Microsoft Office Specialist (MOS). Get training to prepare for the Excel Associate certification exams for Office 365 and Office 2019. This course, created by Microsoft Certified Instructor and MOS Master Jennifer McBee, helps you prepare for the five main areas of focus for the Excel Associate Office 365 and Office 2019 exams: managing worksheets and workbooks, managing data cells and ranges, managing tables and table data, performing operations with formulas and functions, and managing charts. The course includes an overview of the MOS certification program, its costs, and all the exam objectives. Follow along with the downloadable sample files. Then take the full-length practice test at the end of the course to test your skills and speed.
Topics include:
- Importing data
- Formatting worksheets and workbooks
- Exporting workbooks
- Pasting data
- Modifying columns, rows, and cells
- Formatting cells
- Conditional formatting
- Creating tables
- Filtering and sorting table data
- Using references
- Performing calculations with functions
- Formatting text with functions
- Creating charts
- Taking the practice exam
Skill Level Intermediate
3h 34m
Duration
21,933
Views
Show More
Show Less
-
Introduction
-
Who should take this course?1m 15s
-
1. Microsoft Office Specialist Exam Overview
-
2. Manage Worksheets and Workbooks
-
Inspect and export workbooks6m 33s
-
Configure print settings4m 15s
-
3. Manage Data Cells and Ranges
-
Format cells and ranges5m 39s
-
Insert sparklines5m 35s
-
4. Manage Tables and Table Data
-
Create and format tables3m 23s
-
Modify tables4m 19s
-
-
5. Perform Operations Using Formulas and Functions
-
6. Manage Charts
-
Create charts3m 40s
-
Modify charts2m 45s
-
Format charts3m 4s
-
Solution: Manage charts4m 31s
-
-
7. Final Practice Exam
-
Conclusion
-
Next steps22s
-
Show MoreShow Less
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Next steps