![My E-Lesson](/img/default-banner.jpg)
- 1 493
- 66 691 041
My E-Lesson
India
Registrace 30. 03. 2011
Myelesson offers more than 550 video to help you learn Excel , MS Word , PowerPoint and VBA. All these MS Office product videos are in Hindi and English. The training videos are very informative , easy to understand hilariously funny .
All the training videos are clearly categorized under playlist like
1. Excel Training videos for Beginners
2. Excel Training videos for Intermediate users
3. Excel training videos for Advanced users
4. MS Word Training videos
5. MS PowerPoint Training videos
Usually 4 videos per week are uploaded in the Excel , MS Word and PowerPoint training series
My aim is help people enhance skills required in day to office work and in this endeavor i would require your help too , in terms of spreading the word .
Please email at account@myelesson.org for any queries related to
1 Advertisments
2 Collaboration
3 Getting Custom Videos From Us
4 Voiceovers
5 Buying Our Courses
Love & Respect
Guru
All the training videos are clearly categorized under playlist like
1. Excel Training videos for Beginners
2. Excel Training videos for Intermediate users
3. Excel training videos for Advanced users
4. MS Word Training videos
5. MS PowerPoint Training videos
Usually 4 videos per week are uploaded in the Excel , MS Word and PowerPoint training series
My aim is help people enhance skills required in day to office work and in this endeavor i would require your help too , in terms of spreading the word .
Please email at account@myelesson.org for any queries related to
1 Advertisments
2 Collaboration
3 Getting Custom Videos From Us
4 Voiceovers
5 Buying Our Courses
Love & Respect
Guru
How To Create Pivot Table in Excel
Download Practice Files from www.myelesson.org/excel/hindi/pivot-table-for-beginners-in-excel
"Welcome to our deep dive into mastering Pivot Tables in Excel! In this video, we’ll walk you through everything you need to know about Pivot Tables-from the basics to advanced techniques-all using a real-world sales dataset that we've provided for you to download and practice along.
What You’ll Learn:
Pivot Table Basics: Learn how to create a Pivot Table from scratch, including selecting your data, choosing fields, and setting up your layout.
Data Summarization: Discover how to quickly summarize large datasets by region, product category, salesperson, and more.
Filtering and Sorting: See how easy it is to filter and sort your data within a Pivot Table to find key insights.
Grouping Data: Learn how to group your data by date, product type, or other categories to analyze trends over time.
Advanced Features: We’ll cover advanced techniques like creating calculated fields, using slicers for quick filtering, and generating Pivot Charts for dynamic data visualization.
Real-World Application: Follow along with a comprehensive sales dataset that mimics real business scenarios, allowing you to practice and apply what you learn.
Why Pivot Tables?
Pivot Tables are a game-changer for anyone who works with data. They allow you to easily transform large, complex datasets into insightful reports without needing complicated formulas. Whether you’re an analyst, student, or business professional, mastering Pivot Tables will significantly boost your productivity and analytical skills.
Download the Dataset
To get the most out of this tutorial, download the accompanying sales dataset linked in the description. Practice creating your own Pivot Tables and explore the endless possibilities of data analysis in Excel.
Who Is This Video For?
This video is perfect for Excel beginners who want to learn Pivot Tables from the ground up, as well as for intermediate users looking to refine their skills and discover new features.
If you find this tutorial helpful, don’t forget to like, subscribe, and hit the notification bell for more Excel tips and tricks!
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel-czcams.com/video/KyMj8HEBNAk/video.html
Learn Basic Excel Skills For Beginners- czcams.com/video/3kNEv3s8TuA/video.html
Learn the Basic of Excel for Beginners -czcams.com/video/qeMSV9T1PoI/video.html
10 Most Used Excel Formula-czcams.com/video/2t3FDi98GBk/video.html
Learn Vlookup Formula For Beginners in Excel-czcams.com/video/vomClevScJQ/video.html
5 Excel Questions Asked in Job Interviews-czcams.com/video/7Iwx4AMdij8/video.html
Create Speedometer Chart In Excel-czcams.com/video/f6c93-fQlCs/video.html
Create Pareto Chart In Excel-czcams.com/video/2UdajrDMjRE/video.html
How to Create Dashboard in Excel-czcams.com/video/RM8T1eYBjQY/video.html
Excel Interview Questions & Answers-czcams.com/video/Zjv1If63nGU/video.html
To watch more videos and download the files visit www.myelesson.org
Connect with us on Facebook - excelmadeasy/
Connect with us on Twitter - Excelmadeasy
"Welcome to our deep dive into mastering Pivot Tables in Excel! In this video, we’ll walk you through everything you need to know about Pivot Tables-from the basics to advanced techniques-all using a real-world sales dataset that we've provided for you to download and practice along.
What You’ll Learn:
Pivot Table Basics: Learn how to create a Pivot Table from scratch, including selecting your data, choosing fields, and setting up your layout.
Data Summarization: Discover how to quickly summarize large datasets by region, product category, salesperson, and more.
Filtering and Sorting: See how easy it is to filter and sort your data within a Pivot Table to find key insights.
Grouping Data: Learn how to group your data by date, product type, or other categories to analyze trends over time.
Advanced Features: We’ll cover advanced techniques like creating calculated fields, using slicers for quick filtering, and generating Pivot Charts for dynamic data visualization.
Real-World Application: Follow along with a comprehensive sales dataset that mimics real business scenarios, allowing you to practice and apply what you learn.
Why Pivot Tables?
Pivot Tables are a game-changer for anyone who works with data. They allow you to easily transform large, complex datasets into insightful reports without needing complicated formulas. Whether you’re an analyst, student, or business professional, mastering Pivot Tables will significantly boost your productivity and analytical skills.
Download the Dataset
To get the most out of this tutorial, download the accompanying sales dataset linked in the description. Practice creating your own Pivot Tables and explore the endless possibilities of data analysis in Excel.
Who Is This Video For?
This video is perfect for Excel beginners who want to learn Pivot Tables from the ground up, as well as for intermediate users looking to refine their skills and discover new features.
If you find this tutorial helpful, don’t forget to like, subscribe, and hit the notification bell for more Excel tips and tricks!
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel-czcams.com/video/KyMj8HEBNAk/video.html
Learn Basic Excel Skills For Beginners- czcams.com/video/3kNEv3s8TuA/video.html
Learn the Basic of Excel for Beginners -czcams.com/video/qeMSV9T1PoI/video.html
10 Most Used Excel Formula-czcams.com/video/2t3FDi98GBk/video.html
Learn Vlookup Formula For Beginners in Excel-czcams.com/video/vomClevScJQ/video.html
5 Excel Questions Asked in Job Interviews-czcams.com/video/7Iwx4AMdij8/video.html
Create Speedometer Chart In Excel-czcams.com/video/f6c93-fQlCs/video.html
Create Pareto Chart In Excel-czcams.com/video/2UdajrDMjRE/video.html
How to Create Dashboard in Excel-czcams.com/video/RM8T1eYBjQY/video.html
Excel Interview Questions & Answers-czcams.com/video/Zjv1If63nGU/video.html
To watch more videos and download the files visit www.myelesson.org
Connect with us on Facebook - excelmadeasy/
Connect with us on Twitter - Excelmadeasy
zhlédnutí: 457
Video
How to Take Screenshot in Windows 11
zhlédnutí 307Před 12 hodinami
How to Take Screenshot in Windows 11 #windows11 Welcome to our comprehensive tutorial on mastering the Snipping Tool in Windows 11! Whether you're new to Windows 11 or just looking to sharpen your skills, this video will guide you through every aspect of using the Snipping Tool. In this video, you’ll learn: How to Open the Snipping Tool: Explore multiple ways to launch the Snipping Tool, includ...
Create Expense Tracker in Excel Hindi
zhlédnutí 385Před dnem
Create Expense Tracker in Excel Hindi. Download Practice Files from www.myelesson.org/excel/hindi/create-expense-tracker-in-excel Welcome to our step-by-step guide on creating a Monthly Expense Tracker in Excel! In this video, we will walk you through the process of setting up a comprehensive expense tracker to help you manage your budget effectively. Whether you're looking to categorize your e...
Attendance Tracker in Excel Hindi
zhlédnutí 585Před 14 dny
Download Practice Files from www.myelesson.org/excel/hindi/create-attendance-sheet-in-excel How to Create an Employee Attendance Tracker in Excel Tracking employee attendance is crucial for any organization, ensuring that management is aware of who is present, absent, on leave, or working from home. Excel is a powerful tool that can simplify this process, providing a clear and organized way to ...
Overtime Calculation in Excel: Step-by-Step Guide in Hindi
zhlédnutí 605Před 14 dny
Download Practice Files from www.myelesson.org/excel/hindi/overtime-calculator-in-excel Learn how to calculate employee overtime pay in Excel with this easy-to-follow tutorial! We'll show you how to set up your spreadsheet, input data, and use formulas to automatically calculate regular and overtime hours, as well as the total pay for each employee. Perfect for managers and HR professionals loo...
The Richest Man in Babylon Book Summary Hindi
zhlédnutí 353Před 21 dnem
"The Richest Man in Babylon" का विस्तृत अध्यायवार सारांश हिंदी में प्रस्तुत किया गया है:"The Richest Man in Babylon" का विस्तृत अध्यायवार सारांश हिंदी में प्रस्तुत किया गया है: अध्याय 1: सोने की इच्छा रखने वाला व्यक्ति इस अध्याय में बंसीर का परिचय दिया गया है, जो बेबीलोन का एक रथ निर्माता है और कड़ी मेहनत के बावजूद अपनी वित्तीय स्थिति से असंतुष्ट है। वह अपनी निराशा अपने मित्र कोबी, एक संगीतकार,...
Stock Inventory Management Software in Excel Hindi
zhlédnutí 638Před 21 dnem
Download Practice Files from www.myelesson.org/excel/hindi/stock-management-in-excel Learn how to create a comprehensive inventory management system in Excel with our step-by-step guide. Perfect for small businesses, this tutorial covers setting up inventory and sales worksheets, using formulas to update stock levels, and automating reorder alerts. Streamline your stock management and make info...
Calculate Income Tax in Excel 2024
zhlédnutí 965Před 28 dny
Download Practice Files from www.myelesson.org/excel/hindi/calculate-income-tax-in-excel-2024 Calculate Income Tax in Excel 2024 Useful Excel formulas and Functions 10 Most Used Formulas MS Excel-czcams.com/video/KyMj8HEBNAk/video.html Learn Basic Excel Skills For Beginners- czcams.com/video/3kNEv3s8TuA/video.html Learn the Basic of Excel for Beginners -czcams.com/video/qeMSV9T1PoI/video.html 1...
Use Voolkup to Compare 2 lists in Excel
zhlédnutí 519Před měsícem
Download Practice Files from www.myelesson.org/excel/hindi/compare-2-lists-in-excel-592 Use Voolkup to Compare 2 lists in Excel Using VLOOKUP (Vertical Lookup) in Excel to match two lists has several benefits: 1. Simplifies Data Retrieval : VLOOKUP allows you to easily search for a value in one list and retrieve corresponding information from another list, saving time and effort compared to man...
Find and Remove Duplicate Values in Excel Hindi
zhlédnutí 526Před měsícem
Download Practice Files from www.myelesson.org To find and highlight (not remove directly) duplicates in Excel using conditional formatting, you can follow these steps: 1. Select the Range: Click on the top-left cell of the range where you want to check for duplicates. 2. Open Conditional Formatting: Go to the `Home` tab on the Excel ribbon. 3. Apply Conditional Formatting: - Click on `Conditio...
Dashboard in Excel Hindi
zhlédnutí 827Před měsícem
Dashboard in Excel in Hindi .Download Practice Files from www.myelesson.org/downloads Dashboards in Excel offer several benefits that make them invaluable for data analysis and reporting: 1. Data Visualization : Dashboards provide a visual representation of complex data sets, making it easier to interpret trends, patterns, and outliers at a glance. 2. Centralized Information : They consolidate ...
VLOOKUP Multiple Results at Once for a Value
zhlédnutí 1,1KPřed měsícem
Download Practice Files from www.myelesson.org/downloads Welcome to our Excel tutorial! In this video, we will show you how to use the powerful combination of the VLOOKUP and COLUMNS formulas to look up multiple results for a single parameter in Excel. This technique is perfect for those who need to extract more than just the first matching result from a dataset. In this video, you'll learn: 1....
Create Thank you Slide with Animation हिंदी
zhlédnutí 2,9KPřed 2 měsíci
Download Practice Files from www.myelesson.org/downloads . Learn how to create a stunning animated "Thank You" slide in Microsoft PowerPoint with this easy-to-follow tutorial! Perfect for presentations, this step-by-step guide will help you add a professional touch to your slides with dynamic motion effects and elegant design elements. How to set up a new PowerPoint slide. Tips for inserting an...
Project Management : What is a Work Breakdown Structure
zhlédnutí 435Před 2 měsíci
Q: What is a Work Breakdown Structure (WBS)? A: A Work Breakdown Structure (WBS) is a key project management tool used to organize and define the total scope of a project. It involves breaking down the project into smaller, more manageable components. This hierarchical decomposition makes it easier to plan, execute, and control the project. Key Characteristics of a WBS: 1. Hierarchical Decompos...
5 Steps To Create Amazing PowerPoint Presentation
zhlédnutí 670Před 2 měsíci
5 Steps To Create Amazing PowerPoint Presentation
Best Way to Create PowerPoint Presentation in 5 minutes
zhlédnutí 1,5KPřed 3 měsíci
Best Way to Create PowerPoint Presentation in 5 minutes
Create Dashboard in Excel With Slicers Hindi
zhlédnutí 1,2KPřed 3 měsíci
Create Dashboard in Excel With Slicers Hindi
If Formula in Excel | Step by Step for Beginners
zhlédnutí 854Před 4 měsíci
If Formula in Excel | Step by Step for Beginners
VLOOKUP in Excel [Beginner's Guide & 3 Powerful Use Cases]
zhlédnutí 983Před 5 měsíci
VLOOKUP in Excel [Beginner's Guide & 3 Powerful Use Cases]
Learn Excel : Master the 5 Essential Math Functions in Excel!
zhlédnutí 697Před 5 měsíci
Learn Excel : Master the 5 Essential Math Functions in Excel!
Advanced Custom Formatting Set pass fail status Hindi
zhlédnutí 989Před 9 měsíci
Advanced Custom Formatting Set pass fail status Hindi
Master PowerPoint: The Ultimate Full Course with All the Essential Topics Hindi ✅
zhlédnutí 799Před 10 měsíci
Master PowerPoint: The Ultimate Full Course with All the Essential Topics Hindi ✅
Excel Tutorial for Beginners to Advanced |Excel Hindi | Excel Formulas and Functions | Myelesson
zhlédnutí 1KPřed 10 měsíci
Excel Tutorial for Beginners to Advanced |Excel Hindi | Excel Formulas and Functions | Myelesson
Dashboards for Beginners in Excel Hindi New
zhlédnutí 2,9KPřed rokem
Dashboards for Beginners in Excel Hindi New
Hindi Excel Tutorial: How to Separate Text and Numbers in a Column (Step-by-Step Guide)
zhlédnutí 2KPřed rokem
Hindi Excel Tutorial: How to Separate Text and Numbers in a Column (Step-by-Step Guide)
How to Sum Comma Separated Values in Cell in Excel in Hindi
zhlédnutí 3,1KPřed rokem
How to Sum Comma Separated Values in Cell in Excel in Hindi
Project Plan with Timeline in Excel Hindi
zhlédnutí 2,4KPřed rokem
Project Plan with Timeline in Excel Hindi
a good lesson
Your lesson is really helpful for my career.
Welcome Saalim
I really appreciate for your help. Thank you!
@15 I’ll post a picture of my OC on my CZcams
Wow Itself Really Attractive And I Need More ❤
Awesome👍👍👍 sir
Thanks and welcome Sushil
Very nice... informative
Thank you Umar Farooque
You are great
Thank you Sripad for the love
Textjoin is helpful as well
Phuck Hindi, made video in english
Thanks ❤
You're welcome 😊
iska link to nhi hai this video is no useful
Thank you so much for this, you are audible and teach very well. I have been struggling to find online lessons that are clear and straight to the point.
In any language you speak... And are we supposed to learn it in order to understand
=vlookup(mid(az2,2,2)+,0,ba2:bb10)
Bade baklol lag rahe ho
Good
This is precisely what I was seeking. It's straightforward, with examples right from the start. I frequently find myself losing interest quickly, especially if things are repetitive. I was happily surprised that 30 minutes felt effortless. Thank you!
Thanks
You deserve a comment just because of how happy you are about this! What a great video :)
Thanks
9:14
Thoughts that shape me A mind that's awake Teaching me, learning me A creation in the making
Thoughts that shape me A mind that's awake Teaching me, learning me A creation in the making
Amazing 😊
Thanks Ayesha
Sir Excel 2007 me analyze tab and insert slicer option kaha milega
thankyou very much sir , is video ne bahut help ki hai meri , very very thankful to you
F4 kaise kiya o samjme nhi aya
Toggling Cell References: When you're entering or editing a formula, pressing F4 toggles between different types of cell references: Absolute Reference ($A$1): Both the row and column are fixed. Mixed Reference (A$1 or $A1): Either the row or the column is fixed. Relative Reference (A1): Neither the row nor the column is fixed. This is particularly useful when you want to lock certain references while copying formulas across cells.
@@GuruJii thank you
Thank you Guru love from Pakistan 🇵🇰
Shukriya Asad Riaz
🤗🤝🤗
🙌
THANK YOU SO MUCH!!!
Nice
I am not able find the excel file to practice this. can anyone please help?
Thank you so much for your kind service
Sir,Aap hi ke videos dekhe the main starting main...I think 2012 main...Jab se aap se inspire hu....❤
Thanks Adil ❤️
@@GuruJii Over time calculation par ek video bana diye Sir
Pls reply I am your big fan sir😊❤
Hello Neeraj. Thank you for the love and support. How are you ?
Hi
Hello
❤ 0:43 0:43 ,, ,,4, ,when ,3,,,,,, 0:43 ,, , ,,,,,,, 0:43 0:43
Sir, live class start kre
Single person ka over time ka batao
The same sheet can be used for single person. Just remove the names of all people except one
Badiya hai
Looking Yummy
Thank you
Ye kya daal diya sir
Copy paste Karnes se pictures nahi aa raha
What is there are two store 2 in column then it doesnt add the two columns but returns for just one column
Sir I want to know how to prepare charts in excel
Sar aapane bahut achcha sikhaya Shikha hai uske liye dhanyvad sar sar aapane Jo padhaayaa uske liye aapko bahut bahut badhai ho sar main anpadh aadami Hun main itna padha likha nahin hun lekin fir bhi aapke is bar mujhe kuchh samajh gaya hun aapko jawab to jante ho ki itne kam se kam matric pass Banda kaise Sikh payega sar lekin aapko shikayat tarike se sar main bahut impress hua Sab bahut badhiya sar god bless u sar
Good afternoon sir Which Excel version u r using
I am using office 365
Download file - www.myelesson.org/excel/hindi/stock-management-in-excel
Nice explanation
Thanks
Sir thanks so much,can you please share excel sheet link