Advanced Excel for Data Analysts

Free Curriculum52 Comprehensive LessonsSelf-Paced & PracticalIndustry Certificate

Master Advanced Excel for Data Analysts with DataCliq's structured, career-ready training track. Learn core foundational concepts, explore production datasets, practice hands-on scripts and interview scenarios, and build job-ready confidence.

Start Course — Lesson 1: 1. Introduction to Excel & Use Cases

Who It's For

Aspiring data analysts, BI specialists, engineers, and professionals wanting to automate data workflows and ace data interviews.

Estimated Workload

4–6 weeks self-paced (5–8 hours/week). Includes structured modules, real-world case studies, and coding assignments.

Certification

Earn a verifiable DataCliq course certificate upon completing all lessons, assignments, and capstone challenge.

Prerequisites

No prior programming experience required. We guide you step-by-step from beginner fundamentals to advanced analytics.

Full Course Syllabus

Week 1: Week 112 lessons

1.1. Introduction to Excel & Use CasesStart →2.2. Downloading & Installing ExcelStart →3.3. Understanding the InterfaceStart →4.4. Workbooks vs WorksheetsStart →5.5. Navigation & Keyboard ShortcutsStart →6.6. Data Entry & Editing BasicsStart →7.7. Cell Referencing BasicsStart →8.8. Formatting Cells (Font, Alignment, Borders)Start →9.9. Basic Number FormattingStart →10.10. Custom Number FormattingStart →11.Introduction to Excel – Interface & NavigationStart →12.Formulas Start →

Week 2: Week 210 lessons

1.1. Intro to Formulas vs FunctionsStart →2.2. Basic Math FunctionsStart →3.3. Relative vs Absolute Referencing ($)Start →4.4. Counting FunctionsStart →5.5. Conditional Counting (COUNTIF, COUNTIFS)Start →6.6. Conditional Summing (SUMIF, SUMIFS)Start →7.7. Basic Logical Functions (IF)Start →8.8. Advanced Logical Functions (AND, OR)Start →9.9. Nested IF StatementsStart →10.10. Error Handling (IFERROR)Start →

Week 3: Week 310 lessons

1.1. Text Extraction (LEFT, RIGHT, MID)Start →2.2. Finding Text (FIND, SEARCH)Start →3.3. Changing Case (UPPER, LOWER, PROPER)Start →4.4. Combining Text (CONCATENATE vs TEXTJOIN)Start →5.5. Basics of Dates in ExcelStart →6.6. Advanced Date Math (EDATE, EOMONTH)Start →7.7. Calculating Workdays (NETWORKDAYS)Start →8.8. Data Cleaning: Text to ColumnsStart →9.9. Removing Duplicates & BlanksStart →10.10. Flash Fill MagicStart →

Week 4: Week 410 lessons

1.1. Basic SortingStart →2.2. Basic & Advanced FilteringStart →3.3. Data Validation BasicsStart →4.4. Advanced Data ValidationStart →5.5. Conditional Formatting BasicsStart →6.6. Advanced Conditional FormattingStart →7.7. Classic Lookups (VLOOKUP)Start →8.8. Horizontal Lookups (HLOOKUP)Start →9.9. Modern Lookups (XLOOKUP)Start →10.10. Dynamic Lookups (INDEX & MATCH)Start →

Week 5: Week 510 lessons

1.1. Intro to Pivot TablesStart →2.2. Modifying Pivot TablesStart →3.3. Pivot Table Slicers & TimelinesStart →4.4. Basic ChartingStart →5.5. Advanced ChartingStart →6.6. Intro to What-If AnalysisStart →7.7. Goal SeekStart →8.8. Data TablesStart →9.9. Scenario ManagerStart →10.10. Data Model & Power PivotStart →