Course Length : 1 Day

Course Objectives: In this course, you will learn fundamental Word skills.

• Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
• Format text and paragraphs.
• Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
• Enhance lists by sorting, renumbering, and customizing list styles.
• Create and format tables.
• Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
• Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
• Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.

Course Content

Lesson 1: Getting Started with Word 2021 (6 Topics)

Lesson 2: Formatting Text and Paragraphs (5 Topics)

Lesson 3: Working More Efficiently (3 Topics)

Lesson 4: Managing Lists (2 Topics)

Lesson 5: Adding Tables (4 Topics)

Lesson 6: Inserting Graphic Objects (2 Topics)

Lesson 7: Controlling Page Appearance (4 Topics)

Lesson 8: Preparing to Publish a Document(4 Topics)

Course Length : 1 Day

Course Objectives : In this course, you will learn to create and modify complex documents and use tools that allow you to customize those documents.

• • Organize content using tables and charts.
  • Customize formats using styles and themes.
  • Insert content using Quick Parts.
  • Use templates to automate document formatting.
  • Control the flow of a document.
  • Simplify and manage long documents.
  • Use mail merge to create letters, envelopes, and labels.

Course Content :

Lesson 1: Organizing Content Using Tables and Charts (5 Topics)

Lesson 2: Customizing Formats Using Styles and Themes (3 Topics)

Lesson 3: Inserting Content Using Quick Parts (3 Topics)

Lesson 4: Using Templates to Automate Document Formatting (3 Topics)

Lesson 5: Controlling the Flow of a Document (4 Topics)

Lesson 6: Simplifying and Managing Long Documents (6 Topics)

Lesson 7: Using Mail Merge to Create Letters, Envelopes, and Labels (2 Topics)

Course Length : 1 Day

Course Objectives : In this course, you will learn to use the advanced capabilities of Word 2021.

• • Use images in a document.
  • Create custom graphic elements.
  • Collaborate on documents.
  • Add reference marks and notes.
  • Secure a document.
  • Create and manipulate forms.
  • Create macros to automate tasks.

Course Content :

Lesson 1: Manipulating Images (3 Topics)

Lesson 2: Using Custom Graphic Elements (4 Topics)

Lesson 3: Collaborating on Documents (4 Topics)

Lesson 4: Adding Document References and Links (6 Topics)

Lesson 5: Securing a Document (4 Topics)

Lesson 6: Using Forms to Manage Content (2 Topics)

Lesson 7: Automating Repetitive Tasks with Macros (2 Topics)

Course Length : 1 Day

Course Objectives: Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization

• Get started with Microsoft Office Excel 2021.
• Perform calculations.
• Modify a worksheet.
• Format a worksheet.
• Print workbooks.
• Manage workbooks.

Course Content

Lesson 1: Getting Started with Excel 2021 (5 Topics)

Lesson 2: Performing Calculations (3 Topics)

Lesson 3: Modifying a Worksheet (3 Topics)

Lesson 4: Formatting a Worksheet (6 Topics)

Lesson 5: Printing Workbooks (3 Topics)

Lesson 6: Managing Workbooks (3 Topics)

Course Length : 1 Day

Course Objectives : Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

• • Work with functions.
  • Work with lists.
  • Analyze data.
  • Visualize data with charts.
  • Use PivotTables and Pivot Charts.

Course Content :

Lesson 1: Working with Functions (9 Topics)

Lesson 2: Analyzing Data (3 Topics)

Lesson 3: Inserting Content Using Quick Parts (3 Topics)

Lesson 4: Visualizing Data with Charts (3 Topics)

Lesson 5: Using PivotTables and Pivot Charts (4 Topics)

Course Length : 1 Day

Course Objectives : Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

• • Work with multiple worksheets and workbooks.
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Use Lookup functions, dynamic arrays, and formula auditing.
  • Forecast data.
  • Create sparklines and map data.

Course Content :

Lesson 1: Working with Multiple Worksheets and Workbooks (3 Topics)

Lesson 2: Sharing and Protecting Workbooks (2 Topics)

Lesson 3: Automating Workbook Functionality (3 Topics)

Lesson 4: Using Lookup Functions, Dynamic Arrays, and Formula Auditing (4 Topics)

Lesson 5: Forecasting Data(4 Topics)

Lesson 6: Creating Sparklines and Mapping Data (2 Topics)

Course Length : 1 Day

Course Objectives: In this course, you will create and manage an Access 2016 database.

• Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
• Organize and manage data stored within Access tables.
• Use queries to join, sort, and filter data from different tables.
• Use forms to make it easier to view, access, and input data.
• Create and format custom reports.

Course Content

Lesson 1: Getting Started with Access (3 Topics)

Lesson 2: Working with Table Data (2 Topics)

Lesson 3:Querying a Database (3 Topics)

Lesson 4:Using Forms (2 Topics)

Lesson 5:Generating Reports (6 Topics)

Course Length : 1 Day

Course Objectives : In this course, you will create and manage an Access 2016 database.

• • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Validate data entered into a database.
  • Use advanced queries to manipulate your data.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Customize reports to organize the displayed information and produce specific print layouts.

Course Content :

Lesson 1: Designing a Relational Database (3 Topics)

Lesson 2: Joining Tables (3 Topics)

Lesson 3: Using Data Validation (2 Topics)

Lesson 4: Creating Advanced Queries (5 Topics)

Lesson 5: Organizing a Database for Efficiency (3 Topics)

Lesson 6: Using Advanced Reporting Techniques (3 Topics)

Course Length : 1 Day

Course Objectives : In this course, you will learn to create and manage a fundamental Access 2016 database.

• • Customize a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Use VBA to enhance tasks.
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
  • Lock down and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the start-up options.

Course Content :

Lesson 1: Implementing Advanced Form Design (3 Topics)

Lesson 2: Sharing Data Across Applications (4 Topics)

Lesson 3: Using Macros to Improve User Interface Design (4 Topics)

Lesson 4: Using VBA (2 Topics)

Lesson 5: Using Advanced Database Management (3 Topics)

Lesson 6: Distributing and Securing a Database (4 Topics)

Lesson 7: Managing Switchboards (3 Topics)

Course Length : 1 Day

Course Objectives: In this course, you will create and deliver an engaging PowerPoint presentation.

• Identify the basic features and functions of PowerPoint.
• Develop a PowerPoint presentation.
• Perform text formatting.
• Add and arrange graphical elements.
• Modify graphical elements.
• Prepare to deliver your presentation.

Course Content

Lesson 1: Getting Started with PowerPoint 2021 (4 Topics)

Lesson 2: Developing a PowerPoint Presentation (4 Topics)

Lesson 3: Formatting Text (2 Topics)

Lesson 4: Adding and Arranging Graphical Elements (5 Topics)

Lesson 5: Modifying Graphical Elements (6 Topics)

Lesson 6: Preparing to Deliver Your Presentation (4 Topics)

Course Length : 1 Day

Course Objectives : In this course, you will use the advanced tools and features in PowerPoint 2021 to create and deliver engaging presentations.

• • Customize design templates.
  • Add tables.
  • Add charts.
  • Work with media.
  • Build advanced transitions and animations.
  • Finalize a presentation.
  • Modify presentation navigation.
  • Secure and distribute a presentation.

Course Content :

Lesson 1: Customizing Design Templates (3 Topics)

Lesson 2: Adding Tables (3 Topics)

Lesson 3: Adding Charts (2 Topics)

Lesson 4: Working with Media (5 Topics)

Lesson 5: Building Advanced Transitions and Animations (2 Topics)

Lesson 6: Finalizing a Presentation (4 Topics)

Lesson 7: Modifying Presentation Navigation (3 Topics)

Lesson 8: Securing and Distributing a Presentation (2 Topics)

Course Length : 1 Day

Course Objectives: In this course, you will use Outlook to manage your email communications, including composing, reading, and responding to emails; schedule appointments and meetings; manage contact information; schedule tasks and create notes; customize message response options; and organize your mail.

• Navigate Outlook to read and respond to email.
• Use the Address Book and format and spell check new messages.
• Attach files and insert illustrations to messages.
• Customize read and response options.
• Use flags, categories, and folders to organize messages.
• Create and work with Contacts.
• Create appointments and schedule meetings in Calendar.
• Create and work with Tasks and Notes.

Course Content

Lesson 1: Getting Started with Outlook 2019/2021 (3 Topics)

Lesson 2: Formatting Messages (2 Topics)

Lesson 3: Working with Attachments and Illustrations (3 Topics)

Lesson 4:Customizing Message Options (3 Topics)

Lesson 5: Organizing Messages (2 Topics)

Lesson 6: Managing Your Contacts (2 Topics)

Lesson 7: Working with the Calendar (4 Topics)

Lesson 6: Working with Tasks and Notes (2 Topics)

Course Length : 1 Day

Course Objectives : In this course, you will use Outlook’s advanced features to customize and manage your email communications, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook archives and data file settings.

• • Insert objects in messages and modify properties and global options.
  • Organize, search, and manage messages.
  • Protect your mailbox and manage its size.
  • Use rules and Quick Steps to automate message management.
  • Work with advanced calendar settings.
  • Import and forward contacts.
  • Manage activities by assigning tasks to others.
  • Delegate access to and share Outlook items with others.
  • Archive and back up Outlook items using data files.

Course Content :

Lesson 1: Modifying Message Properties and Customizing Outlook (4 Topics)

Lesson 2: Organizing, Searching, and Managing Messages (3 Topics)

Lesson 3: Managing Your Mailbox (2 Topics)

Lesson 4: Automating Message Management (3 Topics)

Lesson 5: Working with Calendar Settings (3 Topics)

Lesson 6: Managing Contacts (3 Topics)

Lesson 7: Managing Activities by Using Tasks (1 Topics)

Lesson 8: Sharing Outlook Items (3 Topics)

Lesson 8: Managing Outlook Data Files(2 Topics)

Course Length : 0.5 Day

Course Objectives: In this course, you will use Microsoft Teams to chat, post, initiate calls, and participate in meetings

• Use chat messages and posts to communicate with the team.
• Initiate, join, record, and screen share in calls and meetings.
• Share and work with files and apps.
• Create a team and configure channels and tabs.

Course Content

Lesson 1: Communicating with Microsoft Team (3 Topics)

Lesson 2: Calling and Meeting in Teams (3 Topics)

Lesson 3: Sharing Files and App Content (2 Topics)

Lesson 4: Creating and Configuring Teams (3 Topics)