Mastering Microsoft Office Suite: Essential Skills for Productivity
Introduction to Microsoft Office Suite
Word Processing with Microsoft Word
Spreadsheet Management with Microsoft Excel
Presentation Design with Microsoft PowerPoint
Email Management with Microsoft Outlook
What you will learn
After completing this course, a trainee will be able to:
Schedule and Fee
Category: Information Technology
Duration: 06 Weeks / 12 Classes
Delivery Method: Online
Schedule:
Starting Date: April 27, 2024
Saturday - 11:00 AM to 01:00 PM
Sunday - 11:00 AM to 01:00 PM
Application Deadline:
April 19, 2024
Course Fee:
Regular Fee: PKR 8,000
Ramadan Offer: PKR 4,000 (Deadline April 10, 2024)
Details Outline of MS Office
Microsoft Office Word (Basic to Intermediate)
Microsoft Office Excel (Basic to Intermediate)
Microsoft Office PowerPoint (Basic to Intermediate)
Microsoft Office Outlook (Basics)
Microsoft Word
Getting Started
Introduction to Microsoft Office New Interface
Introduction to Microsoft Word
Working with Different Views
Understanding Ribbon & its parts
Getting Started
Creating New Documents
Essential Skills
Autocorrect & AutoComplete
Find & Replace Commands
AutoText Command
Character Formatting
Symbols & Special Characters
Paragraph Formatting
Tabs
Indents
Special Spacing
Bullets, Numbering, & Line Breaks
Sorting Text
Borders & Shading
Format Painter
Document Formatting
Margins & Paper Size
Controlling Page Breaks
Inserting page numbers
Inserting Cover page
Working with Long Documents
Numbering Pages
Headers & Footers
Using Sections
Using Columns
Using Graphics within Word
Inserting Graphics
Manipulating Graphics
Inserting Picture
Inserting Text Box
Using Smart Art Utility
Tables
Creating Tables
Navigating and Modifying
Formatting A Table
Automatic Formatting and Styles
Applying Styles
Creating Your Styles
Modifying Existing Styles
Deleting Styles
Document Templates
Personalizing Word's Templates
Creating Your Templates
Automating With Field Codes
Mail Merge
Proofing Documents
Spelling & Grammar
Thesaurus
Printing & Previewing Documents
Previewing a Document
Printing a Document
Microsoft Excel
Introduction
Introduction to Microsoft Excel
Screen Constituents
Creating Excel Workbooks
Creating, saving and closing Excel workbooks
Entering Formulas & Functions
Opening saved workbooks
Printing & Previewing
Viewing options
Printing excel worksheets
Editing Worksheets
Navigating through Microsoft Excel
Selecting, moving & copying cells
Using the filling utility of Excel
Using AutoSum Button
Inserting and deleting Columns & Rows
Tips and Tricks to EXCELerate the work
Advanced Formula & Functions
Introduction to Formulas & Functions
Operators, Arguments & Expressions
Constants, Addresses / Cell References
Cell Referencing; Absolute / Relative Referencing
Using 3D references
Operator Precedence
Understanding Formula Errors
Using Range Names
Working with Functions
Mathematical Functions
Date / Time Functions
Text
Logical
Statistical Functions (SumIFs / CountIFs)
Choose
VLookup
HLookup
Consolidation
Using the Auto Consolidation Option of Excel
Applying Security to Files, Workbooks & Worksheets
Saving Files
Save as type, Password
Workbook Password Protection
Cell Protection
Worksheet Protection
What Are Shared Workbooks?
Database and list management
Using Quick Filters
Using Advanced Filters
Pivot Table
Creating a Pivot Table
Formatting a Pivot Table
Sorting Filtering Pivot Tables
Adding Removing Fields from Pivot Tables
Applying different styles to Pivot Table Fields
Creating Pivot Charts
Working with Charts
Basic Chart Types
When to use which Chart
Line Chart
Column / Bar Chart
Pie Chart
X / Y or Scatter Chart
Common Requirements When Using Charts
Conclusion
Microsoft PowerPoint
Introduction to PowerPoint
Introduction to PowerPoint
What’s new in PowerPoint
Starting PowerPoint
Introduction to the Ribbon Brief Intro to the features of different tabs within the Ribbon
Working with Office Button
PowerPoint Fundamentals
Creating a new Presentation with Different Options
Working with Clipboard; Cut, Copy & Paste
Inserting Clipart
Working with Different Slide Layouts
Working with Different Slide Themes
Slide Transitions and Animations
Navigation & Control
Roaming around the presentations with Different Views
Slide Sorter View
Normal View
Outline View
Notes & Handouts View
Slide Shows
Viewing the Slide Show
Slide Show View Introduction
Slide Show Menu
Using the Pen Pointer
Ending the Show
PowerPoint’s Special Object
Working with Smart Art
Image Processing
Rotating
Cropping
Adding Sound to Your Presentation
Adding Sound to A Presentation
Taking the Confusion Out Of Sound Files
Creating a .WAV File That Can Be Inserted Into A Slide
Working with Sound Files
Sound Options and Setup
Kiosk Sound Setup
Making A Sound File
Animation & Movies
Adding Animations
Inserting Animated GIFs
Inserting Movies
Adding Hyperlinks and Action Buttons
What are hyperlinks
How to use hyperlinks
What are action buttons
How to use action buttons
Hiding Slides / Using Hyperlinks to Visit Hidden Slides
Working with Master Slide
Creating a Master Slide
Using Multiple Master Slides
The Final Touch
Inserting Separator Slides
Changing Background Color / Design of Single Slide
Proofing & Spell Checking of Slides
Speaker Notes and Handouts
Printing & Previewing
Viewing options
Printing presentation
Delivering Presentations
Microsoft Outlook
Introduction to the Interface
Introduction to Microsoft Outlook
Screen Constituents
Folder, Shortcuts & the Outlook Today
Sending / Receiving & Viewing Messages
Different display options for Messages
Replying a message
Forwarding a message
Sorting & Filtering Messages
Organizing Messages into Folders
Printing Options for Messages
Working with Address Book
Composing & Sending New Messages
Deleting Messages
Introduction to Contacts
Modifying and Creating Contacts
Categorizing Contacts
Deleting a Contact
Sending Business Card
Printing Contacts
Sorting / Filtering Contacts
Introduction to Outlook Tasks & Calendar
Working with different views Daily, Weekly & Monthly
Creating an Appointment Or Event
Editing Appointments & Events
Copying, Moving & Deleting appointments
Scheduling Multi-Day Events
Creating Recurring Appointments
Turning An Email Message Into An Appointment
Printing Calendar & Setting Print Options
Extra Features
Applying Rules
Signature
Delivery Receipts