YouTube Channel

Microsoft Office Excel

For Competitive Examinations

MS Excel Notes, MCQs & Quiz

Find Current Job Openings
Buy/Download Books

🧾 Complete Microsoft Excel Syllabus (Full Detailed Version)

Level 1: Beginner

Module 1: Introduction & Environment

Module 2: Data Entry & Basic Editing

  • 1.2.1. Entering cell data: text, numbers, dates, times
  • 1.2.2. Editing cell contents: edit in cell, formula bar, replace/clear contents
  • 1.2.3. AutoFill and Flash Fill (where available)
  • 1.2.4. Insert/delete cells, rows, columns; hide/unhide rows, columns, worksheets
  • 1.2.5. Moving, copying data and formulas (drag, cut & paste, copy & paste)
  • 1.2.6. Undo/Redo, find and replace
  • 1.2.7. Cell comments/notes (in newer Excel versions)
  • 1.2.8. Basic keyboard shortcuts

Module 3: Cell References & Basic Formulas

  • 1.3.1. Understanding formulas: syntax, operators (+, –, *, /, ^), order of operations
  • 1.3.2. Simple worksheet functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
  • 1.3.3. Relative vs absolute vs mixed references ($A$1, A$1, $A1)
  • 1.3.4. AutoSum, quick calculations
  • 1.3.5. Basic error-types and error checking (e.g., #DIV/0!, #NAME?, #VALUE!)
  • 1.3.6. Using named ranges for ease of reference

Module 4: Formatting Worksheets

  • 1.4.1. Number formats: General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Custom formats
  • 1.4.2. Font formatting: typeface, size, color, bold/italic/underline
  • 1.4.3. Alignment: horizontal/vertical, wrap text, merge & center, indent
  • 1.4.4. Borders and fill colors
  • 1.4.5. Cell styles and themes
  • 1.4.6. Format Painter tool
  • 1.4.7. Row height & column width adjustments, hiding rows/columns
  • 1.4.6. Format Painter tool
  • 1.4.7. Row height & column width adjustments, hiding rows/columns
  • 1.4.8. Worksheet tab colour, renaming, moving
  • 1.4.9. Worksheet views: Normal, Page Layout, Page Break Preview, Custom Views
  • 1.4.10. Page setup: margins, orientation, size, print area, titles, headers/footers

Module 5: Basic Data Management

  • 1.5.1. Sorting and filtering: sort by one or multiple columns, custom sorts; filters by text, number, date, color
  • 1.5.2. Using tables (Insert > Table): converting range to table, table styles, total row
  • 1.5.3. Basic conditional formatting: highlight cell rules, top/bottom rules, data bars, colour scales, icon sets
  • 1.5.4. Using basic charts: selecting data, inserting charts (column, bar, line, pie), editing chart titles, axis labels
  • 1.5.5. Printing: print preview, set print area, repeat rows/columns, scaling, page breaks, print selection, multiple worksheets

Level 2: Intermediate

Module 6: Advanced Formulas & Functions

  • 2.6.1. Logical functions: IF, AND, OR, NOT, IFS
  • 2.6.2. Lookup & reference: VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET, CHOOSE
  • 2.6.3. Text functions: LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER, CONCAT / TEXTJOIN, SUBSTITUTE, FIND / SEARCH
  • 2.6.4. Date & time functions: TODAY, NOW, DATE, TIME, DAY, MONTH, YEAR, EOMONTH, WEEKDAY, NETWORKDAYS
  • 2.6.5. Statistical functions: COUNTIFS, SUMIFS, AVERAGEIFS, RANK, SMALL, LARGE
  • 2.6.6. Math & trigonometry: ROUND, ROUNDUP, ROUNDDOWN, INT, MOD, POWER, SUMPRODUCT
  • 2.6.7. Information functions: ISERROR, ISNA, ISBLANK, TYPE
  • 2.6.8. Array formulas / dynamic arrays (where available): FILTER, SORT, UNIQUE, XLOOKUP (in newer versions)
  • 2.6.9. Named ranges: create, manage (Name Manager), scope (workbook/worksheet)

Module 7: Data Validation & Advanced Data Tools

  • 2.7.1. Data validation: setting rules for data entry (whole number, decimal, list, date, time, text length, custom formula)
  • 2.7.2. Error alert messages, input messages
  • 2.7.3. Advanced filtering: criteria range, copying filtered result to another location
  • 2.7.4. Consolidate data, remove duplicates
  • 2.7.5. Using subtotals and outline groups (Data > Subtotal, Group/Ungroup)
  • 2.7.6. What-If Analysis: Goal Seek, Scenario Manager, Data Tables (one-variable, two-variable)
  • 2.7.7. Introduction to “Solver” add-in (if context allows)
  • 2.7.8. Importing data: text files (delimiters), CSV, from web, from database/external sources (basic)

Module 8: PivotTables & PivotCharts

  • 2.8.1. Converting data to table, then to PivotTable
  • 2.8.2. Creating PivotTable, selecting data source, placing in new vs existing worksheet
  • 2.8.3. PivotTable layout: rows, columns, values, filters; grouping (dates, numbers)
  • 2.8.4. Slicers and Timelines (if version supports)
  • 2.8.5. Calculated fields and calculated items
  • 2.8.6. Changing Value Field Settings: sum, count, average, max, min, custom calculation
  • 2.8.7. PivotCharts: insert, link to PivotTable, update/refresh, filters applied
  • 2.8.8. Managing multiple PivotTables from same data source
  • 2.8.9. Using “Get & Transform” / Power Query in newer Excel versions (basic intro)

Module 9: Advanced Charts & Dashboarding

  • 2.9.1. Secondary axis charts, combo charts (line + column)
  • 2.9.2. Specialized chart types: waterfall, funnel, sunburst, histogram, box-and-whisker (if supported)
  • 2.9.3. Sparklines (line, column, win/loss)
  • 2.9.4. Creating interactive dashboards: using form controls, slicers, drop-down lists, hyperlinks, macro buttons (basic)
  • 2.9.5. Formatting charts: data labels, trendlines, error bars, chart templates
  • 2.9.6. Linking charts/tables across worksheets

Module 10: Protection, Collaboration & Review

  • 2.10.1. Workbook protection: password to open, modify, workbook structure
  • 2.10.2. Worksheet protection: locking/unlocking cells, protection options (select locked/unlocked cells, format cells, insert/delete columns/rows)
  • 2.10.3. Sharing workbooks, co-authoring (depending on version), track changes, comments and notes
  • 2.10.4. Inspecting workbook for hidden metadata, compatibility, accessibility (in newer versions)
  • 2.10.5. Customize Quick Access Toolbar, Customize Ribbon, Excel Options (Advanced settings)
  • 2.10.6. Version history and recovery (AutoSave, AutoRecover)

Level 3: Advanced

Module 11: Automation & Macros

  • 3.11.1. Introduction to macros: recording a macro, assign macro to button/shape
  • 3.11.2. Understanding VBA Editor: modules, procedures (Sub, Function), referencing workbooks/worksheets/ranges
  • 3.11.3. Variables, data types, constants, arrays
  • 3.11.4. Control statements: If…Then, Select Case, Loops (For Next, Do While/Until)
  • 3.11.5. MessageBox, InputBox functions
  • 3.11.6. Error handling (On Error statements)
  • 3.11.7. Working with events (Workbook_Open, Worksheet_Change)
  • 3.11.8. Automating tasks like sending email via Outlook, merging worksheets, splitting data
  • 3.11.9. Introduction to user forms (basic)
  • 3.11.10. Best practices: commenting code, modular design, debugging, security/trust settings

Module 12: Advanced Data Analysis & Business Intelligence

  • 3.12.1. Using Analysis ToolPak: regression, ANOVA, descriptive statistics
  • 3.12.2. Power Query: advanced import, clean, transform (merge, append queries, unpivot, pivot)
  • 3.12.3. Data Model & Power Pivot (if available): building relationships, creating DAX measures, key performance indicators (KPIs)
  • 3.12.4. What-If analysis advanced: Solver optimization, scenario summarization
  • 3.12.5. Advanced dashboard techniques: dynamic charts, interactive controls, linking to Power BI (if relevant)
  • 3.12.6. Leveraging Python in Excel (in newer versions where available)
  • 3.12.7. Advanced array formulas and dynamic arrays
  • 3.12.8. Performance tuning: managing large datasets, using tables, avoiding volatile functions, optimizing calculation settings

Module 13: Real-World Projects & Case Studies

  • 3.13.1. Create a complete financial model (budgeting, forecasting) in Excel
  • 3.13.2. Build an interactive dashboard for business metrics (sales, marketing, operations)
  • 3.13.3. Automate recurring reporting with macros/VBA
  • 3.13.4. Build data-cleaning and transformation workflows with Power Query
  • 3.13.5. Present and print professional reports: template design, printing large spreadsheets, linking to Word/PowerPoint
  • 3.13.6. Consolidation of multiple worksheets/workbooks, linking external sources, change-control

Additional Appendices / Reference Lists

  • List of all major Excel functions (with categories: Math & Trig, Statistical, Text, Date & Time, Lookup & Reference, Logical, Information, Financial)
  • Keyboard shortcuts: essential and advanced
  • Version differences: features introduced in Excel 2013/2016/2019/365 (e.g., Flash Fill, Quick Analysis, new chart types)
  • Glossary of Excel terminology: workbook, worksheet, cell, range, table, named range, PivotTable, etc.
  • Best practices for workbook design: naming conventions, documentation, error checking, protection, color coding

All courses are free, don’t give any charges, ignore them  if anyone charge.

Contact For Assistance/Give If You Have Any Suggession

The Website Is Yours | Keep Reading | Upgrade Your Skill | Get Success | Stay Stress Free

Quick Links

  • Home
  • About
  • Blog
  • Job Openings
  • Downloads
  • Shop
  • Contact

Subject/Courses

  • Mathematics
  • General Studies
  • English Language
  • Reasoning
  • Computer
  • Current Affairs
  • MCQ's Tests

Important Links

  • Exams
  • Notifications
  • Admit Card
  • Employment Exchange
  • Cast/Resident Certificate
  • Educational Certificates
  • Police Verification

Legal Links

  • Privacy Policy
  • Terms Of Use
  • Disclaimer
  • Refund Policy
  • Delivery Policy
  • Sitemap
  • Support

Social Connects

YouTube Channel
Facebook Page
Telegram Group
WhatsApp Group

Copyright © 2004-2025 Mind Set Education – Managed By: mLand India Technologies. All Rights Reserved.

error: Content is protected !!

IMPORTANT NOTICE

We are MindSet Competitive Education Team/ Family. We are currently uploading our course contents continuously to complete and to lunch the website for you all as soon as possible. But we are continuously update course contents/topics from START, so you can stat your Competitive Preparation Journey from start to end step by step.

Anybody Interested To Join Our Courses(Free For All) and get everyday updates on courses/topics/Current affairs.

JOIN OUR WHATSAPP GROUP
JOIN OUR TELEGRAM GROUP