Microsoft Excel – Part 2
- Duration
- 1 day
- Starting Price
- From $145.00
This course helps participants advance beyond the basics to creating advanced workbooks and worksheets that can help deepen their understanding of organizational intelligence, with an emphasis on extracting actionable insights from large datasets and presenting findings to decision-makers.
At Completion
- Leverage data analysis and presentation capabilities for informed organizational decisions, working with functions, lists, data analysis, chart visualization, and PivotTables/PivotCharts.
Exams & Certifications
Covers Microsoft Office Specialist Program exam objectives for Excel Associate (MO-200) and Excel Expert (MO-201) certifications for Office 365 and Office 2019.
Course Outline
1 - Working with Functions
- Ranges
- Specialized Functions
- Logical Functions
- Date/Time Functions
- Text Functions
2 - Working with Lists
- Sorting
- Filtering
- Database Queries
- Outlining and Subtotaling
3 - Analyzing Data
- Table Creation and Modification
- Intermediate and Advanced Conditional Formatting
4 - Visualizing Data with Charts
- Chart Creation, Modification, and Formatting
- Advanced Chart Features
5 - Using PivotTables and PivotCharts
- Creation, Analysis, and Presentation
- Filtering via Timelines and Slicers
Upcoming Sessions
- Nov 13, 2026 Online9:00 AM - 4:30 PM ET$145.00Register →
- Dec 17, 2026 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Jan 27, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Feb 23, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Mar 18, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Apr 23, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- May 18, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Jun 18, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Jul 19, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Aug 20, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Sep 17, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →