This unit develops advanced Microsoft Office 365 skills that integrate document composition, data analysis, presentation design, and secure file & communication management. Students practice higher-level formatting, referencing and mail-merge techniques, worksheet functions and pivot analysis, master slide and multimedia presentation delivery, and collaboration/security workflows for workplace readiness.
Learning Objectives
- Demonstrate advanced document composition and referencing by creating multi-page documents with indents, columns, text boxes, footnotes/endnotes, cross-references, drop caps, headers/footers, and page numbering
- Apply worksheet preparation and analysis techniques including cell selection, data validation, formula/functions use, data manipulation, and PivotTable creation to produce accurate reports
- Configure and produce professional presentations using master slides, templates, diagrams, 3-D models, slide footers, recorded narration, and remote delivery tools
- Evaluate and implement collaboration, accessibility, translation/proofing, mass-mailing, file sharing, and security features (including password protection and email/calendar management) to support secure team workflows
Curriculum
- 1 Section
- 74 Lessons
- 30 hours
Expand all sectionsCollapse all sections
- Unit 4 — Advanced Productivity and Collaboration74
- 1.1Indenting Paragraphs and First Lines20 mins
- 1.2Aligning Text in Columns and Rows20 mins
- 1.3Proofing Text Written in a Foreign Language20 mins
- 1.4Working with Text Boxes20 mins
- 1.5Churning Out Letters, Envelopes, and Labels for Mass Mailings20 mins
- 1.6Putting Cross-References in a Document20 mins
- 1.7Establishing Data-Validation Rules20 mins
- 1.8Selecting Cells in a Worksheet20 mins
- 1.9Working with Functions20 mins
- 1.10Analyzing Data with PivotTables20 mins
- 1.11Creating New Slides for Your Presentation20 mins
- 1.12Using Master Slides and Master Styles for a Consistent Design20 mins
- 1.13Putting Footers (and Headers) on Slides20 mins
- 1.14Recording a Voice Narration for Slides20 mins
- 1.15Delivering a Presentation When You Can’t Be There in Person20 mins
- 1.16Cleaning Out Your Folders20 mins
- 1.17Handling Files That Were Sent to You20 mins
- 1.18Managing Meetings with the Calendar20 mins
- 1.19Establishing Relationships among Database Tables20 mins
- 1.20Understanding and Using the Layout Guides20 mins
- 1.21Inserting Frames on the Pages20 mins
- 1.22Saving a Chart as a Template So That You Can Use It Again20 mins
- 1.23Changing a Diagram’s Direction20 mins
- 1.24Inserting a 3-D Model20 mins
- 1.25Sharing Files Outside Your Organization20 mins
- 1.26Locking a File with a Password20 mins
- 1.27Getting Word to Read It20 mins
- 1.28Numbering the Pages20 mins
- 1.29Merging and Splitting Cells20 mins
- 1.30Translating Foreign Language Text20 mins
- 1.31Dropping In a Drop Cap20 mins
- 1.32Putting Footnotes and Endnotes in Documents20 mins
- 1.33Deleting, Copying, and Moving Data20 mins
- 1.34A Look at Some Very Useful Functions20 mins
- 1.35Getting a Better View of Your Work20 mins
- 1.36Techniques for Organizing Email Messages20 mins
- 1.37Making Frames Overlap20 mins
- 1.38Chart Tricks for the Daring and Heroic20 mins
- 1.39Choosing a Look for Your Diagram20 mins
- 1.40WordArt for Embellishing Letters and Words20 mins
- 1.41Trusting (or not Trusting) Microsoft with Your “Content”20 mins
- 1.42Entering Information Quickly in a Computerized Form20 mins
- 1.43Putting Headers and Footers on Pages20 mins
- 1.44Repeating Header Rows on Subsequent Pages20 mins
- 1.45Watermarking for the Elegant Effect20 mins
- 1.46Compiling a Bibliography20 mins
- 1.47Handling the Worksheets in a Workbook20 mins
- 1.48Hiding and Displaying the Slides Pane and Notes Pane20 mins
- 1.49All about Email Folders20 mins
- 1.50Inserting, Removing, and Moving Pages20 mins
- 1.51Troubleshooting a Chart20 mins
- 1.52Changing the Appearance of Diagram Shapes20 mins
- 1.53Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects20 mins
- 1.54Adjusting the Space Between Lines20 mins
- 1.55Formatting Your Table20 mins
- 1.56Putting Newspaper-Style Columns in a Document20 mins
- 1.57Keeping Others from Tampering with Worksheets20 mins
- 1.58Selecting, Moving, and Deleting Slides20 mins
- 1.59Yes, You Can Prevent Junk Mail (Sort of)20 mins
- 1.60Creating a Diagram from Scratch20 mins
- 1.61Changing an Object’s Size and Shape20 mins
- 1.62Adjusting the Space Between Paragraphs20 mins
- 1.63Using Math Formulas in Tables20 mins
- 1.64Landscape Documents20 mins
- 1.65Putting Together a Photo Album20 mins
- 1.66Changing an Object’s Color, Outline Color, and Transparency20 mins
- 1.67Creating Numbered and Bulleted Lists20 mins
- 1.68Neat Table Tricks20 mins
- 1.69Printing on Different Size Paper20 mins
- 1.70Hidden Slides for All Contingencies20 mins
- 1.71Moving and Positioning Objects20 mins
- 1.72Working with Tabs20 mins
- 1.73Showing Online Video in a Document20 mins
- 1.74Hyphenating Text20 mins
Instructor
Free
Leave a Reply