Microsoft Excel app-logoMicrosoft Excel

  • Microsoft Excel – Beginner

    1. Getting started with Microsoft Office Excel navigation
      • Learn Your Way Around the Excel Menu
      • Understand and Apply Excel Formulas
      • Create and Save a Basic Workbook
      • Enter Data Into Cells
      • Access Excel Help
    2. Performing calculations
      • Build Custom Worksheet Formulas
      • Insert Built-In Functions to Your Data
      • Save and Reuse Formulas
    3. Modifying a worksheet
      • Insert, Delete and Resize Cells, Columns and Rows
      • Search for and Replace Data
      • Use Proofing and Research Tools
    4. Formatting a worksheet
      • Format Text and Numbers
      • Align Cell Data
      • Apply Styles, Themes and Basic and Conditional Formatting
      • Create and Select Worksheet Templates
    5. Printing workbooks
      • Preview and Print a Workbook
      • Set Up the Page Layout
      • Configure Headers and Footers
    6. Managing workbooks
      • Manage Worksheets and Workbook Properties
      • Create, Apply or Delete Workbook and Worksheet Views
  • Microsoft Excel – Intermediate

    1. Working with functions
      • Define Cell Ranges and Reference Them in Formulas
      • Perform Conditional Calculations
      • Carry Out Logical and Specialized Functions
      • Work with Date and Time Functions
      • Understand and Execute Text Functions
    2. Working with lists
      • Sort and Filter Data
      • Learn the Capabilities of Database Functions
      • Query Data with Database Functions
      • Outline and Subtotal Data
    3. Analyzing data
      • Build and Modify Tables
      • Create Formatting Rules
      • Apply Conditional Formatting to Alter Groups of Cells
    4. Visualizing data with charts
      • Organize and Represent Data with Charts
      • Modify and Format Charts
      • Discover and Implement Advanced Chart Features
    5. Analyzing data with PivotTables and PivotCharts
      • Create a PivotTable
      • Analyze PivotTable Data
      • Present Data with PivotCharts
      • Filter Data Using Timelines and Slicers
  • Microsoft Excel – Advanced

    1. Working with multiple worksheets & workbooks
      • Reference Cells and Groups of Cells Across Worksheets
      • Link Cells to External Worksheets
      • Consolidate Data Across Worksheets
    2. Using lookup formulas and formula auditing
      • Search Rows or Columns Using LOOKUP Functions
      • Display Relationships Between Cells and Formulas with the Trace Command
      • Watch Cells and Formulas From the Watch Tool
    3. Sharing and protecting workbooks
      • Collaborate on Workbooks
      • Apply Varying Levels of Workbook Access and Protections
    4. Automating workbook functionality
      • Create and Manage Validation Rules and Lists
      • Search for Invalid Data and Formulas with Errors
      • Record Macros to Automate Tasks
    5. Creating Sparklines and mapping data
      • Create Sparklines to Show Trends
      • Map Data
    6. Forecasting data
      • Determine Potential Outcomes Using Data Tables and Scenarios
      • Solve for Desired Outputs with the Goal Seek Feature
      • Forecast Data Trends

Microsoft PowerPoint app-logoMicrosoft PowerPoint

  • Microsoft PowerPoint – Beginner

    1. Getting started with PowerPoint
      • Topic A: Navigate the PowerPoint Environment
      • Topic B: View and Navigate a Presentation
      • Topic C: Create and Save a Basic Presentation
      • Topic D: Navigate in PowerPoint for the Web
      • Topic E: Use PowerPoint Help
    2. Developing a PowerPoint presentation
      • Topic A: Create Presentations
      • Topic B: Edit Text
      • Topic C: Work with Slides
      • Topic D: Design a Presentation
    3. Formatting text
      • Topic A: Format Characters
      • Topic B: Format Paragraphs
    4. Adding and arranging graphical elements
      • Topic A: Insert Images
      • Topic B: Insert Shapes
      • Topic C: Create SmartArt
      • Topic D: Insert Icons and 3D Models
      • Topic E: Size, Group, and Arrange Objects
    5. Modifying graphical elements
      • Topic A: Format Images
      • Topic B: Format Shapes
      • Topic C: Customize SmartArt
      • Topic D: Format Icons
      • Topic E: Format 3D Models
      • Topic F: Animate Objects
    6. Preparing to deliver your presentation
      • Topic A: Review Your Presentation
      • Topic B: Apply Transitions
      • Topic C: Print or Export a Presentation
      • Topic D: Deliver Your Presentation
  • Microsoft PowerPoint – Advanced

    1. Customizing design templates
      • Topic A: Modify Slide Masters and Slide Layouts
      • Topic B: Modify the Notes Master and the Handout Master
      • Topic C: Add Headers and Footers
    2. Adding tables
      • Topic A: Create a Table
      • Topic B: Format a Table
      • Topic C: Insert a Table from Other Microsoft Office Applications
    3. Adding charts
      • Topic A: Create a Chart
      • Topic B: Format a Chart
      • Topic C: Insert a Chart from Microsoft Excel
    4. Working with media
      • Topic A: Add Audio to a Presentation
      • Topic B: Add Video to a Presentation
      • Topic C: Add a Screen Recording
    5. Building advanced transitions and animations
      • Topic A: Use the Morph Transition
      • Topic B: Customize Animations
    6. Collaborating on a presentation
      • Topic A: Review a Presentation
      • Topic B: Co-author a Presentation
    7. Customizing presentation delivery
      • Topic A: Enhance a Live Presentation
      • Topic B: Record a Presentation
      • Topic C: Set Up a Slide Show
    8. Modifying presentation navigation
      • Topic A: Divide a Presentation into Sections
      • Topic B: Add Links
      • Topic C: Create a Custom Slide Show
    9. Securing and distributing a presentation
      • Topic A: Secure a Presentation
      • Topic B: Create a Video or a CD
Bloomington Microsoft Training

Microsoft Word app-logoMicrosoft Word

  • Microsoft Word – Beginner

    1. Getting started with Word
      • Topic A: Navigate in Microsoft Word
      • Topic B: Create and Save Word Documents
      • Topic C: Manage Your Workspace
      • Topic D: Edit Documents
      • Topic E: Preview and Print Documents
      • Topic F: Customize the Word Environment
    2. Formatting text and paragraphs
      • Topic A: Apply Character Formatting
      • Topic B: Control Paragraph Layout
      • Topic C: Align Text Using Tabs
      • Topic D: Display Text in Bulleted or Numbered Lists
      • Topic E: Apply Borders and Shading
    3. Working more efficiently
      • Topic A: Make Repetitive Edits
      • Topic B: Apply Repetitive Formatting
      • Topic C: Use Styles to Streamline Repetitive Formatting Tasks
    4. Managing lists
      • Topic A: Sort a List
      • Topic B: Format a List
    5. Adding tables
      • Topic A: Insert a Table
      • Topic B: Modify a Table
      • Topic C: Format a Table
      • Topic D: Convert Text to a Table
    6. Inserting graphic objects
      • Topic A: Insert Symbols and Special Characters
      • Topic B: Add Images to a Document
    7. Controlling page appearance
      • Topic A: Apply a Page Border and Color
      • Topic B: Add Headers and Footers
      • Topic C: Control Page Layout
      • Topic D: Add a Watermark
    8. Preparing to publish a document
      • Topic A: Check Spelling, Grammar, and Readability
      • Topic B: Use Research Tools
      • Topic C: Check Accessibility
      • Topic D: Save a Document to Other Formats
  • Microsoft Word – Intermediate

    1. Organizing content using tables and charts
      • Topic A: Sort Table Data
      • Topic B: Control Cell Layout
      • Topic C: Perform Calculations in a Table
      • Topic D: Create a Chart
      • Topic E: Add an Excel Table to a Word Document (Optional)
    2. customizing formats using styles and themes
      • Topic A: Create and Modify Text Styles
      • Topic B: Create Custom List or Table Styles
      • Topic C: Apply Document Themes
    3. Inserting content using quick parts
      • Topic A: Insert Building Blocks
      • Topic B: Create and Modify Building Blocks
      • Topic C: Insert Fields Using Quick Parts
    4. Using templates to automate document formatting
      • Topic A: Create a Document Using a Template
      • Topic B: Create a Template
      • Topic C: Manage Templates with the Template Organizer
    5. Controlling the flow of a document
      • Topic A: Control Paragraph Flow
      • Topic B: Insert Section Breaks
      • Topic C: Insert Columns
      • Topic D: Link Text Boxes to Control Text Flow
    6. Simplifying and managing long documents
      • Topic A: Insert Blank and Cover Pages
      • Topic B: Insert an Index
      • Topic C: Insert a Table of Contents
      • Topic D: Insert an Ancillary Table
      • Topic E: Manage Outlines
      • Topic F: Create a Master Document
    7. Using mail merge to create letters, envelopes, and labels
      • Topic A: The Mail Merge Feature
      • Topic B: Merge Envelopes and Labels
  • Microsoft Word – Advanced

    1. Manipulating images
      • Topic A: Integrate Pictures and Text
      • Topic B: Adjust Image Appearance
      • Topic C: Insert Other Media Elements
    2. Using custom graphic elements
      • Topic A: Create Text Boxes and Pull Quotes
      • Topic B: Add WordArt and Other Text Effects
      • Topic C: Draw Shapes
      • Topic D: Create Complex Illustrations with SmartArt
    3. Collaborating on documents
      • Topic A: Prepare a Document for Collaboration
      • Topic B: Mark Up a Document
      • Topic C: Review Markups
      • Topic D: Merge Changes from Other Documents
    4. Adding document references & links
      • Topic A: Add Captions
      • Topic B: Add Cross-References
      • Topic C: Add Bookmarks
      • Topic D: Add Hyperlinks
      • Topic E: Insert Footnotes and Endnotes
      • Topic F: Add Citations and a Bibliography
    5. Securing a document
      • Topic A: Suppress Information
      • Topic B: Set Formatting and Editing Restrictions
      • Topic C: Restrict Document Access
      • Topic D: Add a Digital Signature to a Document
    6. Using forms to manage content
      • Topic A: Create Forms
      • Topic B: Modify Forms
    7. Automating repetitive tasks with macros
      • Topic A: Automate Tasks by Using Macros
      • Topic B: Create a Macro

Microsoft OneNote app-logoMicrosoft OneNote

  1. Getting started with OneNote
    • Topic A: Navigate the OneNote 2016 Environment
    • Topic B: Use Templates
    • Topic C: Customize the OneNote User Interface
  2. Adding and formatting notebook content
    • Topic A: Apply Formatting to Notebook Content
    • Topic B: Insert Images and Audio into a Notebook
    • Topic C: Add Quick Notes and Links
    • Topic D: Use Drawing Tools
  3. Embedding and attaching files
    • Topic A: Embed Excel Spreadsheets
    • Topic B: Attach Other File Types
  4. Organizing and searching notebooks
    • Topic A: Use Tags
    • Topic B: Organize and Search Notebooks
  5. Finalizing a notebook
    • Topic A: Proof and Print a Notebook
    • Topic B: Configure Password Protection and Notebook Properties
  6. Managing notebook files
    • Topic A: Export Content from OneNote Notebooks
    • Topic B: Back Up and Restore Notebook Content
  7. Sending and sharing OneNote content
    • Topic A: Send OneNote Content in Other Formats
    • Topic B: Share OneNote Content by Using OneDrive

Microsoft Publisher app-logoMicrosoft Publisher

  1. Getting started with Microsoft Publisher
    • Topic A: Navigate the Interface
    • Topic B: Customize the Publisher Interface
    • Topic C: Create a Publication
  2. Adding content to a publication
    • Topic A: Add Text to a Publication
    • Topic B: Add Pages and Picture Placeholders to a Publication
    • Topic C: Control the Display of Content in Text Boxes
    • Topic D: Apply Building Blocks to a Publication
  3. Formatting text and paragraphs in a publication
    • Topic A: Format Text
    • Topic B: Format Paragraphs
    • Topic C: Apply Schemes
  4. Managing text in a publication
    • Topic A: Edit Text in a Publication
    • Topic B: Work with Tables
    • Topic C: Insert Symbols and Special Characters
  5. Working with graphics in a publication
    • Topic A: Insert Graphics in a Publication
    • Topic B: Customize the Appearance of Pictures
  6. Preparing a publication for sharing and printing
    • Topic A: Check the Design of a Publication
    • Topic B: Save a Publication in Different Formats
    • Topic C: Print a Publication
    • Topic D: Share a Publication