COURSE DETAILS

Open any office in the country at the end of a month and you will find the same scene - someone sitting late in front of a spreadsheet, joining files by hand, matching figures, fixing the same errors he fixed last month. That person is not short of effort. He is short of method. Advanced Excel at NIMACT is the course that replaces effort with method.

The syllabus here is rebuilt every six months, because Excel itself keeps changing. Functions that did not exist three years ago now solve problems that used to need a long formula chain, and AI has entered the software directly. What was taught as "advanced" a decade ago is basic today. NIMACT keeps the content aligned with what offices are actually running, and with what employers actually test in an interview.

Where the value sits

Excel skill is not one skill. It is a ladder, and the pay changes sharply at each step.

At the bottom is the person who enters data and applies a total. That work is common and easily replaced. In the middle is the person who knows lookups and Pivot Tables, and can produce a report when asked. At the top is the person who never produces the same report twice - he builds it once, connects it to the source, and from then on the report updates itself while he moves on to the next problem. This course is written to carry a student from the bottom of that ladder to the top of it.

The one habit this course changes

There is a single mental shift behind everything taught here: stop doing the work, start designing it.

A normal user cleans the monthly file by hand every month. A trained user records those cleaning steps once in Power Query and refreshes them in one click forever after. A normal user rebuilds the weekly sales report every Monday. A trained user builds it once with a data model and lets the numbers flow in on their own. A normal user prints two hundred certificates one by one. A trained user writes fifteen lines of VBA and prints all of them while making tea.

That is the difference between forty hours of reporting a month and two.

How NIMACT's model plays out in Excel

NIMACT runs every course on AI > Programming Language (Coding) > Apps, and there is no subject where the three stages fit together as naturally as they do in Excel.

AI comes first, as the student's working partner. Copilot, ChatGPT, Claude AI, Gemini and Perplexity are used to build a difficult formula and, more importantly, to have it explained piece by piece so the student can modify it later. An error message is pasted in and understood instead of guessed at. A messy data problem is described in plain Hindi or English and a Power Query approach comes back. Equal attention is given to the danger - AI can hand over a formula that looks perfectly correct and quietly returns a wrong figure. In a salary sheet or a stock report, that wrong figure becomes a real loss. So verification is taught as a compulsory step, not as advice.

Coding comes next, through VBA. The student records a macro, opens the generated code, reads what it actually did, and then starts writing his own. Loops, conditions, range handling, file handling and UserForm design follow, until the workbook stops behaving like a sheet and starts behaving like software - with an entry screen, dropdowns and buttons. The same automation logic is then repeated in Google Apps Script and Office Scripts, so the student is not locked into one platform.

Apps is where the course ends. Not with exercises in a practice file, but with tools a business can use the same evening - a billing file that prints a proper invoice, an attendance and salary sheet, a stock tracker that warns before an item runs out, a certificate and ID card generator, and a dashboard where an owner filters by month, branch or product and sees his business in one screen.

Why platform matters

A student trained on one version of one product becomes helpless the day his employer uses something else. So the same work is practised in Microsoft Excel, Excel Online, Google Sheets and LibreOffice Calc. The concept is taught first and the software second. A lookup is a lookup, a pivot is a pivot - once the idea is clear, the menu position stops mattering.

What it leads to

Any organization that keeps records needs someone who can make sense of them - companies, banks, hospitals, schools, factories, distributors, CA offices, showrooms and government offices. The roles this course opens include MIS Executive, Data Analyst, Excel Automation Executive, Accounts Executive, Report Analyst, Back Office Executive, Store and Inventory Executive and Data Processing Executive.

Two practical points are worth noting. First, Excel is one of the few skills tested on the spot in interviews - a laptop is handed over and a task is given, so preparation cannot be faked. This course prepares for exactly that test. Second, the freelance market is steady and local. Shops, traders, clinics and coaching centres regularly pay for custom billing sheets, stock files and dashboards, and these are small jobs a student can deliver within days of finishing the course.

Who Should Attend: Anyone whose day already involves a spreadsheet and who wants to stop losing hours to it - accounts staff, MIS and reporting executives, data entry operators, store and stock keepers, payroll handlers and sales coordinators. Students preparing for corporate and bank recruitment, where a practical Excel test is standard. Shop owners and business persons who want to run their own accounts, stock and billing without depending on anyone. Teachers and school administrators handling admission, attendance and result data.

ELIGIBILITY CRITERIA: Open to all. There is no minimum qualification for this course. Basic Excel handling is helpful, but the required fundamentals are revised at the beginning.

Mode: Hybrid (Offline + Online + Live Doubt Session)

SYLLABUS:
To get a better idea about the course structure, let us go through a list of important subjects present in this program. Note - Only the important points have been mentioned.

• Data Concept, ICT & AI
• Artificial Intelligence (AI) - ChatGPT, Claude AI, Gemini, Copilot, Grok, DeepSeek, Qwen, Perplexity
• AI for Formula Building, Formula Explanation and Error Solving
• AI for Data Cleaning Logic, Analysis Ideas and Report Writing
• AI Output Verification and Responsible Use in Data Work
• Microsoft Copilot in Excel
• Excel Foundation Revision
• Excel Screen, Ribbon, Backstage View and Options
• File Formats - xlsx, xlsm, xlsb, csv
• Shortcut Keys and Speed Working
• Cell Reference - Relative, Absolute, Mixed and 3D
• Named Range and Name Manager
• Data Entry Discipline and Clean Data Rules
• Data Validation - List, Number, Date, Custom and Dependent Dropdown
• Sheet and Workbook Protection, Cell Locking
• Flash Fill, Text to Columns and Data Cleaning Tools
• Remove Duplicates, Trim, Clean and Format Correction
• Custom Number Format and Conditional Formatting
• Advanced Conditional Formatting with Formula
• Formulas and Functions
• Formula Auditing, Trace Precedent and Evaluate Formula
• Logical Functions - IF, Nested IF, IFS, AND, OR, NOT, IFERROR, SWITCH
• Lookup Functions - VLOOKUP, HLOOKUP, XLOOKUP, LOOKUP
• INDEX, MATCH, INDIRECT, OFFSET, CHOOSE
• Two Way Lookup and Multi Condition Lookup
• Text Functions - LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, TEXT, CONCAT, TEXTJOIN, TEXTSPLIT
• Date and Time Functions - TODAY, DATEDIF, EOMONTH, WORKDAY, NETWORKDAYS, WEEKDAY
• Statistical Functions - COUNT, COUNTA, COUNTIF, COUNTIFS, SUMIF, SUMIFS, AVERAGEIFS
• SUMPRODUCT and Array Logic
• Ranking Functions - RANK, LARGE, SMALL, MAX, MIN
• Financial Functions - PMT, IPMT, PPMT, FV, PV, NPV, IRR, RATE
• Information and Error Functions
• Dynamic Array Functions - FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
• Spill Range and Dynamic Formula Design
• LET Function and Readable Formulas
• LAMBDA Function and Custom Function Creation
• Project
• Data Analysis Tools
• Sorting - Single, Multi Level and Custom Sort
• AutoFilter and Advanced Filter
• Subtotal and Grouping
• Consolidate and Multi Sheet Data Handling
• Pivot Table
• Pivot Table Creation and Field Setting
• Value Field Settings, Show Values As and Custom Calculation
• Grouping by Date, Number and Text
• Calculated Field and Calculated Item
• Slicer, Timeline and Report Filter
• Pivot Chart and Interactive Reporting
• Refresh, Data Source Change and Common Pivot Errors
• Power Query
• Power Query Concept and Where It Saves Time
• Data Import from Excel, CSV, Text, Folder, Web and Database
• Query Editor, Applied Steps and Query Dependency
• Data Cleaning - Split, Merge, Replace, Trim, Fill Down
• Data Type Correction and Error Handling
• Unpivot, Pivot and Transpose
• Append and Merge Queries (Join Types)
• Grouping, Aggregation and Custom Column
• Parameter and Dynamic File Path
• One Click Refresh Automation
• Power Pivot and Data Model
• Data Model Concept and Relationship
• Star Schema and Table Design for Analysis
• Measure vs Calculated Column
• DAX (Data Analysis Expression) Basics
• DAX Functions - SUM, CALCULATE, FILTER, ALL, DIVIDE, RELATED
• Time Intelligence - YTD, MTD, Previous Year Comparison
• KPI and Performance Measures
• Charts and Visualization
• Chart Types and Correct Chart Selection
• Column, Bar, Line, Pie, Area, Scatter, Combo Chart
• Waterfall, Funnel, Histogram, Box Plot, Treemap, Sunburst
• Sparkline and In Cell Charts
• Dynamic Chart with Formula and Named Range
• Chart Formatting, Data Label and Axis Control
• Dashboard Design
• Dashboard Planning and Layout Rules
• KPI Cards, Filters and Interactive Controls
• Form Controls - Combo Box, Check Box, Option Button, Scroll Bar
• Colour, Font and Design Principles for Reports
• Data Storytelling and Management Presentation
• What If and Decision Tools
• Goal Seek
• Data Table - One Variable and Two Variable
• Scenario Manager
• Solver and Optimization Problems
• Forecast Sheet and Trend Analysis
• Project
• VBA and Excel Automation
• Macro Concept, Recording and Running
• Developer Tab, Macro Security and Macro Enabled Files
• Visual Basic Editor and Module Structure
• Variable, Data Type and Option Explicit
• Object, Property, Method and Excel Object Model
• Workbook, Worksheet, Range and Cells Handling
• Condition - If, Select Case
• Loop - For Next, For Each, Do While
• MsgBox, InputBox and User Interaction
• Sub Procedure, Function Procedure and Custom Function
• Error Handling with On Error
• UserForm Design - TextBox, ComboBox, ListBox, Button
• Data Entry Form with Add, Edit, Search and Delete
• File and Folder Automation, Bulk File Processing
• Auto PDF Export, Auto Print and Auto Email
• Assigning Macro to Button and Shortcut
• Code Optimization and Speed Settings
• Modern Automation
• Office Scripts for Excel Online
• Power Automate - Scheduled and Triggered Flows
• Google Sheets and Google Apps Script Automation
• Comparison of VBA, Office Scripts, Apps Script and Power Automate
• Multi Platform Practice
• Microsoft Excel, Excel Online, Google Sheets, LibreOffice Calc, Zoho Sheet
• Cloud Save, OneDrive, Sharing and Co-authoring
• Version History and Collaboration Rules
• Apps and Practical Systems
• Shop Billing and Invoice System with Printable Bill
• Employee Attendance and Salary Sheet
• Payroll System with PF, ESI and Deduction Calculation
• Stock and Inventory Tracker with Low Stock Alert
• Student Result and Marksheet System
• Loan EMI and Interest Calculator
• Certificate and ID Card Generator
• Daily and Monthly MIS Report Generator
• Interactive Business Dashboard with Slicers
• Career and Practice
• Excel Interview Questions and Practical Test Practice
• Speed and Accuracy Practice on Large Data
• Report Presentation and Client Handling
• Freelancing with Excel Projects
• Emerging Technologies - AI plus Excel in Modern Data Work
• Project Work
• Internship