(Available both Online & Offline)
Microsoft 365: Word, Excel, Outlook & PowerPoint!
Learn how to create professional documents in Word, analyze data with Excel, manage emails and schedules in Outlook, and design impactful presentations in PowerPoint. Whether you’re a beginner or looking to sharpen your skills, this course will help you work smarter and faster. Join us and unlock the full potential of Microsoft 365!
COURSE OUTLINE
GETTING STARTED WITH MICROSOFT WORD
- Understand the interface of Microsoft word 2021
- Exploring the Word interface: Ribbon, Tabs, and Groups
- Learn how to navigate the Home tab efficiently
- Explore the use of formatting tools in Word
- Learn to apply styles and themes to documents
- Understand the basic features of the clipboard and text alignment
MASTERING INSERT TAB : A COMPREHENSIVE GUIDE
- Learn how to use insert Tab Features with shapes, pictures and Textbox
- Understanding how to add text boxes, shapes, and WordArt
- Explore how to insert tables, headers, and footers
- Work with hyperlinks and bookmarks
- Insert and format page numbers
DESIGN TAB FEATURES WITH THEMES AND COLOURS
- Explore document themes and how to apply them
- Customize documents colours and fonts
- Learn how to use the Watermark and page colour tools
- Format the document background
- Understand how to use the Document Formatting group effectively
REFERENCES TAB FEATURES, CITATION AND BIBLIOGRAPHY
- Learn how to insert and manage citation
- Explore how to create a table of contents
- Use footnotes and endnotes effectively
- Manage captions for images and tables
- Explore references Tab Features, Citation and Bibliography
- Real-world application and activities
INTRODUCTION TO MICROSOFT EXCEL
- Understand the basic interface of Microsoft Excel
- Overview of Excel Interface – The Ribbon, Tabs, and Toolbars
- Get familiar with the structure of a worksheets and workbooks
- Understand how to use Cells, Rows, and Columns
- Starting with a Blank Workbook
- AutoSave and Basic File Management
- Data Entry and Management
- Class Exercise and application
WORKING WITH BASIC FORMULAS AND FUNCTIONS
- Learn how to perform basic arithmetic calculation in Excel
- Applying Basic formatting, adjusting column, width and row Height
- Understand and apply simple functions like SUM, AVERAGE, AND COUNT
- Learn how to reference cells in formulas
- Get familiar with using AUTOFILL for Repeated data entry
ORGANIZING AND FORMATTING DATA
- Learn how to sort and filter data
- Understand how to format data for clarity ( Dates, Numbers, and Text)
- Understand cell referencing in spreadsheets relative referencing and to reference cells in formulas
- Learn how to use basic conditional formatting
- Practice organizing data in tables
- Organizing Data in Tables
- Workbook Protection
- Activities
INTRODUCTION TO MICROSOFT OUTLOOK
- Understand the basic features and functions of Microsoft Outlook
- Learn how to navigate the outlook interface, create and manage email accounts
- Familiarize yourself with Mail, Calendar, Contacts, and Tasks features
Advanced Email Management and Features
- Master email management with advanced features such as rules, filters, and email formatting
- Learn how to manage attachments, signatures, and advanced search functions
- Managing Contacts: Creating, Editing, Importing, Exporting, and Organizing
- Using the people pane: Understanding Detailed Contact Information, profile and communication History
- Calendar and Event Management
- Learn how to effectively use the Outlook Calendar for scheduling meetings, events and appointments
- Understand how to manage recurring events, meeting invitations, and calendar
- Creating and Managing Events in Microsoft 365
- Using the scheduling Assistant
- Class Activities and Application
- Mastering Email Management: A Guide to Efficiency
- Organizing Emails with Folders and Categories
- Leveraging Advanced Email Functions – Email Rules , Filters and email Template and Automatic Replies
- Mastering Attachments, Signatures, and Search
- Activities
INTRODUCTION TO MICROSOFT POWERPOINT
- Mastering the Art of PowerPoint
- Understand the interface and features of Microsoft PowerPoint
- Learn how to create a new presentation
- Understand the concept of slides and layouts
- Learn how to insert and format text
ADDING VISUAL ELEMENTS TO MICROSOFT POWERPOINT
- Learn how to insert images, shapes, and icons
- Understand how to add charts and graphs to slides
- Learn how to insert and format tables
- Explore the use of multimedia (audio / Video)
PRESENTATION TECHNIQUES
- Learn how to apply slide transitions
- Understand how to animate text and objects
- Learn how to use animation pane for advanced control
- Explore timing and automatic transitions for presentations
FINALIZING AND DELIVERING A POWERPOINT PRESENTATION
- Learn how to review and proof a presentation
- Understand how to prepare the presentation for delivery ( Presenter view, Slideshow settings)
- Learn how to print and export a presentation
- Understand how to present effectively using PowerPoint
- Delivering with Confidence