Excel Syllabus

Module 1 : Intorduction to MS Excel

• Introduction to Excel interface
• Understanding workbooks, worksheets, and cells
• Navigating and selecting cells
• Entering and editing data
• Saving and opening workbooks

Module 2 : Basic Formulas and Functions

• Introduction to Excel formulas
• Basic arithmetic operators (+, -, *, /)
• Using simple functions (SUM, AVERAGE, MAX, MIN)
• Cell references (relative, absolute, mixed)
• Using autofill to copy formulas

Module 3 : Advanced Functions and Formulas

• Logical functions (IF, AND, OR)
• Text functions (CONCATENATE, LEFT, RIGHT, MID)
• Date and time functions (TODAY, NOW, DATE, YEAR, MONTH, DAY)
• Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)

Module 4 : Data Analysis Tools

• Sorting data
• Filtering data with AutoFilter
• Using subtotals and grouping data
• Data validation (drop-down lists, input messages, error alerts)
• Using conditional formatting

Module 5 : PivotTables and PivotCharts

• Introduction to PivotTables
• Creating PivotTables from data
• Grouping and summarizing data in PivotTables
• Formatting PivotTables
• Creating PivotCharts from PivotTables

Module 6 : Data Analysis With Excel

• Using What-If Analysis tools (Goal Seek, Scenario Manager)
• Data tables for sensitivity analysis
• Solver tool for optimization problems
• Advanced filtering techniques (Advanced Filter, Database functions)

Module 7 : Advanced Data Visualization

• Creating sparklines for mini-charts
• Customizing charts (chart types, styles, layouts)
• Adding data labels, titles, and legends to charts
• Creating combination charts and secondary axes

Module 8 : Excel Automation With Macros

• Introduction to macros
• Recording and running macros
• Editing and debugging macros
• Assigning macros to buttons and keyboard shortcuts

Module 9 : Data Import and Export

• Importing data from external sources (text files, CSV, databases)
• Exporting data to different formats (PDF, CSV, text files)
• Using Power Query for data transformation and manipulation

Module 10 : Collaborating and Sharing Workbooks

• Tracking changes and comments
• Protecting worksheets and workbooks
• Sharing workbooks via OneDrive or SharePoint
• Co-authoring and real-time collaboration

Module 11 : Excel Tips and Trics

• Keyboard shortcuts for productivity
• Using Excel templates
• Customizing Excel options and settings
• Troubleshooting common issues

Module 12 : Final Project

• Design and implement an Excel project
• Apply Excel concepts learned throughout the course
• Present and showcase the project