Skip to Content
Course Outline
1. Introduction to Excel
- Overview of the Excel Interface
- Creating and Saving Workbooks
- Basic Data Entry and Cell Referencing
2. Basic Excel Functions and Formulas
- Basic Arithmetic Operations
- Introduction to Common Functions (SUM, AVERAGE, etc.)
- Basic Formula Writing
3. Data Formatting and Customization
- Cell Formatting and Conditional Formatting Basics
- Merging and Splitting Cells
- Customizing Rows and Columns
4. Working with Charts and Graphs
- Creating Basic Charts (Bar, Column, Line, Pie)
- Customizing and Editing Charts
5. Sorting and Filtering Data
- Sorting Data (Alphabetically, Numerically)
- Applying Filters and Using Advanced Filter Options
6. Working with Tables
- Creating and Formatting Excel Tables
- Structured References in Tables
7. Advanced Formulas and Functions
- Logical Functions (IF, AND, OR)
- Lookup and Reference Functions (VLOOKUP, INDEX-MATCH)
- Text and Date Functions
8. Data Validation and Protection
- Setting Data Validation Rules
- Protecting Sheets and Workbooks
9. Pivot Tables and Pivot Charts
- Creating and Formatting Pivot Tables
- Using Pivot Charts for Data Visualization
10. Advanced Data Analysis
- What-If Analysis (Goal Seek, Scenario Manager)
- Solver for Optimization
11. Macros and Automation
- Introduction to Macros and VBA
- Automating Repetitive Tasks
12. Advanced Charting and Visualization
- Creating Dynamic and Interactive Charts
- Advanced Chart Types (Waterfall, Gantt Charts)
13. Collaboration and Sharing
- Sharing Workbooks and Collaborative Editing
- Importing and Exporting Data
14. Power Query and Power Pivot (Optional)
- Data Transformation with Power Query
- Data Models and Calculations with Power Pivot
15. Excel for Business Intelligence
- Creating Dashboards and KPI Reports
- Advanced Data Connections and Integrations
16. Final Project
- Practical Workbook Creation
- Incorporating All Learned Skills in a Capstone Project
g
