Computer Basics/ Microsoft Office & Google Suite Training in Uyo, Akwa Ibom State and Port Harcourt, Rivers State

Microsoft Office & Google Suite (Office Productivity) Training in Uyo, Akwa Ibom State and Port Harcourt, Rivers State.

DATA ENTRY / OFFICE PRODUCTIVITY TRAINING COURSE

Learn how to be productive in your job, boost your business or enhance your career using vital in-demand digital tools. Get the industry-validated credentials needed to help land a high-paying job!

Training Location

• Uyo, Akwa Ibom State
• Port Harcourt, Rivers State

Microsoft Office & Google Suite (Office Productivity) Training Course Outline:

 

Module 1: Introduction to Office Productivity and Course Overview

• Overview of the course objectives, structure, and assessment.
• Introduction to the concept of office productivity and its importance.
• Exploring the various software suites: Microsoft Office and Google Workspace.
• Understanding the different applications within each suite and their primary functions.
• Introduction to collaborative and conferencing tools: Slack, Microsoft Teams, and Google Meet.
• Setting up your environment: Installing software, accessing online platforms, and configuring settings.
• Overview of the certifications: MOS, Google Workspace Administrator, Slack Certified Administrator, and Microsoft 365 Certified: Teams Administrator Associate.
• Project 1: Setting up a professional workspace (digital and physical).

Module 2: Mastering Microsoft Word – Fundamentals

• Introduction to Microsoft Word interface, ribbon, and navigation.
• Creating, saving, and opening documents.
• Basic text editing: typing, deleting, copying, and pasting.
• Formatting text: font styles, sizes, colors, and effects.
• Paragraph formatting: alignment, indentation, spacing, and line breaks.
• Working with lists: bulleted and numbered lists.
• Using spell check and grammar check.
• Project 2: Creating a basic business letter.

Module 3: Mastering Microsoft Word – Intermediate

• Working with tables: creating, formatting, and manipulating tables.
• Inserting and formatting images and shapes.
• Page layout: margins, orientation, headers, and footers.
• Working with sections and page breaks.
• Styles and themes: applying and modifying document styles.
• Creating a table of contents.
• Project 3: Designing a newsletter.

Module 4: Mastering Microsoft Word – Advanced

• Working with mail merge for mass mailings.
• Creating and using templates.
• Working with macros for automation.
• Document review and collaboration: track changes and comments.
• Protecting and securing documents.
• Working with forms.
• Project 4: Creating a professional report with a table of contents, figures, and tables.

Module 5: Microsoft Word – Certification Preparation (MOS Associate)

• Review of all Word Associate level objectives.
• Practice exercises and sample questions.
• Tips and strategies for the MOS Word Associate exam.
• Mock exam 1: MOS Word Associate.
• Review of mock exam results and targeted practice.

Module 6: Mastering Microsoft Excel – Fundamentals

• Introduction to the Excel interface, ribbon, and navigation.
• Creating, saving, and opening workbooks and worksheets.
• Entering and editing data: text, numbers, and dates.
• Basic formatting: font styles, sizes, colors, and cell formatting.
• Working with formulas: basic arithmetic operations.
• Using functions: SUM, AVERAGE, MIN, and MAX.
• Working with ranges and cell references.
• Project 5: Creating a simple budget spreadsheet.

Module 7: Mastering Microsoft Excel – Intermediate

• Working with more complex formulas: IF, COUNTIF, and VLOOKUP.
• Creating and formatting charts and graphs.
• Sorting and filtering data.
• Working with multiple worksheets and workbooks.
• Data validation.
• Conditional formatting.
• Project 6: Creating a sales performance dashboard.

Module 8: Mastering Microsoft Excel – Advanced

• Pivot tables and pivot charts for data analysis.
• Advanced functions: INDEX, MATCH, and OFFSET.
• Working with macros and VBA for automation.
• Data analysis tools: what-if analysis, goal seek, and solver.
• Working with external data sources.
• Collaboration and sharing workbooks.
• Project 7: Building a financial model.

Module 9: Microsoft Excel – Certification Preparation (MOS Associate)

• Review of all Excel Associate level objectives.
• Practice exercises and sample questions.
• Tips and strategies for the MOS Excel Associate exam.
• Mock exam 2: MOS Excel Associate.
• Review of mock exam results and targeted practice.

Module 10: Mastering Microsoft PowerPoint – Fundamentals

• Introduction to the PowerPoint interface, ribbon, and navigation.
• Creating, saving, and opening presentations.
• Working with slides: adding, deleting, and rearranging slides.
• Formatting text and paragraphs.
• Inserting and formatting images, shapes, and SmartArt.
• Working with themes and slide masters.
• Adding transitions and animations.
• Project 8: Creating a basic presentation.

Module 11: Mastering Microsoft PowerPoint – Intermediate

• Working with tables and charts in PowerPoint.
• Adding multimedia: audio and video.
• Customizing slide designs and layouts.
• Delivering presentations: presenter view and slide show options.
• Creating interactive presentations with hyperlinks and action buttons.
• Working with animations and transitions.
• Project 9: Designing a marketing presentation.

Module 12: Mastering Microsoft PowerPoint – Advanced

• Advanced animation techniques.
• Working with slide masters and templates.
• Customizing the presentation environment.
• Collaborating on presentations.
• Broadcasting presentations online.
• Creating self-running presentations.
• Project 10: Developing a training presentation with multimedia and interactivity.

Module 13: Microsoft PowerPoint – Certification Preparation (MOS Associate)

• Review of all PowerPoint Associate level objectives.
• Practice exercises and sample questions.
• Tips and strategies for the MOS PowerPoint Associate exam.
• Mock exam 3: MOS PowerPoint Associate.
• Review of mock exam results and targeted practice.

Module 14: Mastering Microsoft Access – Fundamentals

• Introduction to database concepts and terminology.
• Introduction to the Access interface, ribbon, and navigation.
• Creating and managing databases.
• Creating tables: defining fields and data types.
• Working with data: entering, editing, and deleting data.
• Creating simple queries.
• Creating forms for data entry.
• Project 11: Creating a simple customer database.

Module 15: Mastering Microsoft Access – Intermediate

• Creating relationships between tables.
• Advanced query design: using criteria and sorting.
• Creating reports for data presentation.
• Working with subforms and subreports.
• Importing and exporting data.
• Database design principles.
• Project 12: Designing an inventory management database.

Module 16: Mastering Microsoft Access – Advanced

• Advanced report design: grouping, sorting, and calculations.
• Creating complex queries: joins and subqueries.
• Working with macros and VBA in Access.
• Database administration and security.
• Splitting databases.
• Working with relational database concepts.
• Project 13: Developing a database for a small business.

Module 17: Microsoft Access – Certification Preparation (MOS Expert)

• Review of all Access Expert level objectives.
• Practice exercises and sample questions.
• Tips and strategies for the MOS Access Expert exam.
• Mock exam 4: MOS Access Expert.
• Review of mock exam results and targeted practice.

Module 18: Mastering Microsoft Outlook

• Introduction to the Outlook interface and navigation.
• Sending, receiving, and managing emails.
• Organizing emails with folders, rules, and filters.
• Managing contacts and address books.
• Working with calendars: appointments, meetings, and events.
• Task management and to-do lists.
• Using notes and journaling.
• Project 14: Setting up and managing a professional email and calendar system.

Module 19: Mastering Microsoft OneNote and OneDrive

• Introduction to OneNote interface and organization.
• Creating and managing notebooks, sections, and pages.
• Adding and formatting text, images, and other content.
• Using tags and search in OneNote.
• Sharing and collaborating on OneNote notebooks.
• Introduction to OneDrive and cloud storage.
• Uploading, downloading, and syncing files with OneDrive.
• Sharing files and folders with others.
• Collaborating on documents in OneDrive.
• Project 15: Creating a collaborative project notebook and managing project files on OneDrive.

Module 20: Microsoft Office Integration and Advanced Topics

• Integrating data between Word, Excel, and PowerPoint.
• Embedding and linking objects.
• Using Office Online for collaboration.
• Customizing the Office environment.
• Exploring advanced features and tools in Microsoft Office.
• Accessibility features in Microsoft Office.
• Troubleshooting common Office issues.
• Project 16: Creating an integrated business proposal using Word, Excel, and PowerPoint.

Module 21: Microsoft Office Specialist (MOS) Expert and Master Certification Preparation

• Review of MOS Expert and Master level objectives for Word and Excel.
• Practice exercises and sample questions for Expert and Master exams.
• Tips and strategies for the MOS Expert and Master exams.
• Mock exams for Word Expert, Excel Expert, and Word Master.
• Review of mock exam results and targeted practice.

Module 22: Introduction to Google Workspace

• Overview of Google Workspace applications: Docs, Sheets, Slides, Forms, etc.
• Understanding the differences between Google Workspace and Microsoft Office.
• Setting up and navigating the Google Workspace environment.
• Collaboration features in Google Workspace.
• Introduction to Google Workspace administration.
• Project 17: Setting up a Google Workspace for a team.

Module 23: Mastering Google Docs, Sheets, and Slides

• In-depth exploration of Google Docs: creating, formatting, and collaborating on documents.
• In-depth exploration of Google Sheets: creating spreadsheets, using formulas, and analyzing data.
• In-depth exploration of Google Slides: designing and delivering presentations.
• Advanced features and integrations within each application.
• Project 18: Collaboratively creating a project report using Google Docs, Sheets, and Slides.

Module 24: Mastering Google Forms and Other Workspace Tools

• Creating and managing surveys and quizzes with Google Forms.
• Analyzing data and generating reports with Google Forms.
• Utilizing other Google Workspace tools: Meet, Chat, Calendar, etc.
• Integrating Google Workspace tools for enhanced productivity.
• Project 19: Designing and deploying a survey using Google Forms and analyzing the results.

Module 25: Google Workspace Administration Fundamentals

• Introduction to Google Workspace administration console.
• Managing users and groups.
• Setting up organizational units (OUs).
• Configuring security settings and policies.
• Managing domains and DNS records.
• Project 20: Setting up and managing a Google Workspace domain for a small organization.

Module 26: Advanced Google Workspace Administration

• Advanced security and compliance settings.
• Managing email and spam filtering.
• Configuring device management.
• Setting up single sign-on (SSO).
• Automating tasks with Google Apps Script.
• Troubleshooting Google Workspace issues.
• Project 21: Implementing advanced security and management features in a Google Workspace environment.

Module 27: Google Workspace Administrator Certification Preparation

• Review of all Google Workspace Administrator certification objectives.
• Practice exercises and sample questions.
• Tips and strategies for the Google Workspace Administrator exam.
• Mock exam 5: Google Workspace Administrator.
• Review of mock exam results and targeted practice.

Module 28: Mastering Collaborative and Conferencing Tools: Slack, Microsoft Teams, and Google Meet

• In-depth exploration of Slack: channels, messaging, and integrations.
• In-depth exploration of Microsoft Teams: teams, channels, meetings, and apps.
• In-depth exploration of Google Meet: video conferencing, screen sharing, and collaboration features.
• Best practices for effective communication and collaboration using these tools.
• Project 22: Setting up and managing communication channels for a project using Slack or Microsoft Teams.

Module 29: Slack and Microsoft Teams Administration

• Slack Administration: User management, channel management, security settings, app integrations.
• Microsoft Teams Administration: Team and channel management, meeting policies, app management, security and compliance.
• Best practices for managing and securing collaborative environments.
• Project 23: Configuring and managing a Microsoft Teams environment for a medium-sized organization.