+918802579388
Sujit Kumar Singh
Founder of IPT Excel SchooL
With over two decades of experience in
Excel, I have honed my skills as an MIS
Executive and VBA Developer across
more than 10 companies. Currently, I
serve as a Report Consultant for 40
companies, delivering tailored solutions
and expert advice.
My journey with Excel began in 2003, and since then, I have
dedicated myself to mastering its intricacies and applying my
knowledge to solve real-time official problems.
I not only teach Excel but also provide comprehensive
support for a wide range of business challenges. My goal is
to empower professionals to leverage Excel's full potential
and enhance their productivity. Join me to gain practical
insights and tackle real-world issues effectively.
Online Live Trainer
From 2007 to Tilled
specialize in advanced Excel
techniques, including complex
in Power BI, enabling me to formulas, data analysis, automation
create dynamic and
interactive dashboards
for data visualization and
business intelligence
create dynamic and interactive
dashboards for data
visualization and business
intelligence
Learn Core Python and With MS Excel and Power BI
Python enables me to
automate processes, analyze
complex datasets, and develop
custom solutions to meet VBA allows me to automate
specific business needs repetitive tasks, create custom
functions, and streamline
complex workflows within Excel
SQL allows me to
manage and analyze
large datasets
efficiently, design
complex queries,
and ensure data
integrity
Advanced Excel and Dashboard
Large Data Selection and Shortcuts
Complicated Calculation with Math Operators
Advanced Paste Special and Pictoure Lookup
Custom and Conditional Formating for Dashboard Reporting
Excel In-Build AI in Excel and Data Handling (Short - filter)
Advanced Pivot and Power Pivot
Making Dashboard with Pivot and Pivot Chart
Mastering Formulas and Functions
> 300 Formulas with Array Formulas
make own Formulas without using VBA use LAMBDA
Data Analysis and Visualization - Dashboard
Data Management and Automation
Advanced Data Tools
Power BI and Data Connectvity from Comon Data Sourse
Collaboration and Security
Case Studies and Projects
Conclusion
Review of key concepts and skills Q&A and troubleshooting common issues
Final projects and practical applications
This advanced course will equip you with the skills needed to excel in data analysis,
automation, and visualization using Excel
POWER BI Dashboard and DAX
Introduction to Power BI and Power BI tools and services
Requirements Gathering
Extract, Transform, and Load (ETL) Data
Power BI Desktop
Data extraction and transformation
Data modeling and formatting
Designing Reports
Creating interactive and visual reports
Using visualizations and fields
Using Power Query and Data Analysis Expressions (DAX)
Building and sharing dashboards
Advanced DAX functions
Power BI Cloud and Report Server
Security and data management
Advanced Data Modeling and DAX
Real-World Case Studies and Best Practices
Conclusion
This detailed outline should provide a comprehensive and in-depth
learning experience for anyone looking to master Power BI.
Python Data Analysis & Visualization
Introduction to Python for Data Analysis
Python Basics snd Core Python
Data Manipulation with Pandas
Data Visualization with Matplotlib and Seaborn
Statistical operations with NumPy
Exploratory Data Analysis (EDA)
Working with Time Series Data
Statistical Analysis
Reshaping and Pivoting Data
Combining Data
Data Cleaning and Preprocessing
Big Data and Distributed Computing
Big Data and Distributed Computing
Advanced Dashboard Design and Development
Building Dashboards with Streamlit
Introduction to GUI Development in Python with TKINTER and PyQt
Practical Case Studies and Projects
This outline should give you a solid foundation in Python for data analysis. If
there are specific areas you want to focus on
VBA Macros for Report Automation
Basics of VBA Programming
VBA syntax and basic programming concepts
Variables, data types, and constants
If...Then...Else statements
For...Next DO While - Until loops
Working with Excel Objects
Understanding Excel object model (Workbook, Worksheet, Range, Cells)
Functions and Subroutines
Error Handling and Debugging
User Forms and Controls
Working with External Data
Accessing and manipulating external databases (ADO, DAO) with SQL
Working with charts and graphics
Automating repetitive tasks and processes
Ensuring code security and protection
Real-World Examples and Projects
Building practical VBA projects (e.g., invoice generator, report automation)
This comprehensive outline should guide you through learning VBA and help you develop
powerful automation solutions.
SQL Server 2022 with Query
Overview of SQL Server 2022
Installation and setup
SQL Server architecture
Introduction to SQL Server Management Studio (SSMS)
Data Types and Table Structures
Querying Data
SELECT statements
Filtering data with WHERE clause
Using JOINs to combine tables
Advanced Querying Techniques
Subqueries and nested queries
Set operators (UNION, INTERSECT, EXCEPT)
Data Manipulation and Transactions
INSERT, UPDATE, DELETE statements
Error handling and TRY...CATCH blocks
User-defined functions (UDFs)
Advanced Data Management
Roles and permissions
Real-World Case Studies and Best Practices
IPT Excel School
Address
Arijpur , Rajla , Kurhani,
Muzaffarpur(Garibnath Dham), Bihar -844120
(+91 8802579388 , +91 8826828093 +91 0621 2950207)
kumar@iptindia.com
https://twitter.com/excelmis_kumar
https://www.facebook.com/sujeetkumar.ipt
https://www.instagram.com/advanceexceltraining/
https://www.linkedin.com/in/sujit-kumar-singh-047849178/
https://www.youtube.com/channel/UCsLipQBrbtHvn06wn20bISw
