In this course, you will work with features such as formats, styles and templates to
create professional documents with a consistent look and feel. You will add visual interest to your documents by using the tables and charts features. Quick Parts and templates provide efficiency and consistency when adding content, and long complex documents can be simplified and managed in Master Documents. Finally, you will use the mail merge feature to automate sending individual letters to customers.
This course covers MOS Program exam objectives to help you prepare for the Excel
Associate (Office 365 and Office 2019): Exam MO-200 and Excel Expert (Office 365 and
Office 2019): Exam MO-201 certifications.
Course dates and course fee may be subjected to changes.
Course Outline
Lesson 1: Organizing Content Using Tables and Charts
- Sort Table Data
- Control Cell Layout
- Perform Calculations in a Table
- Create a Chart
- Add an Excel Table to a Word Document (Optional)
Lesson 2: Customizing Formats Using Styles and Themes
- Create and Modify Text Styles
- Create Custom List or Table Styles
- Apply Document Themes
Lesson 3: Inserting Content Using Quick Parts
- Insert Building Blocks
- Create and Modify Building Blocks
- Insert Fields Using Quick Parts
Lesson 4: Using Templates to Automate Document Formatting
- Create a Document Using a Template
- Create and Modify a Template
- Manage Templates with the Template Organizer
Lesson 5: Controlling the Flow of a Document
- Control Paragraph Flow
- Insert Section Breaks
- Insert Columns
- Link Text Boxes to Control Text Flow
Lesson 6: Simplifying and Managing Long Documents
- Insert Blank and Cover Pages
- Insert an Index
- Insert a Table of Contents
- Insert an Ancillary Table
- Manage Outlines
- Create a Master Document
Lesson 7: Using Mail Merge to Create Letters, Envelopes, and Labels
- Use Mail Merge
- Merge Envelopes and Labels
