Microsoft Excel Intermediate

Course Summary

This intermediate Excel course equips students with essential skills in formulas, functions, advanced workbook management, and data analysis, culminating in mastery of PivotTables & PivotCharts, and powerful lookup functions for dynamic decision-making.

Event Details

6 hours
Combination lecture and classroom exercises.
Available at QSG’s training facilities, on-site at your organization, and virtually.

Description

Elevate your Excel skills with this comprehensive intermediate course designed to enhance your confidence in working with spreadsheets. You’ll master essential formulas, functions, and cell references, including relative and absolute references, and improve your navigation skills with quick tips. Dive into Excel essentials like conditional formatting, data validation, and date management while gaining expert tips for printing. Explore advanced workbook management with three-dimensional cell references, named ranges, and range-based functions. Unlock the power of graphing by learning various chart types, formatting, and data manipulation. Master the IF function for dynamic decision-making and explore powerful lookup functions like VLOOKUP and XLOOKUP. Finally, prepare your data with tables and discover the full potential of PivotTables and PivotCharts, including the use of slicers and timelines for interactive data analysis.

Who Should Attend

Students who have some experience using Excel and are comfortable with the basics of the structure and functionality.

Learning Objectives

Students will gain intermediate Microsoft Excel skills, including:

  • Working with Workbooks & Ranges
  • Charting Data
  • Utilizing the IF Function
  • Looking up Data Dynamically
  • Tables
  • PivotTables & PivotCharts

Course Outline

Review of Spreadsheets
• Formulas, Functions and Cell References
• Relative and Absolute Cell References
• Viewing the Excel Screen

Understand Excel Essentials
• Freezing Row and Column Headings
• Conditional Formatting
• How Dates Work
• Printing Tips

Work with Workbooks & Ranges
• Managing Sheets
• Three-Dimensional Cell References
• Naming Ranges
• Ranges in Functions

Chart Your Data
• Chart types
• Chart formatting
• Editing a chart
• Changing the source data

Utilize the IF Function
• IF: Letting Excel Make a Decision for You
• Calculating within an IF Function

Lookup Data Dynamically
• VLOOKUP
• XLOOKUP
• Data Validation

Tables: Prep to Pivot
• Intro to Tables
• Sorting & Filtering

Insert PivotTables & PivotCharts
• Into to PivotTables
• Into to PivotCharts
• Slicers
• Timelines

Prerequisites

Excel Introduction or equivalent skills.

Instructors

Dawn Monroe

Related Events

Customer Reviews

0
    Your Cart
    Your cart is emptyReturn to Shop
    Reap the benefits

    Login with your Membership Credentials

    Not Yet a Member? Request Membership Now

    Interested in this course for the Future?

    Thanks for letting us know!
    Please fill in the information below so that we can keep you informed.

    Name
    I'm not registering yet because
    This field is for validation purposes and should be left unchanged.



    Introducing our Updated Website Designed to Enhance your Experience

    Explore our revamped website and experience a more user-friendly interface designed to serve you better!

    QSG
    Pop-up mockup design featuring a clean and modern layout

    Thank you for visiting QSG!

    If you have any questions, would like more information, or would like to speak with a QSG representative, please contact us at any time!