Excel - Part 2

Introduction:

Ready to go beyond the basics? Our Intermediate Excel Training course is perfect for professionals who want to turn raw data into clear insights using Microsoft Excel. Whether you’re managing projects, tracking budgets, or building reports, this course gives you the tools to work smarter—not harder. You’ll dive into features like advanced functions, data analysis tools, PivotTables, and charting—all designed to help you confidently modify spreadsheets and workbooks to support better decision-making. With over 60% of employers saying Excel skills are in high demand, this training is a smart step in growing your career.

This course builds on the foundational knowledge from Excel – Part 1 and takes your skills to the next level. It aligns with Microsoft Office Specialist exam objectives, helping you prepare for the Excel Associate (MO-200) and Excel Expert (MO-201) certifications. You’ll learn how to build and modify advanced workbooks that streamline processes and enhance data insights in your organization.

Objectives:

By the end of this intermediate Excel training course, you’ll be able to work confidently within Microsoft Excel—applying logical, date/time, and text functions; managing lists of data using tables and filters; and using conditional formatting to highlight trends. You’ll also learn how to create, modify, and enhance workbooks with charts, PivotTables, and PivotCharts. These real-world skills will help you transform raw data into clear, actionable information and support smarter, data-driven decision-making.

Course Outline:

Working with Functions

  • Work with ranges
  • Use logical, date/time, and text functions
  • Apply specialized formulas

Working with Lists

  • Sort and filter data
  • Query data with database functions
  • Outline and subtotal lists within a workbook

Analyzing Data

  • Create and manage Excel tables
  • Apply intermediate and advanced conditional formatting

Visualizing Data with Charts

  • Build and modify charts for clarity
  • Apply formatting and advanced chart features

Using PivotTables and PivotCharts

  • Create and analyze PivotTables
  • Build dynamic PivotCharts
  • Use slicers and timelines for filtering

Enroll in this course

$295.00

Need Help Finding The Right Training Solution?

Our training advisors are here for you.