Office 365 Training

Live Chat: Offline

Excel Tutorials

We offer a comprehensive Office 365 Training platform that includes more than 400 courses and videos specifically designed to ensure you're maximizing the power of Excel across your organization.

Start your FREE 7-day trial now

Microsoft Excel is one of the most popular Office apps in existence. It’s a spreadsheet tool used by millions of businesses around the world to track key metrics using graphing tools, pivot tables, and much more. While Microsoft Excel is extremely powerful, it can be a bit complicated to understand and master.

At MessageOps, we’ve included a robust set of Microsoft Excel training courses in our Office 365 Training suite. These courses cover everything from a basic understanding of Excel to much more complex concepts that can allow you to easily transform data into actionable insights within your company.

Training Options

MessageOps provides all of its training materials in a variety of different styles and methods to ensure everyone has access to this incredibly useful material.

  • microsoft excel training

    Live Training

    Certified Office 365 instructors who conduct regular training sessions accessible through our online portal.

  • microsoft excel tutorials

    24/7 On Demand Access

    Instant access to more than 500 Microsoft Excel training videos that allow your team members to work at their own pace.

  • how to use excel

    Gamification

    Employees can compete against each other and learn new concepts at the same time with built-in gamification tools.

  • microsoft excel tutorials

    Easy to Use Platform

    Both administrators and users alike will enjoy our easy to use online portal to access learning material.

  • microsoft excel training

    Downloadable Cheat Sheets

    Access to a wide array of cheat sheets and starter guides for quick reference.

Microsoft Excel Training Courses

We offer more than 400 training courses for Microsoft Excel, covering everything from getting started to the most advanced functions such as pivot tables, conditional formatting, and data visualization. Our courses also address all current versions of Excel with both core and extended training lessons.

Excel 2016 Essentials

  • 1: Getting Started
  • 2: Ribbon Tabs: Exploring
  • 3: Ribbon Tabs: Home
  • 4: Ribbon Tabs: Insert
  • 5: Ribbon Tabs: Page Layout
  • 6: Ribbon Tabs: Formula
  • 7: Ribbon Tabs: Data
  • 8: Ribbon Tabs: Review
  • 9: Ribbon Tabs: View
  • 10: Ribbon Tabs: Exploring the Font Group
  • 11: Ribbon Tabs: Using the Font Dialog Box
  • 12: Ribbon Tabs: Exploring the Alignment Group
  • 13: Ribbon Tabs: Using the Alignment Dialog Box
  • 14: Ribbon Tabs: Understanding the Number Group
  • 15: Ribbon Tabs: Using the Number Dialog Box
  • 16: Hiding the Ribbon
  • 17: Backstage View: Entering and Exiting
  • 18: Backstage View: Info Option
  • 19: Backstage View: New Option
  • 20: Backstage View: Open Option
  • 21: Backstage View: Save and Save As Option
  • 22: Backstage View: Print Option
  • 23: Backstage View: Share Option
  • 24: Backstage View: Export Option
  • 25: Backstage View: Publish Option
  • 26: Backstage View: Close Option
  • 27: Backstage View: Account Option
  • 28: Backstage View: Options Option
  • 29: Backstage View: Feedback Option
  • 30: Understanding Status Bar Results
  • 31: Worksheets: Understanding Worksheet Navigation
  • 32: Worksheets: Adding and Deleting Worksheets
  • 33: Worksheets: Renaming Worksheets
  • 34: Worksheets: Hiding and Unhiding Worksheets
  • 35: Worksheets: Moving Worksheets
  • 36: Worksheets: Copying Worksheets
  • 37: Worksheets: Coloring Worksheet Tabs
  • 38: Worksheets: Using Zoom Controls
  • 39: Exploring Navigation Shortcuts
  • 40: Exploring Worksheet Views
  • 41: Entering Data
  • 42: Inserting Different Data Types
  • 43: Tell Me
  • 44: Smart Lookup
  • 45: Working with Templates
  • 46: Working with Worksheets
  • 47: Working with Autofills
  • 48: Row and Column Adjustments
  • 49: Hide and Unhide Columns and Rows
  • 50: Sharing

Excel 2016 Power Users

  • 1: Conditional Formatting – Using Data Bars
  • 2: Conditional Formatting – Configuring Data Bar Rules
  • 3: Conditional Formatting – Using Color Scales & Icon Sets
  • 4: Conditional Formatting – Configuring Highlight Cells Rules
  • 5: Conditional Formatting – Working with Top/Bottom Rules
  • 6: Conditional Formatting – Manage Multiple Rules
  • 7: Conditional Formatting – Using Cross Sheet
  • 8: Conditional Formatting – Working in Ranges with Errors
  • 9: Functions – Creating Formulas
  • 10: Functions – Understanding Functions
  • 11: Functions – Using AutoSum
  • 12: Functions – Using Average and Count
  • 13: Functions – Using Min & Max
  • 14: Functions – Exploring the Function Library
  • 15: Functions – Using Insert Function
  • 16: Function – Logical
  • 17: Function – Text
  • 18: Function – Date
  • 19: Tables – Create & View
  • 20: Tables – Exploring Sort in Datalists & Tables
  • 21: Tables – Turn on the Filter in Datalists and Tables
  • 22: Tables – Performing a Color Custom Sort
  • 23: Tables – Using Multiple Level Custom Sorts
  • 24: Tables – Using Data Filters
  • 25: Tables – Filtering Multiple Columns
  • 26: Tables – Using Search Features
  • 27: Tables – Add Data
  • 28: Tables – Add a Column & Totals Row
  • 29: Tables – Create a Calculation
  • 30: Tables – Formatting
  • 31: Graphics – Inserting & Formatting Pictures & ClipArt
  • 32: Graphics – Additional Formatting of Pictures
  • 33: Graphics – Inserting & Formatting Shapes
  • 34: Graphics – Adding SmartArt
  • 35: Graphics – Adding Pictures into SmartArt
  • 36: Graphics – Snapshot
  • 37: Graphics – Inserting & Formatting WordArt
  • 38: Printing – Customizing Options
  • 39: Printing – Scaling Page Dimensions
  • 40: Printing – Modifying Gridlines & Headings
  • 41: Printing – Creating Headers & Footers
  • 42: Printing – Print Titles
  • 43: Printing – Print Settings
  • 44: Review – Using Proofing Tools
  • 45: Review – Working with Cell Commands

Excel 2016 Pro

  • 1: Views – Working with Freeze Panes
  • 2: Views – Worksheet Views
  • 3: Templates – Creating Templates
  • 4: Links – Working with Hyperlinks
  • 5: Clipboard – Using the Clipboard Pane
  • 6: PivotTables – Understanding & Using PivotTables
  • 7: PivotTables – Create a Simple Pivot Table
  • 8: PivotTables – Add Fields to a Pivot Table
  • 9: PivotTables – Remove Fields from a PivotTable
  • 10: PivotTables – Use the Report Filter
  • 11: PivotTables – Format
  • 12: PivotTables – Adjust Numbers
  • 13: PivotTables – Create a Calculated Field
  • 14: PivotTables – Create a Calculated Item
  • 15: PivotTables – Enhancements
  • 16: PivotTables – Customizing PivotCharts
  • 17: PivotTables – Understanding the Slicer Tool
  • 18: PivotTables – Formatting the Slicer Tool
  • 19: PivotTables – Multi-select Feature
  • 20: Protection – Modifying Workbook Protection Settings
  • 21: Protection – Protecting Cells in a Workbook
  • 22: Protection – Protecting Workbook Structure
  • 23: Protection – Understanding Protected View
  • 24: Charts – Exploring
  • 25: Charts – Create a Simple Chart
  • 26: Charts – Customizing Text
  • 27: Charts – Formatting Chart Components
  • 28: Charts – Creating Sparklines
  • 29: Charts – Modifying Sparklines
  • 30: Charts – Inserting Sparklines from Data Ranges
  • 31: Data – Working with Subtotals
  • 32: Data – Showing Multiple Subtotals
  • 33: Data – Automatic Outlining
  • 34: Data – Custom Grouping
  • 35: Data – Using Scenarios
  • 36: Data – Using Goal Seek
  • 37: Data – One-click Forecasting
  • 38: Data – Get and Transform (Query)
  • 39: Data – Flash Fill
  • 40: Data – Text to Columns
  • 41: Data – Data Validation
  • 42: Data – One Input Data Tables
  • 43: Data – Two Input Data Tables
  • 44: Data – Consolidation
  • 45: Functions – Ink Equations
  • 46: Functions – Working with Absolute References
  • 47: Functions – Working with Named Cells
  • 48: Functions – Advanced Function Building – step through it
  • 49: Functions – Advanced Function Building – jump into it
  • 50: Functions – Advanced Function Building – go for it!
  • 51: Functions – Advanced Function Building – nested arguments
  • 52: Functions – Advanced Function Building – nested functions
  • 53: Functions – Advanced Function Building – I can do any function!
  • 54: Functions – Name a Selection
  • 55: Views – Custom Views

Excel 2013

  • 1: Getting Started
  • 2: Exploring the Ribbon Tabs
  • 3: Exploring the Home Tab
  • 4: Exploring the Insert Tab
  • 5: Exploring the Page Layout Tab
  • 6: Exploring the Formulas Tab
  • 7: Exploring the Data Tab
  • 8: Exploring the Review Tab
  • 9: Exploring the View Tab
  • 10: Exploring the Font Group
  • 11: Exploring the Font Dialog Box
  • 12: Exploring the Alignment Group
  • 13: Exploring the Alignment Dialog Box
  • 14: Understanding the Number Group
  • 15: Using the Number Dialog Box
  • 16: Hiding the Ribbon
  • 17: Entering & Exiting Backstage View
  • 18: Exploring the Info Option
  • 19: Exploring the New Option
  • 20: Exploring the Open Option
  • 21: Exploring the Save & Save As Options
  • 22: Exploring the Print Option
  • 23: Exploring the Share Option
  • 24: Exploring the Export Option
  • 25: Exploring the Close Option
  • 26: Exploring the Account Option
  • 27: Exploring the Options Option
  • 28: Understanding Status Bar Results
  • 29: Understanding Worksheet Navigation
  • 30: Adding & Deleting Worksheets
  • 31: Renaming Worksheets
  • 32: Hiding & Unhiding Worksheets
  • 33: Moving Worksheets
  • 34: Copying Worksheets
  • 35: Coloring Worksheet Tabs
  • 36: Using Zoom Controls
  • 37: Working with Templates
  • 38: Exploring Navigation Shortcuts
  • 39: Exploring Worksheet Views
  • 40: Splitting the Worksheet Views
  • 41: Arranging Worksheet Views
  • 42: Entering Data
  • 43: Inserting Different Data Types
  • 44: Understanding AutoFill
  • 45: Creating Series with AutoFill
  • 46: Working with AutoComplete
  • 47: Adjusting Rows and Columns with Autofit
  • 48: Adjusting Rows and Columns using the Ribbon
  • 49: Hide Columns and Rows
  • 50: Unhide Columns and Rows
  • 51: Conditional Formatting with Data Bars
  • 52: Configuring Data Bar Rules
  • 53: Conditional Formatting Using Color Scales
  • 54: Conditional Formatting Using Icon Sets
  • 55: Configuring Highlight Cells Rules
  • 56: Working with Top/Bottom Rules
  • 57: Manage Multiple Conditional Formatting Rules
  • 58: Using Cross Sheet Conditional Formatting
  • 59: Working with Conditional Formatting in Ranges with Errors
  • 60: Creating Formulas
  • 61: Understanding Functions
  • 62: Using AutoSum
  • 63: Using the Average Function
  • 64: Using the Count Function
  • 65: Using the Min Function
  • 66: Using the Max Function
  • 67: Exploring the Function Library
  • 68: Using the Insert Functions Command
  • 69: Inserting Logical Functions
  • 70: Working with Text Functions
  • 71: Using Date Functions
  • 72: Creating A Table
  • 73: Viewing Table Headers
  • 74: Sorting Table Data
  • 75: Exploring Sort and Filter Commands
  • 76: Preparing to Use Custom Sort
  • 77: Performing a Color Custom Sort
  • 78: Using Multiple Level Custom Sorts
  • 79: Exploring Data Filters
  • 80: Filtering Multiple Columns
  • 81: Using Search Features
  • 82: Adding Data to a Table
  • 83: Pick an Item From A List
  • 84: Adding Columns
  • 85: Creating a Calculated Column
  • 86: Adding a Total Row
  • 87: Formatting Tables
  • 88: Inserting Pictures and ClipArt
  • 89: Inserting Shapes
  • 90: Formatting Pictures
  • 91: Formatting Shapes
  • 92: Adding SmartArt into Worksheets
  • 93: Adding Pictures in SmartArt
  • 94: Customizing Print Options
  • 95: Scaling Page Dimensions
  • 96: Modifying Gridlines and Headlines
  • 97: Creating Headers and Footers
  • 98: Printing Titles
  • 99: Using Proofing Tools
  • 100: Working with Cell Comments

Excel 2013 Pro

  • 1: Working with Absolute References
  • 2: Working with Named Cells
  • 3: Understanding & Using PivotTables
  • 4: Create a Simple PivotTable
  • 5: Add Fields to a PivotTable
  • 6: Remove Fields from a PivotTable
  • 7: Use the Report Filter
  • 8: Format a PivotTable
  • 9: Adjust the Number Formats in a PivotTable
  • 10: Create a Calculated Field in a PivotTable
  • 11: Create a Calculated Item in a PivotTable
  • 12: Customizing PivotCharts
  • 13: Understanding the Slicer Tool
  • 14: Formatting the Slicer Tool
  • 15: Creating Sparklines
  • 16: Modifying Sparklines
  • 17: Inserting Sparklines from Data Ranges
  • 18: Protecting Your Data
  • 19: Modifying Workbook Protection Settings
  • 20: Protecting Cells in a Workbook
  • 21: Protecting a Workbook Window
  • 22: Understanding Protected View
  • 23: Requiring Protected View
  • 24: Exploring Charts
  • 25: Create a Simple Chart
  • 26: Customizing Text in Charts
  • 27: Formatting Chart Components
  • 28: Working with Cell Comments
  • 29: Using the Clipboard Pane
  • 30: Working with Freeze Panes
  • 31: Splitting the Worksheet Views
  • 32: Arranging Worksheet Views
  • 33: Creating Templates
  • 34: Using Templates
  • 35: Creating Subtotals
  • 36: Clearing Subtotals
  • 37: Showing Multiple Subtotals
  • 38: Automatic Outlining
  • 39: Create a Custom Grouping
  • 40: Use the Ungroup Option
  • 41: Working with Hyperlinks
  • 42: Using Scenarios
  • 43: Create Scenarios
  • 44: Using Goal Seek
  • 45: Advanced Function Building – Step Through It
  • 46: Advanced Function Building – Jump Into It
  • 47: Advanced Function Building – Go For It!
  • 48: Advanced Function Building – Nested Arguments
  • 49: Advanced Function Building – Nested Functions
  • 50: Advanced Function Building – I Can Do Any Function!

Excel 2010

  • 1: Getting Started
  • 2: Exploring Ribbon Tabs
  • 3: Working with Backstage View
  • 4: Understanding Worksheet Navigation
  • 5: Adding, Deleting and Renaming Worksheets
  • 6: Hiding and Unhiding Worksheets
  • 7: Moving, Copying or Coloring Worksheets
  • 8: Working with Templates
  • 9: Closing Excel
  • 10: Entering Data
  • 11: Exploring Navigation Shortcuts
  • 12: Inserting Different Data Types
  • 13: Modifying Cell Comments
  • 14: Using the Clipboard Pane
  • 15: Understanding AutoFill
  • 16: Creating Series with AutoFill
  • 17: Working with AutoComplete
  • 18: Exploring the Font Group
  • 19: Using the Font Dialog Box
  • 20: Exploring the Alignment Group
  • 21: Using the Alignment Dialog Box
  • 22: Understanding the Number Group
  • 23: Using the Number Dialog Box
  • 24: Adjusting Rows and Columns
  • 25: Using Hide and Unhide
  • 26: Formatting a Data Bar
  • 27: Configuring Data Bar Rules
  • 28: Formatting with Color Scales
  • 29: Formatting with Icon Sets
  • 30: Configuring Highlight Cells Rules
  • 31: Working with Top/Bottom Rules
  • 32: Manage Multiple Conditional Formatting Rules
  • 33: Using Cross Sheet Conditional Formatting
  • 34: Working with Conditional Formatting in Ranges with Errors
  • 35: Creating Formulas
  • 36: Understanding Functions
  • 37: Using AutoSum
  • 38: Exploring Common Functions
  • 39: Understanding Status Bar Results
  • 40: Exploring the Function Library
  • 41: Using the Insert Functions Command
  • 42: Inserting Logical Functions
  • 43: Working with Text Functions
  • 44: Using Date Functions
  • 45: Exploring Sort and Filter Commands
  • 46: Preparing to Use Custom Sort
  • 47: Performing a Color Custom Sort
  • 48: Using Multiple Level Custom Sorts
  • 49: Exploring Data Filters
  • 50: Filtering Multiple Columns
  • 51: Working with Subtotals
  • 52: New Table Features
  • 53: Using Search Features
  • 54: Protecting Your Data
  • 55: Modifying Workbook Protection Settings
  • 56: Protecting Cells in a Workbook
  • 57: Protecting a Workbook Window
  • 58: Understanding Protected View
  • 59: Requiring Protected View
  • 60: Exploring Worksheet Views
  • 61: Using Zoom Controls
  • 62: Working with Freeze Panes
  • 63: Splitting the Worksheet Views
  • 64: Arranging Worksheet Views
  • 65: Using Illustrations
  • 66: Formatting Pictures
  • 67: Formatting Shapes
  • 68: Adding SmartArt into Worksheets
  • 69: Adding Pictures in SmartArt
  • 70: Exploring Charts
  • 71: Create a Simple Chart
  • 72: Customizing Text in Charts
  • 73: Formatting Chart Components
  • 74: Customizing Print Options
  • 75: Scaling Page Dimensions
  • 76: Modifying Gridlines and Headlines
  • 77: Creating Headers and Footers
  • 78: Printing Titles
  • 79: Using Proofing Tools
  • 80: Renaming a Cell
  • 81: Renaming Cell Ranges
  • 82: Using Name Manager
  • 83: Working with Absolute References
  • 84: Using a Named Cell within a Formula
  • 85: Understanding PivotTables
  • 86: Create a Simple PivotTable
  • 87: Update Your PivotTable
  • 88: Understanding the Slicer Tool
  • 89: Formatting the Slicer Tool
  • 90: Customizing PivotCharts
  • 91: Creating Sparklines
  • 92: Modifying Sparklines
  • 93: Inserting Sparklines from Data Ranges
  • 94: Saving to Excel WebApp
  • 95: Logging in to Excel WebApp
  • 96: Modifying Excel WebApp Documents
  • 97: Viewing and Excel WebApp Document Version History
  • 98: Exploring Excel WebApp Menu Features
  • 99: Hiding the Ribbon
  • 100: Customizing the Ribbon
  • 101: VLookup

Start Your 7-day Free Trial Today

(Visited 315 times, 1 visits today)