MS EXCEL

This comprehensive MS Excel course covers everything from basics to advanced analytics. Learn Excel interface, formulas, cell references, data cleaning, and formatting. Master sorting, filtering, data tools, and forecasting techniques. Gain expertise in advanced formulas, lookup functions, Pivot Tables, charts, and dashboards. Explore form controls and automation using ChatGPT. With real-world capstone projects, build practical skills for data analysis, reporting, and business decision-making.

instructor: Hiren Kakkad

Duration: 20 Hours

instructor:
Hiren Kakkad

Duration:
20 Hours

A person using a laptop featuring high-level data visualization, charts, and analytics dashboards

SERVICES

Course Content

17 lectures
20h Duration

Understanding & Customization of Quick Access Bar
Understanding & Customization of Ribbon
Row, Column, Cell & Cell Content
Formula bar & Function Library
Name Box / Address Bar
Understanding of File Extensions & It's usage

Saving & Sharing workbook
Protect Workbook
Inspect Workbook
Export workbook to another extension

Mathematical Operations
Basic Formulas (Min, Max, Average, Count, CountA, CountBlank etc.,)
Text Functions (Mainly used for data cleaning)
When to use MMC, LMC and RFS modifier in design (correct applications)
Date & Time Functions

What is Cell Reference
What is Range Reference
Cell Reference Style
Types of Cell Reference & It's uses

What is Sorting & purpose of using Sorting
Sorting & Advance Sorting Options (Vertical, Horizontal, Custom list & Multi Level Sorting)
What is Filtering & purpose of using Filtering
Filtering & Advanced Filtering Options
(Alphabetical, Numeric, Custom, Color)

Highlight Cell Rule
Top / Bottom Rule (www.statmodeller.com +91 98982 33268ceo@statmodeller.com
Data Bar, Color Scale, Icon Set
Custom Conditional Formatting

Text to Columns
Flash Fill (MS AI Tool)
Remove Duplicates
Data Validation
Data Consolidation

What-If Analysis
Goal-Seek
Scenario Manager
Data Table
Forecast Sheet

Aggregating values with condition(s). (SUMIF/ SUMIFS, COUNTIF/ COUNTIFS, AVERAGE/ AVERAGEIFS)
Nesting formulas for dynamic result
Large/Small (Indexing Values)
Row/Column (Support Functions for easy reporting)
Choose, Switch (Sometimes alternative to IF)
Transpose, Filter, Sort

Vlookup, Hlookup, 2 Way Lookup, Partial Lookup
Index, Match
XLookup, Xmatch

Excel Table (Creating, Modifying & exploring)
Adding, using & modifying Slicers & Time-line
Data Summarization through Pivot Table

Combo Box (Advanced Drop-down)
Spin Button (Switching between values)
Check Box (Show/Hide Data/Objects/chart series etc.,)
Scroll Bar (Display large data into small space)
Option Button (Switch between different option)
List Box (Select items to display data/objects/chart series etc.,)

Introduction to Excel Charts & Graphics
Different types of Excel Charts (Column Charts, Bar Charts, Line/ Area Chart, Pie Chart, Scatter Plot, Bubble Plot etc...) www.statmodeller.com +91 98982 33268 ceo@statmodeller.com

Advanced Stake Column Chart
Chart modification using Error Bar
Dynamic chart using naming series
Sunburst Chart, Treemap
Geo Map
Combo Charts
Statistical Charts (Histogram, Pareto Chart, Boxplot)

What is Dashboard
Overview on types of Dashboards
Benefits of using Dashboard
Things to consider before building Dashboard
How to create Dynamic Dashboard in Excel
Use Case #1 - Sales Dashboard
Use Case #2 - Financial Dashboard

ChatGPT Excel Formula Writing
ChatGPT Excel Formula Explanation
ChatGPT Excel Formula Examples with Data
ChatGPT Excel Formula Debugging

Project #1 - Manufacturing Dashboard
Project #2 - HR Dashboard

Broucher

Certificate

Know Your Trainer

CEO & Co-Founder, Stat Modeller Certified Lean Six Sigma Black Belt (BMGI) Certified ISO 9001 Internal Auditor

Meet Your Enthusiastic Trainer:Hiren Kakkad

✔8+ years of core industrial experience in process optimization, data tracking, and quality management.
✔Highly specialized in improving operational workflows and scaling enterprise data systems.
✔Experienced corporate trainer and senior strategic consultant in productivity domains.
✔Successfully empowered and upskilled over 9000+ trained participants across global industries.
✔Focused on resolving systemic layout anomalies using structured analytical and statistical approaches.
✔Decodes complex statistical models and business intelligence tools into execution frameworks.
✔Strong advocate of continuous improvement methodologies (Lean, Six Sigma) and data decision frameworks.

35+Research Projects
For Statistical Analysis

9000+Trained Participants
Globally

100+Successful Improvement
Projects

50+Custom Dashboards &
Templates Developed

Core Engineering & Design Expertise:

✓Business Intelligence & Tools: Specialized authority over data visualization and reporting infrastructure using Power BI, Tableau, and Advanced MS Excel.
✓Data Science & Analytics: Deep execution expertise in Python, R programming, SPSS, Minitab, and advanced Statistical Analysis matrices.
✓Operational Excellence: Comprehensive command over continuous improvement methodologies including Lean, Kaizen, 5-S, and TPM (Total Productive Maintenance).
✓Quality Assurance Systems: Advanced strategic controls for Inventory Optimization, Total Quality Management (TQM), and ISO 9001 compliance standards.

Distinguished Career Highlights & Milestones:

★Stat Modeller Leadership: Successfully co-founded and leads Stat Modeller as CEO, driving high-value corporate consulting and technical data transformations.
★9000+ Careers Empowered: Scaled technical and operational onboarding modules, upskilling thousands of engineers and management professionals worldwide.
★100+ Corporate Workflows Optimized: Formulated and delivered tailored continuous improvement and Six Sigma frameworks that directly boosted organizational productivity.
★Analytics Architecture Leader: Supervised the design and rollout of 50+ custom enterprise-grade interactive dashboards and high-end research projects for complex statistical analysis.

Free Videos

🎥 To Watch free Video lectures- Download Our App Now!

Click the link below to get started.

Reviews

Sayali Jangam

Experience: 4 Years

L&T Hyrocarbon

It was a great experience during the Pressure Vessel Design training. I have gained very in-depth knowledge about all aspects of Design. It boosted my confidence and as a result the growth in my career has been significant.

Belkacem Kisri

Experience: 5 Years

Bilfinger LTM Industrie SAS

This course is very good. In-depth knowledge about ASME code and Pressure Vessel, Heat Exchanger design & Nozzle Pro FEA. All the concepts are deeply explained. It has helped me enhance my knowledge and confidence.

Elmigdad Omer

Experience: 4 Years

Doha Petroleum Construction Co. Ltd.

My thanks and appreciation to Mr. Sachin Pol for sharing his experience and his effort to make this course effective with technical knowledge and good engineering practices. A great learning experience!

Raghuraman R

Experience: 17 Years

Technip Energies

This is the easiest and quickest way to learn the Code and static design. Very simplified method to make the concepts clear. Calculations are explained in very much detail.

Mangesh Deshmukh

Experience: 14 Years

Toyo

Trainer is technically very perfect and is even a better mentor. The training Program is very organized and cleared all my doubts about static design. Even minute details are taken care of.

Swati Bote

Experience: 10 Years

Worley

I have developed a thorough understanding about the various code requirements and calculations after doing this course. My approach towards Design has become more practical.

Priyanka Burhanpure

Experience: 13 Years

Thermax Ltd.

The content of the course is well-organized and covers all the concepts, code requirements and manual calculations which you need very badly as a Design Engineer. I found this as the only course where you can ask your live project queries.

Arvind Surve

Experience: 22 Years

Alfa Laval

The Quality of teaching is simply excellent! Highly explanatory animations for better understanding, which has made all the concepts very clear.

Mauli Khandekar

Experience: 11 Years

GSEC

The ASME code is difficult to understand and interpret, but the Trainer has made it simple and interesting. The only course in which manual design calculations/problems are taught in-depth.

Nikita Nimbalkar

Experience: 5 Years

TechInt

This is one of the best courses for Static Equipment Design Engineers. It's well-structured, easy to follow, and covers everything—from detailed explanations to manual calculations. A truly comprehensive and valuable course.

Umesh Kulkarni

Experience: 25 Years

Thermax

A very good course. Detailed explanation about the basic concepts. I have gained a lot of knowledge of Pressure Vessel and Heat Exchanger Design. I would definitely recommend this course.

Bhavik Modi

Experience: 10 Years

HLE Glascoat Ltd.

Great learning and experience. Their mentorship has really helped me to enhance my knowledge. This is such a comprehensive online platform for Static Equipment Engineers with manual calculations & Live Q&A sessions.

Brahmananda Mohapatra

Experience: 14 Years

Shreno Engineering Ltd.

I have very much benefited from Live Q&A session as I was able to get the answers to my project queries. It has boosted my confidence and as a result I have successfully faced ASME U-stamp Audit. This training has really transformed my career.

Harshil Thakarar

Experience: 2.5 Years

Meinhardt Group

Loading similar courses...