Topic outline

• How to join the Interactive Live Session?

  Collapse all Expand all

  Once you've entered the required information, click on the link below (visible after registration) & "Join" or "Enter" button. This will take you to the virtual meeting room. "Join Session" button will appear when session starts. 
  

• Module 1: Introduction to Microsoft Office

  • Introduction to Microsoft Office Suite
  • Overview of Word, Excel, and PowerPoint
  • Getting Started with Word
  • Creating and formatting text documents
  • Basic Formatting in Word
  • Applying styles, fonts, and formatting options

  
  

• Module 2: Essential Word Skills

  • Working with Tables and Images in Word
  • Inserting tables, images, and basic formatting
  • Page Layout and Printing in Word
  • Setting up page layout, headers, footers, and printing options
  • Review and Collaboration Tools in Word
  • Track changes, comments, and sharing documents

  
  

• Module 3: Introduction to Excel

  • Introduction to Excel Interface
  • Overview of Excel interface, ribbon, and basic navigation
  • Creating and Editing Worksheets
  • Entering data, basic formulas, and editing techniques
  • Formatting Data and Cells
  • Formatting cells, rows, and columns

  
  

• Module 4: Working with Formulas and Functions

  • Basic Formulas and Functions
  • Introduction to SUM, AVERAGE, MAX, MIN functions
  • Absolute and Relative Cell References
  • Understanding and using absolute and relative references
  • Logical Functions and IF Statements
  • Introduction to IF, AND, OR functions

  
  

• Module 5: Data Analysis in Excel

  • Sorting and Filtering Data
  • Sorting and filtering techniques
  • Introduction to Charts and Graphs
  • Creating basic charts and customizing chart elements
  • PivotTables and Pivot Charts
  • Introduction to PivotTables and Pivot Charts

  
  

• Module 6: Advanced Excel Features

  • Conditional Formatting
  • Applying conditional formatting rules
  • Data Validation and Protection
  • Setting data validation rules and protecting worksheets
  • Collaboration and Review Tools
  • Sharing workbooks, tracking changes, and comments

  
  

• Module 7: Mid-Term Exam

• Module 8: Introduction to PowerPoint

  • Getting Started with PowerPoint
  • Overview of PowerPoint interface and basic navigation
  • Creating and Formatting Slides
  • Adding slides, formatting text, and backgrounds
  • Inserting Images and Media
  • Adding images, videos, and audio to slides

  
  

• Module 9: Working with Slide Elements

  • Using SmartArt and Shapes
  • Creating diagrams and shapes
  • Slide Transitions and Animations
  • Adding transitions and animations to slides
  • Slide Master and Layouts
  • Customizing slide master and layouts

  
  

• Module 10: Finalizing and Delivering Presentations

  • Proofing and Finalizing Presentations
  • Spell check, review tools, and finalizing presentations
  • Rehearsing and Delivering Presentations
  • Rehearsing timings, presenting slides, and audience interaction
  • Printing and Sharing Presentations
  • Printing options, saving presentations, and sharing online

  
  

• Module 11: Outlook Basics

  • Introduction to Outlook Interface
  • Overview of Outlook interface, navigation, and email basics
  • Managing Email in Outlook
  • Composing, sending, and organizing emails
  • Contacts and Calendar in Outlook
  • Managing contacts and appointments

  
  

• Module 12: Outlook Advanced Features

  • Managing Tasks and Notes
  • Creating and organizing tasks and notes
  • Rules and Automation in Outlook
  • Setting up rules, filters, and automatic responses
  • Collaboration and Integration with Outlook
  • Sharing calendars, delegating tasks, and integrating with other Office apps

  
  

• Module 13: Review and Practice

  • Review and Practice Sessions
  • Recap of all modules, Q&A sessions, and hands-on practice

  
  

• Module 14: Final Exam