Course Title

Excel Data Analysis Bootcamp

Course Duration

12 hours

Instructor

Instructor Sun — Senior Data Analyst with 27+ years of Fortune 500 experience

Key Features

1. Structured, in-depth learning: Master the end-to-end Excel data workflow—from data collection and cleaning to essential formatting and basic statistical models.
2. Workplace-ready mindset: Develop the analytical thinking and logic required for professional data analyst roles.
3. Real-world oriented: Course cases are designed around real scenarios in finance, accounting, and other data-heavy functions.
4. Efficient learning model: Live sessions plus replays, with detailed notes and datasets to ensure solid understanding of each topic.
5. Interactive Q&A: Live teaching with real-time Q&A to address practical learning challenges.

Who Should Attend

• Beginner-level professionals: Learners who want to systematically build Excel and data analysis fundamentals.
• Professionals seeking higher efficiency: Those who need to improve their productivity and analytical capability using Excel.
• Sales and operations professionals: People who rely on data to support business decisions and optimize performance.

Course Overview

The “Excel Data Analysis Bootcamp” is designed for learners who want to enhance their workplace competitiveness through practical Excel skills. The course covers the complete workflow of data collection, cleaning, transformation, and analysis, enabling students to apply Excel in real business contexts even from a zero starting point.

Taught by a senior data analyst with over 27 years of Fortune 500 experience, this 12-hour live program provides a thorough walkthrough of core Excel data analysis skills, including data preparation, formatting, conditional formatting, and basic analytical model building.

The course focuses on the analytical thinking required in real jobs, especially in finance and accounting. Learners will not only understand “how to build spreadsheets,” but also how to interpret data and communicate insights clearly. Live sessions, replays, lecture notes, and datasets all work together to create a highly practical learning experience.

Main Topics Covered

• Excel formatting: Custom number, date, and time formats; table formatting; using Format Painter and style refinement.
• Worksheet editing & data handling: Find and replace, approximate search, format-based search, Go To Special, and more.
• Data sorting: Single- and multi-column sorting, color-based sorting, and custom sort rules.
• AutoFill techniques: Horizontal and vertical AutoFill, custom sequences, and pattern-based fills.
• Data filtering: AutoFilter, custom filters, conditional filters, and color filters.
• Data validation: Validation rules, custom validation formulas, error messages, single- and multi-level dropdown lists.
• Outline and grouping: Categorization, subtotals, grouping and ungrouping for hierarchical summaries.
• Data consolidation: Combining multiple ranges, multi-sheet consolidation, and dynamic summary updates.