Advanced Excel & Dashboard Classes in Hindi with Sujeet Sir
Learn Complete Advanced Excel , >500 Formulas and Dashboard
Updated on Jul, 2024
Language - Hindi
Advance Excel,Data Analysis,Excel Dashboard
Lectures -102
Resources -24
Duration -30.5 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Advanced Excel & Dashboard Classes in Hindi with Sujeet Sir
Course Overview:
This course is designed to take your Excel skills to an advanced level, enabling you to create dynamic and insightful dashboards. Taught entirely in Hindi by Sujeet Sir, an experienced Excel trainer, this course caters to both professionals looking to enhance their data analysis capabilities and students aiming to build a strong foundation in Excel.
Key Features:
- Language: Hindi
- Instructor: Sujeet Sir
- Format: Online/Offline (based on availability)
- Duration: 40 hours (approx.)
Course Content:
Introduction to Advanced Excel
- Recap of Basic Excel Functions
- Understanding Excel Interface and Shortcuts
- Customizing the Ribbon and Quick Access Toolbar
Advanced Formulas and Functions
- Logical Functions (IF, AND, OR)
- Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
- Text Functions (LEFT, RIGHT, MID, CONCATENATE)
- Date and Time Functions
- Array Formulas
Data Analysis Tools
- Data Validation
- Conditional Formatting
- Pivot Tables and Pivot Charts
- Data Consolidation and Summarization
Advanced Charting Techniques
- Creating and Customizing Charts
- Combo Charts
- Sparklines
- Using Charts for Data Visualization
Introduction to Dashboards
- What is a Dashboard?
- Designing Principles and Best Practices
- Components of a Dashboard
Creating Interactive Dashboards
- Using Form Controls (Drop-downs, Buttons, Sliders)
- Linking Controls to Data
- Dynamic Charting Techniques
- Creating Interactive Reports
Advanced Data Management
- Using Power Query for Data Transformation
- Data Cleaning Techniques
- Combining Data from Multiple Sources
Automation with Macros
- Introduction to Macros
- Recording and Running Macros
- Basic VBA for Automation
Case Studies and Real-life Applications
- Hands-on Projects
- Real-life Scenarios and Problem-Solving
Benefits of the Course:
- Gain proficiency in advanced Excel functions and tools
- Learn to create professional and interactive dashboards
- Enhance your data analysis and visualization skills
- Improve efficiency with Excel automation techniques
- Access to course materials and practice files
- Certification of completion
Goals
Benefits of the Course:
- Gain proficiency in advanced Excel functions and tools
- Learn to create professional and interactive dashboards
- Enhance your data analysis and visualization skills
- Improve efficiency with Excel automation techniques
- Access to course materials and practice files
- Certification of completion
Prerequisites
Course Prerequisites
Before enrolling in the Advanced Excel & Dashboard Classes in Hindi with Sujeet Sir, it is recommended that participants have the following prerequisites:
Basic Excel Knowledge:
- Understanding of basic Excel functions and formulas.
- Familiarity with Excel interface and navigation.
- Ability to create and format simple spreadsheets.
Computer Literacy:
- Basic understanding of using a computer, including file management (opening, saving, and organizing files).
- Familiarity with operating systems such as Windows or macOS.
Access to Microsoft Excel:
- Participants should have Microsoft Excel installed on their computer. The course will be based on the latest version of Excel, but users of older versions can also follow along with minor adjustments.
Interest in Data Analysis:
- A keen interest in data analysis, visualization, and reporting will be beneficial as the course will delve into these areas extensively.
Basic Knowledge of Mathematics:
- Understanding basic mathematical concepts and operations will be helpful in comprehending Excel formulas and functions.
While these prerequisites will help participants make the most of the course, those without them but willing to learn and practice diligently can still benefit significantly. Sujeet Sir will provide guidance and support to ensure all participants can follow along and succeed.
Curriculum
Check out the detailed breakdown of what’s inside the course
1. Most use full Feature
13 Lectures
-
2 Data Selection
32:11
32:11
-
8- Picture Lookup
23:41
23:41
-
10 Custom Formatting - Q Solution
14:08
14:08
-
11 Conditional Formatting
24:58
24:58
-
11 Conditional Formatting - Q Solution
12:02
12:02
-
12 Protection
15:02
15:02
-
13 - Data FILL
13:55
13:55
-
14 - Data Short.
12:16
12:16
-
15 - FILTER Data
08:14
08:14
-
16 - Analise Data
05:51
05:51
-
Test-1
05:32
05:32
-
Test-1-File
-
Test-1 - Solution
10:38
10:38
2.Dashboard Report with Pivot Table
12 Lectures
3.Function / Formulas
26 Lectures
Advanced Formulas
7 Lectures
Dashboard-with formulas
5 Lectures
Report Automation with Formulas
8 Lectures
Data Management - Data Menu Bar
8 Lectures
Dynamic-Charts
8 Lectures
Real-Life Problem
15 Lectures
Instructor Details
Sujeet Kumar Advanced Excel Training in Hindi
I worked On Excel from 2003. I have also work more then 10 Company as MIS Executive and VBA Developer. I tried to give best in Excel . Now I work for 40 Company as Report Consultant. I give Every Example related to your work. With me you not Learn Only Excel Learn also Official Real Time Problem Solution
My Slogan - Not Do Hard Work . Do Smart Work - मेहनत तो गधा भी करता है
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now