Duration: 3 days – 21 hrs
Overview
The Microsoft 365 Office Essentials Training Course is designed to equip participants with essential skills and proficiency in using Microsoft 365, one of the most widely used office productivity suites worldwide. This comprehensive training program covers Microsoft Excel and Microsoft Word, focusing on both beginner and advanced levels. It is tailored to individuals and professionals who want to enhance their productivity, efficiency, and collaboration capabilities in the modern workplace.
Objectives
• Discuss the advantages of technology and various office applications and how they can improve work efficiency, outputs, and customer satisfaction.
• Identify and utilize the main parts and features of Microsoft Excel and Microsoft Word.
• Simulate the use of these applications relevant to their own work and the unit’s outputs.
• This training course is designed to provide comprehensive knowledge and hands-on experience with Microsoft 365 applications, empowering participants to enhance their productivity and efficiency in the workplace.
Audience
• Business Professionals
• Office Workers
• Students
• Anyone seeking proficiency in Microsoft 365 applications
Prerequisites
• Basic Computer Skills: Participants should have a fundamental understanding of computer operation, including keyboard and mouse proficiency.
• Access to a Computer: Access to a computer with Microsoft 365 (Office 365) applications installed or access to an online Microsoft 365 subscription is required for hands-on practice during the training.
• No Prior Microsoft 365 Experience Required: This course is suitable for beginners, and no previous experience with Microsoft 365 applications is necessary.
• Desire to Learn: Enthusiasm and a willingness to learn about Microsoft 365 applications are essential, as this course requires active participation and engagement.
Course Content
Module 1: Introduction to Microsoft 365 (1 Hour)
• Understanding the Advantages of Technology in Office Applications
• Overview of Microsoft 365 Suite
• Navigating Microsoft 365 Interface
Module 2: Microsoft Excel (Beginner) – Spreadsheet Mastery (6 Hours)
Session 2.1: Excel Basics (1 Hour)
• Exploring the Excel Interface
• Creating a New Workbook
• Saving and Opening Workbooks
• Using Excel Templates
Session 2.2: Data Entry and Formatting (1 Hour)
• Entering Data in Cells
• Formatting Text and Numbers
• Applying Cell Styles
• Working with Fonts and Alignment
Session 2.3: Excel Formulas and Functions (2 Hours)
• Introduction to Formulas and Functions
• Performing Basic Calculations
• Using Functions (SUM, AVERAGE, MAX, MIN, etc.)
• Relative and Absolute Cell References
Session 2.4: Data Management and Analysis (2 Hours)
• Sorting and Filtering Data
• Data Validation and Drop-Down Lists
• Conditional Formatting for Data Visualization
• Introduction to PivotTables
Module 3: Microsoft Excel (Advanced) – Data Analysis and Reporting (6 Hours)
Session 3.1: Advanced Functions and Formulas (2 Hours)
• Working with Date and Time Functions
• Advanced Mathematical Functions
• Logical Functions (IF, AND, OR)
• Text Functions for Data Manipulation
Session 3.2: PivotTables and Charts (2 Hours)
• Creating and Customizing PivotTables
• PivotTable Calculations and Slicers
• Data Visualization with Charts (Bar, Pie, Line, etc.)
• Dynamic Charts and Sparklines
Session 3.3: Data Import and Export (1 Hour)
• Importing Data from External Sources (e.g., CSV, Access)
• Data Connection and Refreshing
• Exporting Data to Other Formats (PDF, CSV)
Session 3.4: Database Management (1 Hour)
Introduction to Excel as a Database
Creating and Using Tables
Simple Database Functions (VLOOKUP, HLOOKUP)
Data Validation for Database Integrity
Module 4: Microsoft Word (Beginner/Advanced) – Document Mastery (6 Hours)
Session 4.1: Word Basics (1 Hour)
• Creating and Opening Documents
• Saving and AutoSave Features
• Formatting Text and Paragraphs
• Page Layout and Margins
Session 4.2: Document Editing and Proofreading (2 Hours)
• Copy, Cut, Paste, and Format Painter
• Find and Replace Text
• Spelling and Grammar Check
• Track Changes and Comments
Session 4.3: Document Structure and Formatting (2 Hours)
• Working with Styles and Templates
• Creating Lists and Outlines
• Inserting Headers, Footers, and Page Numbers
• Tables and Columns for Document Layout
Session 4.4: Advanced Word Tools (1 Hour)
• Mail Merge for Personalized Documents
• Protecting Documents with Passwords
• Document Collaboration and Sharing
• Automation with Macros (Introduction)
Module 5: Final Assessment and Certification (1 Hour)
• Review of Key Concepts and Skills
• Assessment Test (Written and Practical)
• Certification Award Ceremony
