| Chapter | Title | Description |
|---|---|---|
| Ch 1 | Overview of Excel 2024 | Introduction to Excel interface, Backstage view, saving/sharing online, formatting tables, Paste Special, Flash Fill, Quick Data Analysis, Data Mining, TAT saving techniques, and exercises. |
| Ch 2 | Cell References and Range | Master Relative, Absolute, and Mixed Cell References. Create, edit, and delete Named Ranges for efficient formulas. |
| Chapter | Title | Description |
|---|---|---|
| Ch 3 | Working with Formulas and Functions | Use Array Formulas, IF functions (Nested IF, IF with AND/OR/NOT), and Lookup functions – VLOOKUP and HLOOKUP. |
| Ch 4 | Data Validation | Trace Precedents and Dependents, set Data Validation rules, and apply various validation methods. |
| Chapter | Title | Description |
|---|---|---|
| Ch 5 | Protection | Build an Employee Information System, protect worksheets and workbooks with passwords, and password-protect files. |
| Ch 6 | Sorting a Database | Learn Simple, Multilevel, and Customized sorting techniques for data organization. |
| Ch 7 | Filtering a Database | Use AutoFilter, Number/Text/Date filters, Advanced Filter, and filter unique records. |
| Ch 8 | Subtotals and Data Consolidation | Summarize data using Subtotals and consolidate data from multiple sources. |
| Chapter | Title | Description |
|---|---|---|
| Ch 9 | Pivot Tables | Create Pivot Tables, use Recommended PivotTables, build graphs from Pivot data, use Slicers, Timelines, Power View, Data Model benefits, and create PivotTables using Power Pivot. |
| Ch 10 | Conditional Formatting | Apply Icon Sets and use formulas with multiple conditions for dynamic formatting. |
| Chapter | Title | Description |
|---|---|---|
| Ch 11 | What-If Analysis | Use Goal Seek, project figures using Data Tables, create What-If Scenarios, and merge scenarios from other worksheets. |
| Ch 12 | Working with Multiple Worksheets & Workbooks | Create links between worksheets and software, use auditing features, collaborate with workgroups, share and merge workbooks, track changes, and create hyperlinks. |
| Chapter | Title | Description |
|---|---|---|
| Ch 13 | Working with Charts | Create charts using Chart Tools, apply designs, add titles/values, format charts, use chart templates, filter options, create Waterfall Charts, recommendations, and use Sparklines. |
| Chapter | Title | Description |
|---|---|---|
| Ch 14 | Creating and Recording Macros in VBA | Introduction to VBA, uses, recording macros, adding Developer tab, defining macros, storage, shortcuts, descriptions, Relative Reference Macros, and running macros. |
| Ch 15 | Assigning Buttons to Macros | Create buttons on Quick Access Toolbar, modify menus/buttons, create buttons on worksheets, and edit recorded macros. |
| Chapter | Title | Description |
|---|---|---|
| Ch 16 | Functions and Subroutines in VBA | Write procedures, use Visual Basic Editor, Project Explorer, insert modules, write code, Sub Procedures, Function Procedures, syntax, branching, and logical operators (OR, AND). |
| Ch 17 | Conditional Statements in VBA | Use If…End If statements, examples, and compare Select Case vs If…End If. |
| Ch 18 | Variables and Data Types in VBA | Work with variables, constants, declare variables, data types, Option Explicit, Message Box, Input Box, select/activate cells/rows/columns, work with sheets, workbooks, and application objects. |
| Chapter | Title | Description |
|---|---|---|
| Ch 19 | Looping Structures in VBA | Use Do…Loop, For…Next statements, and Auto-Executed Macros for automation. |
| Ch 20 | Arrays and Collections in VBA | Declare, use, index arrays, dynamic arrays, resize arrays, and practical array examples. |
| Ch 21 | Debugging and Error Handling in VBA | Identify errors, implement error handling, use error numbers, and debug macros effectively. |
| Chapter | Title | Description |
|---|---|---|
| Ch 22 | User Forms and User Input in VBA | Create user forms, add controls, and handle events for controls. |
| Ch 23 | Advanced VBA Techniques and Best Practices | Code for initializing controls, option buttons, showing user forms, add-ins, change case forms, and creating menus through code. |
| Ch 24 | Building Custom Add-ins with VBA | Protect add-ins with passwords and use add-ins for enhanced functionality. |
| Chapter | Title | Description |
|---|---|---|
| Ch 25 | ChatGPT with Excel | Learn how to use ChatGPT to generate formulas, automate tasks, and solve Excel problems efficiently. |
| Ch 26 | Interactive Dashboards | Design professional, interactive dashboards combining all the skills learned throughout the course. |
| Skill Area | Key Takeaways |
|---|---|
| 📊 Excel Mastery | Full command over Excel interface, formulas, and functions |
| 🔢 Data Management | Sort, filter, validate, and protect data effectively |
| 📈 Pivot Tables | Create dynamic summaries and interactive reports |
| 📉 Charts & Visuals | Build professional charts, Sparklines, and dashboards |
| 🤖 VBA Automation | Record and write macros to automate repetitive tasks |
| 🧠 Programming Logic | Master VBA – loops, arrays, functions, and user forms |
| 🔐 Security | Protect workbooks, worksheets, and files |
| 🤝 Collaboration | Share, merge, and track changes in workbooks |
| 🧩 ChatGPT Integration | Use AI to speed up Excel tasks |
| 🖥️ Dashboard Design | Create interactive, executive-level dashboards |
| Tool / Technology | Purpose |
|---|---|
| Microsoft Excel | Primary spreadsheet tool |
| VBA (Visual Basic for Applications) | Automation and macros |
| Power Query | Data transformation (covered in advanced topics) |
| Power Pivot | Advanced data modeling |
| ChatGPT | AI assistance for formulas and automation |
| Excel Add-ins | Custom functionality |
| Module | Chapters | Focus Area |
|---|---|---|
| Module 1 | Ch 1 – 2 | Excel Overview, Cell References, Named Ranges |
| Module 2 | Ch 3 – 4 | Formulas, Functions, Data Validation |
| Module 3 | Ch 5 – 8 | Protection, Sorting, Filtering, Subtotals |
| Module 4 | Ch 9 – 10 | Pivot Tables, Conditional Formatting |
| Module 5 | Ch 11 – 12 | What-If Analysis, Multi-Workbook Management |
| Module 6 | Ch 13 | Charts & Visualizations |
| Module 7 | Ch 14 – 15 | VBA Macros – Recording & Buttons |
| Module 8 | Ch 16 – 18 | VBA Programming – Functions, Conditionals, Variables |
| Module 9 | Ch 19 – 21 | Loops, Arrays, Debugging |
| Module 10 | Ch 22 – 24 | User Forms, Advanced VBA, Add-ins |
| Module 11 | Ch 25 – 26 | ChatGPT Integration, Interactive Dashboards |
| Job Role | Average Salary (India) |
|---|---|
| Data Analyst | ₹4–10 LPA |
| Business Analyst | ₹6–14 LPA |
| Financial Analyst | ₹5–12 LPA |
| MIS Executive | ₹4–8 LPA |
| VBA Developer | ₹6–15 LPA |
| Excel Automation Specialist | ₹7–14 LPA |
| BI Analyst | ₹6–12 LPA |
Data Analysts – Enhance data processing and reporting skills
Finance & Accounting Professionals – Automate financial tasks
Business Professionals – Build dashboards and reports
Students & Freshers – Add Excel mastery to your resume
Administrative Professionals – Save time with automation
Anyone – Looking to become an Excel power user
| Project | Description |
|---|---|
| Employee Information System | Protected workbook with employee data |
| Sales Dashboard | Interactive dashboard with Pivot Tables and charts |
| Financial Model | What-If analysis and scenario planning |
| Automated Report Generator | VBA macro to generate daily/weekly reports |
| Data Cleaning Tool | VBA tool to clean and format data |
| Interactive Dashboard | Multi-visual dashboard with slicers and timelines |
| ChatGPT-Assisted Excel Tool | Use AI to build formulas and solve problems |
“Mastered the skills? Proven your expertise? Now get the recognition you deserve – Excellence Accreditation from Experts Institute. A trusted mark of quality and credibility.”
expertshub0618@gmail.com
+91 80506 76595
No:8/9, 1st Floor, Kaveri Complex, Near Jalahalli Cross Metro Station, S M Road, Jalahalli Cross, Bangalore-560057, Karnataka
