Microsoft Office

microsoft excel with edtechhub

Microsoft Office PowerPoint, Word, and Excel

This comprehensive 12-hour workshop series is designed to equip participants with essential skills in Microsoft Office applications – PowerPoint, Word, and Excel. Each application will be explored thoroughly, covering basic functionalities, advanced features, and practical applications in professional settings. Through a combination of lectures, hands-on exercises, and real-world examples, participants will gain proficiency in creating, formatting, collaborating, and finalizing documents, presentations, and spreadsheets using Microsoft Office.

Eng. Fadi Sleiman

Objectives:

  1. PowerPoint Basics and Design Principles (4 hours):
    • Introduce participants to PowerPoint and teach basic creation, formatting, and design principles.
    • Provide an overview of the PowerPoint interface and navigation.
    • Familiarize participants with fundamental design principles for creating visually appealing presentations.
  1. Microsoft Word Basics and Document Organization (4 hours):
    • Cover the basics of creating, formatting, organizing, and citing in Microsoft Word.
    • Guide participants through essential Word functionalities such as text formatting, inserting images, and organizing content.
    • Teach participants how to effectively organize documents using headings, lists, and tables, and how to add citations and references.
  1. Advanced Formatting, Collaboration, and Finalizing in Microsoft Word (4 hours):
    • Cover advanced formatting techniques including styles, templates, and advanced formatting tools.
    • Demonstrate collaboration features such as tracking changes and co-authoring documents with colleagues.
    • Provide guidance on finalizing documents, including proofreading, formatting for consistency, and preparing for distribution.
  1. Excel Basics and Data Management (4 hours):
    • Introduce participants to Excel, focusing on data entry, basic formatting, and data management.
    • Cover basic Excel functionalities such as entering data, formatting cells, and managing worksheets.
  1. Advanced Formulas and Functions in Microsoft Excel (4 hours):
    • Cover advanced formulas and functions for data analysis and manipulation.
    • Teach logical functions (IF, AND, OR), lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH), statistical functions (SUMIF, COUNTIF, AVERAGEIF), and date and time functions.
    • Explore data analysis techniques, pivot tables, and data visualization to extract insights from data.