Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Microsoft Excel Fundamentals to Advanced Skills - हिंदी

person icon Kadhiravan Jayachandiran

4.2

Microsoft Excel Fundamentals to Advanced Skills - हिंदी

Learn A-Z of Microsoft Excel along with using AI tools like ChatGPT to become a pro in Excel.

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Kadhiravan Jayachandiran

category icon Business,Business Analytics and Intelligence,Data Analysis

Lectures -144

Resources -1

Duration -8 hours

Lifetime Access

4.2

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Welcome to our Updated Excel Course for 2024 in Hindi, where we've enhanced our offerings to cater to beginners and advanced users alike and brought examples in Hindi a lot more easier for you to understand. In addition to the comprehensive Excel content previously mentioned, we are excited to introduce new features to elevate your Excel skills even further, with a special emphasis on AI-driven learning for Excel Formulas.

New Features:


  1. AI-Driven Learning for Excel Formulas:

    • Dive into the future of Excel learning with our cutting-edge AI-driven modules. Leverage artificial intelligence to enhance your understanding of complex formulas, receive personalized insights, and optimize your Excel workflow. Uncover the power of AI as a companion in your data analysis journey.

  2. How to Use ChatGPT for Excel Complex Situations:

    • Unlock the full potential of ChatGPT to navigate intricate Excel scenarios. Learn how to seamlessly integrate AI assistance for problem-solving, formula optimization, and gaining insights into unique challenges you may encounter in your data analysis journey.

  3. Expanded Excel Formulas Module:

    • Delve deeper into Excel formulas with an additional 20 formulas covering a wide range of situations. From financial calculations to statistical analysis, these formulas will empower you to handle diverse data scenarios with confidence.

  4. Extended Excel Pivot Tables Section:

    • Elevate your data analysis game with an extended section on Excel Pivot Tables, covering 15 different situations. Master the art of summarizing and analyzing large datasets with ease.

  5. AI-Enhanced Excel Dashboarding:

    • Explore the integration of AI in dashboard creation. Learn how to use AI to identify patterns, trends, and outliers in your data, enabling you to design more insightful and dynamic dashboards.

  6. Advanced Charting Techniques:

    • Take your data visualization skills to the next level with advanced charting techniques. Learn to create visually stunning and informative charts that effectively communicate your data insights.

  7. More Practice Sheets:

    • Sharpen your skills with over 20 additional practice sheets, providing hands-on experience and reinforcing the concepts learned throughout the course.

As we step into 2024, Excel proficiency coupled with AI-driven insights is the key to staying ahead in the world of data analysis. Join us in this advanced learning experience, and let's explore the future of Excel together.

-Kadhir
Founder at KultureHire

Goals

  • Become an Excel Formulas master
  • Become a Pivot table advanced user
  • Become confident at using complex Excel formulas
  • Become confident at creating and customising charts

Prerequisites

Basic Knowledge of using computer and Microsoft Excel installed

Microsoft Excel Fundamentals to Advanced Skills - हिंदी

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

2 Lectures
  • play icon Introduction to Excel Course - Hinglish 06:17 06:17
  • play icon Excel Environment and its basics 05:36 05:36

Flash Fill - An Intelligent tool to Manage Data

10 Lectures
Tutorialspoint

Controlling Data Inputs using Data Validation

8 Lectures
Tutorialspoint

Filtering and Sorting Data

12 Lectures
Tutorialspoint

Pivot Tables

24 Lectures
Tutorialspoint

Conditional Formatting

16 Lectures
Tutorialspoint

Excel Functions and Formulas 101

2 Lectures
Tutorialspoint

Basic Aggregation Excel Formulas

8 Lectures
Tutorialspoint

Basic Text Formulas in Excel

9 Lectures
Tutorialspoint

Basic Date Formulas in Excel

5 Lectures
Tutorialspoint

Logical Functions and Operators

3 Lectures
Tutorialspoint

Nested IF

3 Lectures
Tutorialspoint

Vlookup Formula

11 Lectures
Tutorialspoint

Logical Aggregation Formulas in Excel

5 Lectures
Tutorialspoint

Excel Dashboarding

18 Lectures
Tutorialspoint

Advanced AI Use cases with Excel

8 Lectures
Tutorialspoint

Instructor Details

Kadhiravan Jayachandiran

Kadhiravan Jayachandiran

A Microsoft certified Excel Expert (MO 201) with over 10 years of experience in the Recruitment and Analytics Industry.

Having worked for several Multinational companies and startups I understand the importance of Excel in all types of organizations and how it's used differently from one to another.

I use Excel every day, every hour of my life both personal and professional, and have been tutoring this tool for over 13 years.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515