Microsoft Excel
-
Microsoft Excel – Beginner
- 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
- Performing calculations
- Build Custom Worksheet Formulas
- Insert Built-In Functions to Your Data
- Save and Reuse Formulas
- Modifying a worksheet
- Insert, Delete and Resize Cells, Columns and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
- Formatting a worksheet
- Format Text and Numbers
- Align Cell Data
- Apply Styles, Themes and Basic and Conditional Formatting
- Create and Select Worksheet Templates
- Printing workbooks
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
- Managing workbooks
- Manage Worksheets and Workbook Properties
- Create, Apply or Delete Workbook and Worksheet Views
- Getting started with Microsoft Office Excel navigation
-
Microsoft Excel – Intermediate
- 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
- Working with lists
- Sort and Filter Data
- Learn the Capabilities of Database Functions
- Query Data with Database Functions
- Outline and Subtotal Data
- Analyzing data
- Build and Modify Tables
- Create Formatting Rules
- Apply Conditional Formatting to Alter Groups of Cells
- Visualizing data with charts
- Organize and Represent Data with Charts
- Modify and Format Charts
- Discover and Implement Advanced Chart Features
- Analyzing data with PivotTables and PivotCharts
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data Using Timelines and Slicers
- Working with functions
-
Microsoft Excel – Advanced
- Working with multiple worksheets & workbooks
- Reference Cells and Groups of Cells Across Worksheets
- Link Cells to External Worksheets
- Consolidate Data Across Worksheets
- 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
- Sharing and protecting workbooks
- Collaborate on Workbooks
- Apply Varying Levels of Workbook Access and Protections
- Automating workbook functionality
- Create and Manage Validation Rules and Lists
- Search for Invalid Data and Formulas with Errors
- Record Macros to Automate Tasks
- Creating Sparklines and mapping data
- Create Sparklines to Show Trends
- Map Data
- Forecasting data
- Determine Potential Outcomes Using Data Tables and Scenarios
- Solve for Desired Outputs with the Goal Seek Feature
- Forecast Data Trends
- Working with multiple worksheets & workbooks
Microsoft PowerPoint
-
Microsoft PowerPoint – Beginner
- 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
- Developing a PowerPoint presentation
- Topic A: Create Presentations
- Topic B: Edit Text
- Topic C: Work with Slides
- Topic D: Design a Presentation
- Formatting text
- Topic A: Format Characters
- Topic B: Format Paragraphs
- 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
- 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
- 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
- Getting started with PowerPoint
-
Microsoft PowerPoint – Advanced
- 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
- Adding tables
- Topic A: Create a Table
- Topic B: Format a Table
- Topic C: Insert a Table from Other Microsoft Office Applications
- Adding charts
- Topic A: Create a Chart
- Topic B: Format a Chart
- Topic C: Insert a Chart from Microsoft Excel
- Working with media
- Topic A: Add Audio to a Presentation
- Topic B: Add Video to a Presentation
- Topic C: Add a Screen Recording
- Building advanced transitions and animations
- Topic A: Use the Morph Transition
- Topic B: Customize Animations
- Collaborating on a presentation
- Topic A: Review a Presentation
- Topic B: Co-author a Presentation
- Customizing presentation delivery
- Topic A: Enhance a Live Presentation
- Topic B: Record a Presentation
- Topic C: Set Up a Slide Show
- Modifying presentation navigation
- Topic A: Divide a Presentation into Sections
- Topic B: Add Links
- Topic C: Create a Custom Slide Show
- Securing and distributing a presentation
- Topic A: Secure a Presentation
- Topic B: Create a Video or a CD
- Customizing design templates
![Bloomington Microsoft Training Bloomington Microsoft Training](https://develefy.com/wp-content/uploads/2022/06/Bloomington-Microsoft-Training.jpg)
Microsoft Word
-
Microsoft Word – Beginner
- 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
- 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
- Working more efficiently
- Topic A: Make Repetitive Edits
- Topic B: Apply Repetitive Formatting
- Topic C: Use Styles to Streamline Repetitive Formatting Tasks
- Managing lists
- Topic A: Sort a List
- Topic B: Format a List
- Adding tables
- Topic A: Insert a Table
- Topic B: Modify a Table
- Topic C: Format a Table
- Topic D: Convert Text to a Table
- Inserting graphic objects
- Topic A: Insert Symbols and Special Characters
- Topic B: Add Images to a Document
- 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
- 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
- Getting started with Word
-
Microsoft Word – Intermediate
- 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)
- 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
- Inserting content using quick parts
- Topic A: Insert Building Blocks
- Topic B: Create and Modify Building Blocks
- Topic C: Insert Fields Using Quick Parts
- 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
- 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
- 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
- Using mail merge to create letters, envelopes, and labels
- Topic A: The Mail Merge Feature
- Topic B: Merge Envelopes and Labels
- Organizing content using tables and charts
-
Microsoft Word – Advanced
- Manipulating images
- Topic A: Integrate Pictures and Text
- Topic B: Adjust Image Appearance
- Topic C: Insert Other Media Elements
- 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
- 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
- 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
- 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
- Using forms to manage content
- Topic A: Create Forms
- Topic B: Modify Forms
- Automating repetitive tasks with macros
- Topic A: Automate Tasks by Using Macros
- Topic B: Create a Macro
- Manipulating images
Microsoft OneNote
- Getting started with OneNote
- Topic A: Navigate the OneNote 2016 Environment
- Topic B: Use Templates
- Topic C: Customize the OneNote User Interface
- 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
- Embedding and attaching files
- Topic A: Embed Excel Spreadsheets
- Topic B: Attach Other File Types
- Organizing and searching notebooks
- Topic A: Use Tags
- Topic B: Organize and Search Notebooks
- Finalizing a notebook
- Topic A: Proof and Print a Notebook
- Topic B: Configure Password Protection and Notebook Properties
- Managing notebook files
- Topic A: Export Content from OneNote Notebooks
- Topic B: Back Up and Restore Notebook Content
- Sending and sharing OneNote content
- Topic A: Send OneNote Content in Other Formats
- Topic B: Share OneNote Content by Using OneDrive
Microsoft Publisher
- Getting started with Microsoft Publisher
- Topic A: Navigate the Interface
- Topic B: Customize the Publisher Interface
- Topic C: Create a Publication
- 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
- Formatting text and paragraphs in a publication
- Topic A: Format Text
- Topic B: Format Paragraphs
- Topic C: Apply Schemes
- Managing text in a publication
- Topic A: Edit Text in a Publication
- Topic B: Work with Tables
- Topic C: Insert Symbols and Special Characters
- Working with graphics in a publication
- Topic A: Insert Graphics in a Publication
- Topic B: Customize the Appearance of Pictures
- 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