Microsoft Excel Intermediate (Level 2)
Microsoft Excel Intermediate (Level 2) expands foundational Excel knowledge by introducing advanced formulas, data analysis tools, and reporting features. Participants gain hands-on experience using PivotTables, charts, and workbook customization tools commonly required in professional and data-driven roles.
Hands-On Training Taught by Experts
Live, Online, Instructor-Led
Skills you can use immediately
This course includes
- Live, instructor-led training delivered online or in person
- Hands-on labs aligned to real workplace data and reporting tasks
- All course materials, templates, and Excel data files included
- Instruction focused on efficiency, accuracy, and job-ready Excel skills
- Optional customization for group training, departments, or workforce initiatives
Microsoft Excel Intermediate (Level 2) is an instructor-led professional development workshop designed for workforce development programs, employer-sponsored training, and group learning. Building on the skills introduced in Excel Beginners (Level 1), this course focuses on using Excel’s more advanced tools to manipulate data, automate calculations, and improve reporting efficiency.
Participants learn how to write and apply advanced formulas, organize and analyze larger data sets, and use PivotTables and PivotCharts to uncover insights. The course also introduces workbook customization, chart enhancements, and visual elements that support clearer communication and more productive workflows in the workplace.
What You’ll Learn at a Glance
- Write and use advanced formulas with text, date, logical, conditional, and lookup functions
- Organize worksheet and table data using sorting, filtering, and structured data techniques
- Create and modify charts to support business reporting and communication
- Analyze data using PivotTables, Slicers, and PivotCharts
- Insert and modify graphic objects within worksheets
- Customize and enhance workbooks and the Excel working environment
Prerequisites
Participants should have completed Microsoft Excel Beginners (Level 1) or possess equivalent experience. A working knowledge of basic formulas, formatting, charts, and worksheet navigation is recommended.
Tuition
Price may vary based on group size.
$359/student
Group and organizational pricing options available
This course includes
- Live, instructor-led training delivered online or in person
- Hands-on labs aligned to real workplace data and reporting tasks
- All course materials, templates, and Excel data files included
- Instruction focused on efficiency, accuracy, and job-ready Excel skills
- Optional customization for group training, departments, or workforce initiatives