Intermediate Microsoft Excel Training

Intermediate Microsoft Excel Training

4.9 out of 5 - Read Testimonials
Course Length: 1 day
Delivery Methods: Multiple delivery options
Course Overview

In this Intermediate Microsoft Excel class, you will use powerful tools and features to manage and analyze your data. Packed with tips and tricks, you will quickly gain Excel power-user skills to help you work effectively. The class starts with popular formulas and functions like IF, SWITCH, PMT, and CONCAT. Then, you will learn to manipulate data in lists by sorting, filtering, adding subtotals, and more. You will learn to create engaging and insightful reports by visualizing your data using charts and sparklines. The class wraps up with important lessons on tables and advanced formatting, including conditional formatting, styles, and custom templates.

Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not supported in earlier versions of Excel, and point out alternative options, when available.

Course Benefits
  • Use Excel database functions and logic functions to work with information in large datasets.
  • Leverage Excel's statistical functions to analyze data.
  • Visualize your data using charts to show trends, create comparisons, and demonstrate other meaningful insights.
  • Convert, sort, filter, and manage lists to keep your data organized.
  • Insert and modify illustrations, logos, or shapes to create professional reports.
  • Manage and analyze data using tables.
  • Emphasize interesting and unusual data with conditional formatting
  • Save time by using styles to apply formatting instantly.
Available Delivery Methods
Public Class
Public expert-led online training from the convenience of your home, office or anywhere with an internet connection. Guaranteed to run .
Private Class
Private classes are delivered for groups at your offices or a location of your choice.
Self-Paced
Learn at your own pace with 24/7 access to an On-Demand course.
Microsoft Certified Partner

Webucator is a Microsoft Certified Partner for Learning Solutions (CPLS). Our curriculum has been tested and approved by ProCert Labs, the official tester of Microsoft courseware, and has been found to meet the highest industry standards of instructional quality.

Microsoft Silver Certified Partner
Course Outline
  1. Common Functions
    1. Using Named Ranges in Formulas
    2. Using Named Ranges in Formulas (exercise)
    3. Using Formulas That Span Multiple Worksheets
    4. Entering a Formula Using Data in Multiple Worksheets (exercise)
    5. Functions: IF and IFS
    6. Using the IF Function (exercise)
    7. Functions: AND and OR
    8. Functions: NOT
    9. Functions: SWITCH
    10. Functions: COUNTIF, AVERAGEIF, and SUMIF
    11. Functions: PMT and NPER
    12. Using the PMT Function (exercise)
    13. Functions: TEXTJOIN and CONCAT
    14. Using the TEXTJOIN Function (exercise)
    15. Text Functions
    16. Creating Ordinal Numbers (exercise)
    17. Date and Time Functions
    18. Using Date Functions (exercise)
  2. Working with Lists
    1. What is a List of Data?
    2. Removing Duplicates from a List
    3. Removing Duplicates from a List (exercise)
    4. Sorting Data in a List
    5. Sorting Data in a List (exercise)
    6. Filtering Data in a List
    7. Filtering Data in a List (exercise)
    8. Adding Subtotals to a List
    9. Adding Subtotals to a List (exercise)
  3. Visualizing Your Data
    1. Chart Basics
    2. Tools for Editing Charts
    3. Using the Chart Design Tool Tab (exercise)
    4. The Format Tool Tab
    5. Using the Three Chart Buttons
    6. The Format Task Pane
    7. Useful Charts
    8. Line and Area Charts
    9. Hierarchy Charts
    10. Statistic Charts
    11. Other Charts
    12. Combo Charts
    13. Using Recommended Charts
    14. Sparklines
    15. Inserting and Customizing Sparklines (exercise)
    16. Add and Format Objects
    17. Working with Shapes
    18. Working with Icons
    19. Working with SmartArt
    20. Using the Quick Analysis Tool
  4. Working with Tables
    1. Format Data as a Table
    2. Table Design Tool Tab
    3. Formatting Individual Cells
    4. Selecting Table Rows and Columns
    5. Creating and Modifying a Table in Excel (exercise)
    6. Structured References
    7. Convert a Table to a Range
  5. Advanced Formatting
    1. Cell Styles
    2. Working with Cell Styles (exercise)
    3. Conditional Formatting
    4. Conditional Formatting: Highlight Cells Rules
    5. Conditional Formatting: Top/Bottom Rules
    6. Conditional Formatting: Data Bars, Color Scales, and Icon Sets
    7. Conditional Formatting: Create a New Rule
    8. Removing Conditional Formatting
    9. Using Conditional Formatting (exercise)
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Excel class:

  • Basic Excel skills
Prerequisite Courses

Courses that can help you meet these prerequisites:

Follow-on Courses
Register for a Live Class
$245.00
Please select a class.
Request a Private Class
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Pricing
Self-Paced Course
$49.95 or 1 coupon
  • On Demand 24/7
  • Readings
  • Presentations
  • Exercises
  • Quizzes
  • Full Year of Access
  • Learn more
Register Now