hr@brain-mentors.com
+91 7042434524
+91 92179 75152
Monday – Sunday: 10:00 AM – 07:00 PM
Ghaziabad Branch
Brain Mentors Pvt Ltd, Second Floor, Anandam Square, Meerut Road Industrial Area, Ghaziabad, Uttar Pradesh-201003
Rohini, Delhi Branch
3, First Floor, Block-C, Pkt-9, Sec-7, Rohini, Delhi-85, Opp. to Metro Pillar No. 395 & 396, Beside Chaayos & Lenskart
Copyright © Brain-mentors 2015
Master the power of data management and analysis with our MS Excel course. Dive into the world's leading spreadsheet software to learn essential techniques for organizing, visualizing, and interpreting data with ease. Elevate your productivity and efficiency in data-driven tasks with expert-led training in MS Excel.
Piyush Pandey
🏆 Achieved ₹32 LPA Placement at Trilogy Innovations 🚀
CURRICULUM ROADMAP
01
> Introduction to MS Excel
> Basic Mathematical Operations
> Data Validations and filters
> Common Shortcuts
02
> Working with Numeric Data
> Working with Dates
> Creating Basic Formulas
> Aggregate Functions (SUM, MIN, MAX…)
> AutoSum Command
> AutoFill Command
> Modification of Excel Worksheet
> Move, Rename, Delete, Change Height and Width of Worksheet
> Formatting Data in Excel
> Changing backgrounds
> Formatting data as currency
> Conditional Formatting
> Inserting Images and Shapes
03
> Column and Bar Charts
> Formatting Excel Chart
> Pie Chart
> Ribbon Chart
> Histogram
> Line Plot and Scatter Plots
04
> Understanding List Structures
> Creating and Using Excel List
> Sorting List
> Sorting List Using Single Level and Multi Level Sorts
> Custom Sorts
> Data Forms
> Adding Data Using Data Forms
> Finding Records
> AutoFilter
> Advanced Filters
> Totals and Subtotals
> Excel List Functions
> Introduction to DSUM
> Excel DSUM function with AND, OR Criteria
> DCOUNT, DAVERAGE, SUBTOTAL
> Excel Data Validation
05
> Importing Data from Text Files
> Import Data from Database
> Import Data from CSV
> Exporting Data
06
> Pivot Tables in Excel
> Create Data Models with PowerPivot
> PowerPivot Calculated Fields
> PowerPivot KPIs
07
> Excel’s IF() Function
> Nesting Functions
> Nested Excel AND() function within IF()
> COUNTIF(), SUMIF(), IFERROR()
08
> VLOOKUP() and HLOOKUP()
> INDEX() and MATCH()
> LEFT(), RIGHT() and MID()
> LEN(), SEARCH() and CONCATENATE()
09
> Understanding Excel Macros
> Creating and Editing Macro
> Using Excel’s Macro Recorder
> VBA Concepts
> Data Types, Variables and Constant
> VBE
> VBA Modules
> Arrays
> Arithmetic and String Operators
> Comparison and Logical Operators
> Creating Procedures
> Building Logic into Macros
> Using VBA to Automate Excel Formulas
10
> Install ToolPak Add-In
> Frequency Distribution in Excel
> Correlation Matrix with Excel
> Descriptive Statistics
> Normal Distributions
Technical Program Lead (Software & Data Technologies)
A technical instructor specializing in Full Stack Development and Data Analytics with strong industry experience. Focused on practical learning through real projects, covering frontend, backend, APIs, databases, and deployment. In Data Analytics, training includes SQL, Excel, Python, and Power BI to analyze data, build dashboards, and generate meaningful business insights.
ENROLL TODAY
Your first month's salary (₹50,000+) will pay back 100% of this course. This isn't a cost — it's your launchpad.
MS Excel @ Brain Mentors
₹8,500
₹27,999
Offline Batch – Rohini Delhi
7-Day Money Back Guarantee. Attend the first week. Not satisfied? Full refund. No questions.
250+ Interview Questions Guide
250+ real Q&A — Worth ₹1,999 · Free
20-Hour Prompt Engineering
Top 100 LeetCode patterns — Worth ₹4,999 · Free
GitHub Portfolio Setup
Complete dev profile setup — Worth ₹2,999 · Free
Build AI-Powered Apps Workshop
Use AI in real projects — Worth ₹2,999 · Free
⚠️ Only 7 Seats Left in Rohini Batch!
83% seats filled. Price will increase once batch is full. Enroll now to lock ₹27,999.
Best in Delhi NCR
100% Placement
Rohini Batch
Installment Option
Find answers to common questions about the course and curriculum
Who is the MS Excel course designed for?
Is the MS Excel course available online?
Can the skills learned in the MS Excel course be applied to other spreadsheet software?
What will I learn in the MS Excel course?
Do I need prior experience with Excel to enroll in the course?
