Beginner Excel Curriculum

1. Introduction to Excel

   • Understanding the interface (ribbon, cells, sheets)

   • Creating, opening, and saving a workbook

   • Navigating worksheets (scrolling, selecting cells)

2. Basic Data Entry

   • Typing and formatting text and numbers

   • AutoFill and series (e.g., days, months, numbers)

   • Copy, cut, and paste techniques

3. Basic Formatting

   • Changing font, size, color

   • Aligning and wrapping text

   • Using borders and shading

4. Simple Formulas

   • Introduction to formulas (sum, average, count)

   • Using cell references (relative, absolute)

   • Basic math operations (addition, subtraction)

5. Sorting and Filtering Data

   • Sorting data (alphabetical, numerical)

   • Applying filters to view specific data

6. Basic Charts

   • Inserting and customizing simple charts (bar, line, pie)

   • Chart formatting (titles, colors)

7. Saving and Printing

   • Page layout basics

   • Print preview and printing

Advanced Excel Curriculum

1. Advanced Formulas

   • Logical formulas (IF, AND, OR)

   • Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)

   • Text functions (CONCATENATE, LEFT, RIGHT)

2. Data Validation

   • Creating drop-down lists

   • Restricting data entry (numbers, dates)

3. Conditional Formatting

   • Highlighting cells based on conditions (color scales, icon sets)

   • Custom rules for formatting

4. Pivot Tables and Pivot Charts

   • Creating pivot tables to summarize data

   • Analyzing data with pivot charts

5. Advanced Data Analysis

   • Using What-If analysis (goal seek, data tables)

   • Solver tool for optimization

6. Macros and Automation

   • Recording and editing macros

   • Automating repetitive tasks

7. Collaboration Tools

   • Sharing workbooks

   • Co-authoring in real-time

   • Protecting sheets and workbooks

8. Data Import and Export

   • Importing data from external sources (CSV, web, databases)

   • Exporting to PDF, CSV

9. Dashboards and Advanced Charts

   • Designing interactive dashboards

   • Advanced charting techniques (combo charts, sparklines)