Scribd
Upload
183 views

Excel Basic To Advance Syllabus

Excel Basics

Uploaded by

Jawad Mahmud
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
183 views

Excel Basic To Advance Syllabus

Excel Basics

Uploaded by

Jawad Mahmud
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Excel Basic to Advance Syllabus

Sure! Here is a comprehensive syllabus for learning Microsoft Excel from the
basics to advanced levels:

# Excel Learning Syllabus: Basics to Advanced

#Module 1: Introduction to Excel**


- Overview of Excel Interface
- Understanding Workbooks and Worksheets
- Navigating the Excel Ribbon
- Customizing the Excel Environment
- Using Help and Excel Resources

#Module 2: Basic Excel Functions**


- Entering and Editing Data
- Cell Referencing (Relative, Absolute, and Mixed)
- Basic Formulas and Functions (SUM, AVERAGE, MIN, MAX)
- Autofill and Flash Fill
- Working with Text (CONCATENATE, LEFT, RIGHT, MID)

#Module 3: Formatting Worksheets**


- Formatting Cells, Rows, and Columns
- Number Formatting (Currency, Percentage, Date)
- Conditional Formatting
- Creating and Modifying Styles
- Using Themes and Templates
Module 4: Managing Worksheets and Workbooks**
- Creating and Managing Worksheets
- Organizing and Protecting Worksheets
- Grouping and Ungrouping Worksheets
- Linking Data between Worksheets and Workbooks
- Importing and Exporting Data

#Module 5: Data Management and Sorting**


- Sorting Data
- Filtering Data
- Using Advanced Filter Options
- Removing Duplicates
- Data Validation

Module 6: Advanced Formulas and Functions**


- Logical Functions (IF, AND, OR, NOT)
- Lookup and Reference Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Date and Time Functions (TODAY, NOW, DATE, TIME, DATEDIF)
- Text Functions (LEN, FIND, SUBSTITUTE, TRIM, TEXTJOIN)
- Array Formulas and Dynamic Arrays

Module 7: Working with Tables**


- Creating and Formatting Excel Tables
- Sorting and Filtering Tables
- Using Structured References
- Summarizing Data with Table Functions
- Converting Data Ranges to Tables and Vice Versa
Module 8: Data Analysis Tools*
- Using PivotTables
- Creating and Customizing Pivot Charts
- Slicers and Timelines
- Data Grouping and Ungrouping
- Advanced Data Analysis Techniques

Module 9: Visualization with Charts*


- Creating and Formatting Charts
- Types of Charts (Column, Line, Pie, Bar, Area, Scatter, etc.)
- Customizing Chart Elements
- Using Sparklines
- Combining Multiple Chart Types

Module 10: Advanced Data Analysis*


- Using What-If Analysis (Data Tables, Scenario Manager, Goal Seek)
- Solver Add-In
- Forecasting and Trend Analysis
- Descriptive Statistics with Excel
- Data Analysis Toolpak

Module 11: Macros and VBA*


- Introduction to Macros
- Recording and Running Macros
- Introduction to VBA (Visual Basic for Applications)
- Writing Simple VBA Code
- Debugging and Error Handling
Module 12: Collaboration and Workbook Sharing**
- Sharing Workbooks
- Tracking Changes
- Adding Comments
- Protecting Worksheets and Workbooks
- Using OneDrive and Excel Online for Collaboration

Module 13: Advanced Excel Features**


- Power Query for Data Import and Transformation
- Power Pivot for Data Modelling
- Using 3D Maps
- Creating Dashboards in Excel
- Connecting Excel with External Data Sources

Module 14: Integration with Other Office Applications


- Integrating Excel with Word and PowerPoint
- Embedding and Linking Excel Data
- Creating Mail Merges with Excel Data
- Using Excel Data in Outlook

Module 15: Excel Best Practices and Troubleshooting


- Best Practices for Building Excel Models
- Tips for Efficient Excel Usage
- Troubleshooting Common Issues
- Using Excel Add-Ins
- Keeping Excel Updated and Secure
Module 16: Capstone Project
- Developing a Comprehensive Excel Project
- Real-World Case Studies
- Presentation and Peer Review
- Final Project Submission and Feedback

### Suggested Textbooks and Resources


- "Microsoft Excel 2019 Bible" by Michael Alexander, Richard Kusleika, and John
Walkenbach
- "Excel 2019 All-in-One For Dummies" by Greg Harvey
- "Excel PivotTables and PivotCharts" by Paul McFedries
- Online resources such as Microsoft Learn, LinkedIn Learning, and Coursera
courses on Excel.

### Assessment Methods


- Quizzes and Tests
- Practical Assignments and Case Studies
- Capstone Project
- Participation and Engagement

This syllabus provides a structured learning path from basic to advanced Excel
skills, ensuring a comprehensive understanding and proficiency in using Excel
for various applications.

You might also like