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