MS Excel Syllabus
1. Introduction to MS Excel
Overview of Excel Interface
Workbook, Worksheet, Rows, and Columns
Navigating and Selecting Cells
Basic Data Entry and Editing
2. Basic Excel Operations
Formatting Cells (Font, Color, Borders, Alignment)
Merging and Wrapping Text
Inserting and Deleting Rows, Columns, and Cells
Copying, Cutting, and Pasting Data
3. Formulas and Functions
Basic Arithmetic Formulas (+, -, *, /)
Common Functions: SUM, AVERAGE, MIN, MAX ETC.
Logical Functions: IF, AND, OR, NOT, TRUE, FALSE ETC.
Lookup & Reference Functions: VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, OFFSET, TRANSPOSE, ROW, ROWS ETC.
Text Functions: CONCATENATE, LEFT, RIGHT, LEN, TRIM, UPPER, LOWER, PROPER, REPT, UNICHAR, CLEAN, CHAR ETC.
Date & Time Functions: TODAY, NOW, DATE, YEAR, MONTH, NETWORKINGDAYS, NETWORKINGDAYS.INTL ETC.
Maths & Trig: SUBTOTAL, SUMPRODUCT, PRODUCT, POWER, SQRT, RAND, RANDBETWEEN, MODE ETC.
4. Data Management and Analysis
Sorting and Filtering Data
Data Validation and Drop-Down Lists
Conditional Formatting
Removing Duplicates
Flash Fill & AutoFill
5. Charts and Graphs
Creating Bar, Line, Pie, and Column Charts
Customizing Charts (Titles, Labels, Legends)
Data Series and Trendlines
6. Pivot Tables and Pivot Charts
Creating and Customizing Pivot Tables
Analyzing Data with Pivot Charts
Using Slicers and Timelines
7. Advanced Excel Functions
Nested Functions
Array Formulas
Text-to-Columns and Flash Fill
What-If Analysis (Goal Seek, Data Tables, Solver)
8. Data Protection and Security
Protecting Worksheets and Workbooks
Password Protection
Cell Locking and Sheet Encryption
9. Automation with Macros & VBA (Advanced Level)
Introduction to Macros
Recording and Running Macros
Basics of VBA (Visual Basic for Applications)
10. Collaboration and Sharing
Track Changes and Comments
Sharing Workbooks Online
Using Excel with OneDrive and Google Sheets
This syllabus covers beginner to advanced levels and is suitable for students, professionals, and business users.