Microsoft Office Skills

Start
April 19, 2021 10:00 am
End
April 24, 2021 2:00 pm
Address
Ikeja, Lagos   View map
Phone
08090546055

5,000.00

Category:

Status

Unlimited tickets

0 Has Sold

1: Getting Started with Microsoft Office Excel

  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help

2: Performing Calculations

  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas and Functions

3: Modifying a Worksheet

  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools

4: Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Topic F: Create and Use Templates

5: Printing Workbooks

  • Preview and Print a Workbook
  • Set Up the Page Layout
  • Configure Headers and Footers

6: Managing Workbooks

  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties

1: Getting Started with Word

  • Navigate in Microsoft Word
  • Create and Save Word Documents
  • Manage Your Workspace
  • Edit Documents
  • Preview and Print Documents
  • Topic F: Customize the Word Environment

2: Formatting Text and Paragraphs

  • Apply Character Formatting
  • Control Paragraph Layout
  • Align Text Using Tabs
  • Display Text in Bulleted or Numbered Lists
  • Apply Borders and Shading

3: Working More Efficiently

  • Make Repetitive Edits
  • Apply Repetitive Formatting
  • Use Styles to Streamline Repetitive Formatting Tasks

4: Managing Lists

  • Sort a List
  • Format a List

5: Adding Tables

  • Insert a Table
  • Modify a Table
  • Format a Table
  • Convert Text to a Table

6: Inserting Graphic Objects

  • Insert Symbols and Special Characters
  • Add Images to a Document

7: Controlling Page Appearance

  • Apply a Page Border and Color
  • Add Headers and Footers
  • Control Page Layout
  • Add a Watermark

8: Preparing to Publish a Document

  • Check Spelling, Grammar, and Readability
  • Use Research Tools
  • Check Accessibility
  • Save a Document to Other Formats

1: Getting Started with PowerPoint

  • Navigate the PowerPoint Environment
  • View and Navigate a Presentation
  • Create and Save a PowerPoint Presentation
  • Use PowerPoint Help

2: Developing a PowerPoint Presentation

  • Select a Presentation Type
  • Edit Text
  • Build a Presentation

3: Performing Advanced Text Editing Operations

  • Format Characters
  • Format Paragraphs
  • Format Text Boxes

4: Adding Graphical Elements to Your Presentation

  • Insert Images
  • Insert Shapes

5: Modifying Objects in Your Presentation

  • Edit Objects
  • Format Objects
  • Group Objects
  • Arrange Objects
  • Animate Objects

6: Adding Tables to Your Presentation

  • Create a Table
  • Format a Table
  • Insert a Table from Other Microsoft Office Applications

7: Adding Charts to Your Presentation

  • Create a Chart
  • Format a Chart
  • Insert a Chart from Microsoft Excel

8: Preparing to Deliver Your Presentation

  • Review Your Presentation
  • Apply Transitions
  • Print Your Presentation

 

 

Part One

Session 1: Introduction to Outlook 2016

  • Introduction
  • Using Setup Wizard to set up a Primary E-mail Account
  • Different Types of E-mail Accounts
  • Adding an Additional Email Account
  • Create Additional Outlook Profiles
  • View the Outlook Workspace

Session 2: Customising Outlook

  • Introduction
  • Organize the Workspace
  • Add and Remove Toolbar Buttons
  • Customizing Settings

Session 3: Outlook Interface      

  • Introduction
  • Navigating Outlook
  • Information and Reading Panes
  • To-Do Bar

Session 4: Creating E-mail            

  • Introduction
  • Creating Messages
  • Addressing the Message
  • E-mail Options
  • Delivery Options

Session 5: Setting E-mail Defaults            

  • Introduction
  • E-mail Settings
  • Mail Format
  • Themes and Fonts
  • Creating E-mail Signatures
  • Creating Multiple Signatures

Session 6: E-mail Extras

  • Introduction
  • Formatting
  • Voting Buttons
  • Attachments
  • Importance and Sensitivity
  • Spell Check
  • Saving a Draft

Session 7: Receiving E-mail         

  • Introduction
  • Replying to Messages
  • Forwarding Messages
  • Receiving Attachments
  • Sent Items
  • Recall and Resend Messages
  • Voting
  • Vote Tally

Session 8: Hyperlinks and Quick Parts    

  • Introduction
  • Using Hyperlinks
  • Bookmark Hyperlinks
  • Using Quick Parts

Part Two

Session 9: Configuring Outlook 

  • Introduction
  • Creating Rules and Storing Messages
  • Advanced E-mail Options
  • Record Information in the Journal

Session 10: Securing E-mail         

  • Introduction
  • Digital Signatures
  • Encrypting Messages
  • The Trust Center

Session 11: Changing Views        

  • Introduction
  • Sorting
  • Fields
  • Customizing Views

Session 12: Organizing Information         

  • Introduction
  • Organizing with Categories
  • Quick Click
  • Organizing with Flags
  • Custom Flags

Session 13:  Sharing Information              

  • Introduction
  • Share Folders (Contacts, Email, Tasks etc)
  • Access Shared Folders

Session 14: Customizing Folders               

  • Introduction
  • Folder Settings
  • Deleting Items
  • Creating Folders
  • Organizing Folders
  • Recover Deleted Items
  • Saving in Different File Types
  • Creating a Personal Folder Set
  • Personal Folder Properties

Session 15: Rules and Alerts       

  • Introduction
  • Automated Features
  • Rules
  • Alerts
  • Ordering Rules

Session 16: Archiving     

  • Introduction
  • Activating Archiving
  • Auto Archive Settings
  • Manual Archiving

Session 17: Searching    

  • Introduction
  • Search Options
  • Simple Searches
  • Query Searches
  • Using Search Folders
  • Category Searches
  • Custom Search Folders

Part Three

Session 18: Contact Basics           

  • Introduction
  • Creating Contacts
  • Modifying Contacts
  • Adding Contacts
  • Contact Views

Session 19: Advanced Contacts 

  • Introduction
  • Business Card Options
  • Distribution Lists
  • Secondary Address Books

Session 20: Calendars and Scheduling    

  • Introduction
  • Calendar Views and Entries
  • Creating Appointments
  • Creating Events
  • Recurring Events
  • Creating Events from E-mail

Session 21: Calendar Defaults and Permissions  

  • Introduction
  • Calendar Settings
  • Assigning Delegate Permissions
  • Viewing Other People's Calendars

Session 22: Collaboration             

  • Introduction
  • Group Calendars
  • Send a Calendar via E-mail
  • Publish Calendars Online

Session 23: Meetings    

  • Introduction
  • Scheduling Meetings
  • Responding to Requests
  • Tracking Responses
  • Recurring Meetings
  • Proposing New Meeting Times

Session 24: Tasks and Journal    

  • Introduction
  • Creating Tasks
  • Assigning Tasks
  • Recurring Tasks
  • Responding to Assigned Tasks
  • Task Views
  • Tracking with the Journal

Session 25: Working with Notes

  • Introduction
  • Record Information in Notes
  • Sharing and Saving Notes
  • Link to a Note

Session 26: Working with Remote Connections 

  • Introduction
  • Connect to a Server from a Remote Location
  • Cached Exchange Mode
  • View Contacts While Offline
  • Configure the Out of Office Functionality