Objective | Chapter |
Word for Office 365 or Office 2019 |
Section 1: Manage documents | |
1.1 Navigate within documents | 1 |
1.2 Format documents | 1,2 |
1.3 Save and share documents | 1 |
1.4 Inspect documents for issues | 1 |
Section 2: Insert and format text, paragraphs, and sections | |
2.1 Insert text and paragraphs | 2,5 |
2.2 Format text and paragraphs | 2,3,4,5 |
2.3 Create and configure document sections | 2 |
Section 3: Manage tables and lists | |
3.1 Create tables | 3 |
3.2 Modify tables | 3 |
3.3 Create and modify lists | 3 |
Section 4: Create and manage references | |
4.1 Create and manage reference elements | 4 |
4.2 Create and manage reference tables | 4 |
Section 5: Insert and format graphic elements | |
5.1 Insert illustrations and text boxes | 5 |
5.2 Format illustrations and text boxes | 5 |
5.3 Add text to graphic elements | 5 |
5.4 Modify graphic elements | 5 |
Section 6: Manage document collaboration | |
6.1 Add and manage comments | 6 |
6.2 Manage change tracking | 6 |
Excel for Office 365 or Office 2019 |
Section 1: Manage worksheets and workbooks | |
1.1 Import data into workbooks | 7 |
1.2 Navigate within workbooks | 7 |
1.3 Format worksheets and workbooks | 7,8,9,10,11 |
1.4 Customize options and views | 7 |
1.5 Configure content for collaboration | 7 |
Section 2: Manage data cells and ranges | |
2.1 Manipulate data in worksheets | 8 |
2.2 Format cells and ranges | 7,8 |
2.3 Define and reference named changes | 8 |
2.4 Summarize data visually | 8 |
Section 3: Manage tables and table data | |
3.1 Create and format tables | 9 |
3.2 Modify tables | 7,8,9 |
3.3 Filter and sort table data | 9 |
Section 4: Perform operations by using formulas and functions | |
4.1 Insert references | 10 |
4.2 Calculate and transform datas | 10 |
4.3 Format and modify text | 7,8,10 |
Section 5: Manage charts | |
5.1 Create charts | 11 |
5.2 Modify charts | 11 |
5.3 Format charts | 11 |
PowerPoint for Office 365 or Office 2019 |
Section 1: Manage presentations | |
1.1 Modify slide masters, handout masters, and note masters | 12 |
1.2 Change presentation options and views | 12 |
1.3 Configure print settings for presentations | 12 |
1.4 Configure and present slide shows | 12 |
1.5 Prepare presentations for collaboration | 12 |
Section 2: Manage slides | |
2.1 Insert slides | 13 |
2.2 Modify slides | 13 |
2.3 Order and group slides | 13 |
Section 3: Insert and format text, shapes, and images | |
3.1 Format text | 14 |
3.2 Insert links | 14 |
3.3 Insert and format images | 14 |
3.4 Insert and format graphic elements | 14 |
3.5 Order and group objects on slides | 14 |
Section 4: Insert tables, charts, SmartArt, 3D models, and media | |
4.1 Insert and format tables | 15 |
4.2 Insert and modify charts | 15 |
4.3 Insert and format SmartArt graphics | 15 |
4.4 Insert and modify 3D models | 15 |
4.5 Insert and manage media | 15 |
Section 5: Apply transitions and animations | |
5.1 Apply and configure slide transitions | 16 |
5.2 Animate slide content | 16 |
5.3 Set timing for transitions | 16 |