Excel – Part 2

Instructor‑Led: $295 | Duration: 1 Day

Upgrade your tech skills with this , training course from TechSherpas 365!

Select a Learning Method Below

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
2/10/2026 2/10/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$295
2/13/2026 2/13/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$295
2/18/2026 2/18/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$295
2/23/2026 2/23/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$295
2/26/2026 2/26/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run

$295
3/3/2026 3/3/2026
11:00AM - 7:00PM
star GTR

Guaranteed-to-Run

$295
START DATE : 2/10/2026
END DATE : 2/10/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $295
START DATE : 2/13/2026
END DATE : 2/13/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $295
START DATE : 2/18/2026
END DATE : 2/18/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $295
START DATE : 2/23/2026
END DATE : 2/23/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $295
START DATE : 2/26/2026
END DATE : 2/26/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $295
START DATE : 3/3/2026
END DATE : 3/3/2026
CLASS TIMES (EST) : 11:00AM - 7:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $295

Course Highlights

LEVEL: 
  • Intermediate
TOPICS & JOB ROLES: 
BRANDS/TECHNOLOGIES: 

Excel – Part 2 Course Outline

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.

Who Should Attend this Course?

This course is ideal for professionals who already have a basic understanding of Microsoft Excel and want to deepen their capabilities. It’s a great fit for analysts, administrative staff, project leads, and anyone who regularly uses Excel to manage data, generate reports, or support business decisions.

PREREQUISITES

Participants should have completed Excel ? Part 1 or have equivalent experience using Excel formulas, formatting, and workbook navigation.

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

Related Job Roles

This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

No results found.

Explore Related Training Courses

What Our Students Are Saying

IT Certification Training Course Reviews