Microsoft Excel – Part 2
Duration: 1 day
Microsoft Excel – Part 2 takes you beyond the basics into the functions and tools that make Excel powerful. You’ll work with more advanced formulas and functions, organize data with tables, summarize information visually with charts, and analyze data with sorting, filtering, and conditional formatting.
Learning Objectives
- Use functions to perform calculations across data
- Work with tables to manage and analyze data
- Sort, filter, and outline data
- Create and modify charts
- Apply conditional formatting and data validation
Who Should Attend
- Excel users comfortable with the basics
- Professionals who analyze or report on data regularly
- Anyone who completed Excel – Part 1 or has equivalent experience
Prerequisites
- Microsoft Excel – Part 1 or equivalent experience
- Ability to create basic formulas and format worksheets
What’s Included
- Authorized courseware and student materials
- Hands-on labs and real-world practice exercises
- Live instruction from an experienced, certified trainer
- Small class sizes for personalized attention
- Attend on campus in Miami or Fort Lauderdale, or live online
- Certificate of completion
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/8/2025 | 12/8/2025 | ||||
| 12/29/2025 | 12/29/2025 | ||||
| 1/19/2026 | 1/19/2026 | ||||
| 2/9/2026 | 2/9/2026 | ||||
| 3/2/2026 | 3/2/2026 | ||||
| 3/23/2026 | 3/23/2026 | ||||
| 4/13/2026 | 4/13/2026 | ||||
| 5/4/2026 | 5/4/2026 | ||||
| 5/25/2026 | 5/25/2026 | ||||
| 6/15/2026 | 6/15/2026 | ||||
| 7/6/2026 | 7/6/2026 | ||||
| 7/27/2026 | 7/27/2026 | ||||
| 8/17/2026 | 8/17/2026 | ||||
| 9/7/2026 | 9/7/2026 | ||||
| 9/28/2026 | 9/28/2026 | ||||
| 10/19/2026 | 10/19/2026 | ||||
| 11/9/2026 | 11/9/2026 | ||||
| 11/30/2026 | 11/30/2026 | ||||
| 12/21/2026 | 12/21/2026 | ||||
| 1/11/2027 | 1/11/2027 |
Course Outline
Module 1: Working with Functions
Use logical, statistical, date, and text functions to build more capable formulas.
Module 2: Working with Tables
Create Excel tables, use structured references, and sort and filter table data.
Module 3: Analyzing Data
Apply conditional formatting, data validation, and outlines to analyze and control data.
Module 4: Visualizing Data with Charts
Create, modify, and format charts to present data clearly.
Module 5: Working with Multiple Worksheets
Link and consolidate data across worksheets and workbooks.
