4.50
(2 Ratings)

Microsoft Office Suite 2021

Wishlist Share
Share Course
Page Link
Share On Social Media

What Will You Learn?

  • Word (word processing)
  • Excel (spreadsheets)
  • Access (Relational Database)
  • PowerPoint (presentations)
  • Outlook (email and calendar)

Course Content

Microsoft Word
Introduction 1. Start working with Word 2. Work with Texts 3. Formatting Texts 4. Work with Paragraphs 5. Start Formatting Pages 6. Start Creating Lists 7. Illustrate a Document 8. Ensure your Document is error free (proofing). 9. Share your Document and Collaborate with others

  • Introduction to MS Word
  • Things to Know to Follow Along

Module 1: Getting Started
1. Open, Close and Read Documents 2. Save New Documents 3. Use the Tell me Assistance

Module 2: Working with Text
1. Inserting New Text 2. Rearrange Text with Cut, Copy and Paste 3. Copy Text from another source 4. Find and Replace Text

Module 3: Formatting Text
1. Change Font Formatting 2. Format Text with Styles 3. Change Text Case

Module 4: Working with Paragraph Text
1. Change Paragraph Alignment 2. Adjust Line Spacing 3. Keeping Text Together Across Page Breaks 4. Put Text into Columns

Module 5: Formatting Pages
1. Change Page Layout 2. Use Headers and Footers 3. Work with Page Numbering

Module 6: Creating List
1. Create Bulleted and Numbered Lists 2. Edit and Format Lists

Module 7: Illustrating Documents
1. Illustrate with a Table 2. Illustrate with images 3. Adjust images in a document

Module 8: Proofing Documents
1. Set Proofing and Autocorrect Options 2. Proof your document with Editor 3. Use the Resume Assistance

Module 9: Sharing and Collaborating
1. Print your documents 2. Add Password Protection to a File 3. Send documents via email 4. Collaborate on documents in the cloud

Microsoft Excel
1. Introduction 2. Getting Started with Excel 3. Entering Data 4. Formulas and Functions 5. Formatting 6. Adjusting Worksheet Layout and Data 7. Printing 8. Charts 9. Adjusting Worksheet Views 10. Multiple Worksheets and Workbooks 11. Data Management Features 12. Sharing Workbooks

Introduction
1. Getting Started with Excel for Office 365

Module 1: Getting Started with Excel
1. What is Excel used for? 2. Using the Quick Access Toolbar and Ribbon menu 3. Shortcut menus and the mini-Toolbar 4. Understanding Workbooks and Worksheets 5. Using Excel Help

Module 2: Entering Data
1. Exploring Data Entry, Editing, and Autofill 2. Working with Dates and Times 3. Using Undo and Redo 4. Using Save or Save As

Module 3: Formulas and Functions
1. Using Simple Formulas 2. Copying a Formula into Adjacent cells 3. Using SUM and AVERAGE 4. XLOOKUP and Lookup Functions

Module 4: Formatting
1. Exploring Font Styles and Effects 2. Applying Borders and Color Backgrounds 3. Adjusting Row Heights and Column Widths

Module 5: Adjusting Worksheet Layout and Data
1. Rows and Columns: Insert, Delete, Hide and unhide 2. Moving, Copying and Inserting Data 3. Finding and Replacing Data

Module 6: Printing
1. Page Layout View and Commands 2. Using Page Break Preview and Print Setup Options

Module 7: Charts
1. Creating Charts 2. Exploring Chart Types 3. Working with Excel Ideas

Module 8: Adjusting Worksheet Views
1. Freezing and Unfreezing Panes 2. Splitting Screens Horizontally and Vertically

Module 9: Multiple Worksheets and Workbooks
1. Renaming, Inserting, and Deleting Sheets 2. Moving, Copying, and Grouping Sheets

Module 10: Data Management Features
1. Sorting Data 2. Using Filters 3. Creating PivotTables 4. New Data Types coming to Excel for 365

Module 11: Sharing Workbooks
1. Protecting Worksheets and Workbooks 2. Sharing Workbooks 3. Tracking Changes

Microsoft PowerPoint
1. Introduction to PowerPoint 2. Layouts and Colors 3. Texts and Tables 4. Images and Graphics 5. Organizing Slides 6. Animation, Video and Audio 7. Notes and Comments 8. Delivering Presentations 9. Saving and Sharing a Presentation

Module 1: Introduction
1. Visual Presentations with PowerPoint 2. Understanding Office Versions 3. Use Themes and Templates for quick start 4. Create and Save a Presentation 5. Add, Arrange, and Duplicate Slides 6. Select the right view for the task

Module 2: Layouts and Colors
1. Slide Layouts 2. Slide Colors and Backgrounds 3. The Importance of the Master Slide

Module 3: Text and Tables
1. Add and Modify Text 2. Work with Text Boxes 3. Create a Table 4. Slide and Page Numbers

Module 4: Images and Graphics
1. Add Images 2. Create Shapes 3. Add Effects to Shapes and Objects 4. Create a Chart

Module 5: Organizing Slides
1. Keep Things Aligned 2. Arrange and Layer Objects 3. Group Objects

Module 6: Animation, Video and Audio
1. Create and Modify Transitions 2. Animate Objects and Texts 3. Use Zoom to Highlight Slides 4. Add and Format Video 5. Add Audio Files

Module 7: Notes and Comments
1. Speaker Notes 2. Share Presentations 3. Comment on Presentations

Module 8: Delivering Presentations
1. Deliver The Presentation 2. Run Unattended Slideshows 3. Record and Narrate a Presentation

Module 9: Saving and Sharing a Presentation
1. Save to pdf 2. Export to Video 3. Save as a Custom Theme 4. Save Presentation as a Template

Microsoft Access
1. Getting Started 2. Creating Tables 3. Setting Field Properties 4. Organizing Records 5. Using Queries 6. Creating Forms 7. Creating Reports 8. Maintaining the Database

Introduction
1. Build Databases with Access 2. What you should know

Module 1: Getting Started
1. Database Concepts 2. Create the Database File 3. Understand the Trust Center 4. Dig into Ribbon Tabs 5. Database Navigation Pane 6. Customize the Quick Access Toolbar 7. Create a Database Backup

Module 2: Creating Tables
1. Table Structures and Relationships 2. Create a Table and Set Data Types 3. Enter Data 4. Primary and Foreign Keys 5. Import Tables

Module 3: Setting Field Properties
1. Relationships and Referential Integrity 2. Edit Table Structure in Design View 3. Control Input with Masks 4. Set a Default Value 5. Data Validation Rules 6. Data Lookup Fields 7. Additional Field Properties

Module 4: Organizing Records
1. Sort Table Data 2. Filter Table Data 3. Delete Records 4. Search and Replace Values

Module 5: Using Queries
1. What are Queries 2. Simple Query Wizard 3. Build Queries in Design View 4. Establish Constraints with Criteria 5. Specify Criteria with Wildcards 6. Incorporate AND and OR Statements 7. Filter with Mathematical Comparisons 8. Create Flexible Queries with Parameters 9. Build Expressions 10. Obtain Summary Statistics

Module 6: Creating Forms
1. Understand The Role of Forms 2. Generate Forms from Tables 3. Adjust Forms Elements in Layout View 4. Use The Form Wizard 5. Form Design View 6. Find Records

Module 7: Creating Reports
1. Introducing Reports 2. Report Wizard 3. Edit a Report in Design View 4. Edit a Report in Layout View 5. Group and Sort Records 6. Create Calculated Totals 7. Apply Conditional Formatting Rules 8. Create Labels 9. Adjust Print Settings

Module 8: Maintaining the Database
1. Customize Groups in the Navigation Pane 2. Compact and Repair the Database 3. Examine Database Object Relationships 4. Document your Thought Process 5. Print the Blueprint of your Database 6. Split a Database into Front and Back Ends 7. Protect the Database with a Password 8. Set Startup Options

Student Ratings & Reviews

4.5
Total 2 Ratings
5
1 Rating
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
Amara-Vandy
2 months ago
The Microsoft Word 2021 course was excellent. The lessons were clear, engaging, and offered practical tips that made using Word much easier. I learned new features that have significantly improved my productivity, especially in document formatting and collaboration. It’s definitely a must-take for anyone looking to master Word efficiently
AS
4 months ago
it's a practical and essential course for a starter like me.
Scroll to Top