Excel Learning Plan in 2024

Deepshika

Complete Excel Syllabus for Data Analytics

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)