Here is the Excel Learning Plan in 2024:
|– Week 1: Introduction to Excel
| |– Excel Basics
| | |– What is Excel?
| | |– Excel Interface Overview
| | |– Basic Operations (Open, Save, Close)
| |– Setting up Excel
| | |– Workbook and Worksheet Management
| | |– Entering and Editing Data
| | |– Basic Formatting
| |– First Excel Project
| | |– Creating a Simple Spreadsheet
| | |– Basic Formulas (SUM, AVERAGE)
|
|– Week 2: Intermediate Excel
| |– Advanced Formulas and Functions
| | |– Logical Functions (IF, AND, OR)
| | |– Text Functions (CONCATENATE, LEFT, RIGHT)
| | |– Date and Time Functions
| |– Data Management
| | |– Sorting and Filtering Data
| | |– Data Validation
| |– Basic Charts and Graphs
| | |– Creating Charts
| | |– Customizing Charts
| | |– Sparklines
|
|– Week 3: Advanced Excel Techniques
| |– Advanced Data Analysis
| | |– Pivot Tables
| | |– Pivot Charts
| | |– Slicers and Timelines
| |– Lookup and Reference Functions
| | |– VLOOKUP, HLOOKUP
| | |– INDEX and MATCH
| | |– INDIRECT and ADDRESS
| |– Advanced Formatting
| | |– Conditional Formatting
| | |– Custom Number Formats
| | |– Themes and Styles
|
|– Week 4: Excel for Data Analysis
| |– Data Cleaning
| | |– Removing Duplicates
| | |– Text to Columns
| | |– Data Cleaning Functions (TRIM, CLEAN)
| |– Data Visualization
| | |– Advanced Chart Types (Waterfall, Funnel)
| | |– Creating Dashboards
| |– Power Query
| | |– Importing Data
| | |– Transforming Data
| | |– Merging and Appending Queries
|
|– Week 5: Excel for Business and Finance
| |– Financial Functions
| | |– PMT, PV, FV
| | |– NPV, IRR
| |– Business Modeling
| | |– Scenario Analysis
| | |– Goal Seek
| | |– Data Tables
| |– Reporting and Presentations
| | |– Creating Professional Reports
| | |– Using Templates
| | |– Printing and Sharing Workbooks
|
|– Week 6-8: Advanced Excel Tools
| |– Macros and VBA
| | |– Recording Macros
| | |– Editing Macros in VBA
| | |– Automating Tasks
| |– Power Pivot
| | |– Introduction to Power Pivot
| | |– Creating Data Models
| | |– Using DAX in Power Pivot
| |– Excel Add-ins
| | |– Installing Add-ins
| | |– Popular Add-ins (Solver, Analysis ToolPak)
| |– Collaboration and Sharing
| | |– Co-authoring
| | |– Excel Online
| | |– Sharing and Permissions
|
|– Week 9-11: Real-world Applications and Projects
| |– Capstone Project
| | |– Project Planning
| | |– Data Collection and Preparation
| | |– Building and Optimizing Models
| | |– Creating and Publishing Reports
| |– Case Studies
| | |– Business Use Cases
| | |– Industry-specific Solutions
| |– Integration with Other Tools
| | |– Excel and Power BI
| | |– Excel and SQL
| | |– Excel and R/Python
|
|– Week 12: Post-Project Learning
| |– Excel Administration
| | |– Workbook and Worksheet Protection
| | |– Data Encryption
| |– Advanced Excel Topics
| | |– New Excel Features
| | |– Excel for Mac
| |– Continuing Education
| | |– Advanced Excel Techniques
| | |– Community and Forums
| | |– Keeping Up with Updates
|
|– Resources and Community
| |– Online Courses (Coursera, edX, Udemy)
| |– Books (Excel Bible, Excel for Dummies)
| |– Excel Blogs and Podcasts
| |– GitHub Repositories
| |– Excel Communities (Microsoft Tech Community, Reddit)
