Let's Excel With Microsoft Excel
Let's Excel With Microsoft Excel, available at $19.99, has an average rating of 3.95, with 35 lectures, based on 32 reviews, and has 118 subscribers.
You will learn about Learn & understand Microsoft Excel starting from Foundations to Most Advanced Functionalities such as Advanced Formulae, Power Pivot, Power Query, Etc. Learn about functionality of each button given in Microsoft Excel's Ribbon with the use of practical examples. Learn & master frequently-used shortcut keys and formulae to accelerate your efficiency & career. Learn to create interactive & communicative reports with the help of Pivot Tables, Charts, Slicers, Power Pivot, Power Query, Etc. Learn to use several functionalities available under Power Query to enhance efficiency & perform work faster. This course is ideal for individuals who are Students & Freshers who want to learn & understand Microsoft Excel starting from Fundamentals to Advanced Level. or Professionals who want to learn & understand the Advanced functionalities of Microsoft Excel such as Advanced Formulae, Power Pivot, Power Query, Etc. It is particularly useful for Students & Freshers who want to learn & understand Microsoft Excel starting from Fundamentals to Advanced Level. or Professionals who want to learn & understand the Advanced functionalities of Microsoft Excel such as Advanced Formulae, Power Pivot, Power Query, Etc.
Enroll now: Let's Excel With Microsoft Excel
Summary
Title: Let's Excel With Microsoft Excel
Price: $19.99
Average Rating: 3.95
Number of Lectures: 35
Number of Published Lectures: 35
Number of Curriculum Items: 35
Number of Published Curriculum Objects: 35
Original Price: ₹999
Quality Status: approved
Status: Live
What You Will Learn
- Learn & understand Microsoft Excel starting from Foundations to Most Advanced Functionalities such as Advanced Formulae, Power Pivot, Power Query, Etc.
- Learn about functionality of each button given in Microsoft Excel's Ribbon with the use of practical examples.
- Learn & master frequently-used shortcut keys and formulae to accelerate your efficiency & career.
- Learn to create interactive & communicative reports with the help of Pivot Tables, Charts, Slicers, Power Pivot, Power Query, Etc.
- Learn to use several functionalities available under Power Query to enhance efficiency & perform work faster.
Who Should Attend
- Students & Freshers who want to learn & understand Microsoft Excel starting from Fundamentals to Advanced Level.
- Professionals who want to learn & understand the Advanced functionalities of Microsoft Excel such as Advanced Formulae, Power Pivot, Power Query, Etc.
Target Audiences
- Students & Freshers who want to learn & understand Microsoft Excel starting from Fundamentals to Advanced Level.
- Professionals who want to learn & understand the Advanced functionalities of Microsoft Excel such as Advanced Formulae, Power Pivot, Power Query, Etc.
‘Let’s Excel with Microsoft Excel’ course would take you through 6 levels:
1. Introduction to Microsoft Excel
2. Basic data entry & understanding of most-frequently used shortcut keys along-with the reference file of all shortcut keys available in Microsoft Excel
3. Understanding of most-frequently used formulae in Microsoft Excel with the help of practical examples along-with reference file for future reference.
4. Pivot tables & charts with the help of practical examples along-with reference file for future reference.
5. Understanding of functionality of every button given under each main function of the Microsoft Excel’s Ribbon with the use of practical example along-with reference file for future reference.
6. Understanding of advanced functionalities available in Microsoft Excel such as Advanced Formulae, What-if Analysis, Power Pivot, Power Query, Etc.
WHY YOU SHOULD SPECIFICALLY TAKE THIS COURSE?
This course would particularly help you in gaining confidence while working on Microsoft Excel because of the following reasons:
1. The course starts with the discussion of most basic items such as key terminologies used in Microsoft Excel and goes upto the advanced level of using power pivot, power query, Etc.
2. The course includes understanding of functionality of every button available in Microsoft Excel’s Ribbonwith the help of practical example
3. Microsoft Excel & PPT files have been attachedwith the lectures for better understanding as well as future reference.
4. The lectures have been sequentially designed so as to understand all the items in a structured manner.
5. The lectures have been divided into 35 video-lectures with an average duration of 4 mins each for ease of learning & reference.
6. Lifetime Access to the course once you are enrolled.
7. A Verifiable Certificate of Completion is presented to all enrollers who undertake this MS Excel course.
After the completion of this course, you will learn & understand the utility of Microsoft Excel and would be confident while using it in your professional as well as personal lives.
SHOULD YOU TAKE THIS COURSE IF YOU ARE A BEGINNER OR NOT A BEGINNER?
Yes.
The course starts with the understanding of most basic items such as key terminologies used in Microsoft Excel, however it also goes upto the advanced level such as understanding of what-if analysis, power pivot, power query, Etc.
Also, this course includes the understanding of functionality of every button available in Microsoft Excel’s Ribbon with the help of practical examples. A lot of these functionalities are not known to people who have been using Microsoft Excel for a long period of time and these functionalities would help you increase your efficiency and effectiveness.
WHAT YOU’LL BE ABLE TO LEARN?
By the end of this course, you’ll be confident in showcasing your Microsoft Excel skills in your personal as well as professional lives, allowing you to:
1. Understand utility of Microsoft Excel in personal as well as professional lives
2. Input, analyze & manage data to make informed decisions
3. Use Microsoft Excel hacks to perform your work faster and with more efficiency
4. Create interactive & communicative reports by using Pivot Tables, Charts, Power Pivot, Power Query Etc.
5. Be comfortable with use of frequently-used shortcut keys, formulae along-with some advanced formulae.
6. Automate your day-to-day Microsoft Excel tasks by mastering the power of Macros
Now, if you would like to understand the overall layout and feel of the course, I would request you to go through the preview video of the course.
However, before that, I assure you that this course would be a fun and learning experience for you and it would transform the way you work with numbers.
Enroll for this course to experience yourself how such a vast and detailed tool like Microsoft Excel can be understood along with practical examples with the help of 35 video-lecturs with an average duration of 4 mins each.
Thank you!
Course Curriculum
Chapter 1: Introduction to Microsoft Excel
Lecture 1: Introduction to Microsoft Excel
Lecture 2: Key Terminologies Used in the Microsoft Excel
Lecture 3: Main Functions of the Microsoft Excel's Ribbon
Chapter 2: Data Entry and Most Frequently Used Shortcut Keys
Lecture 1: Data Entry & Analysis
Lecture 2: Most Frequently Used Shortcut Keys
Chapter 3: Most Frequently Used Formulae
Lecture 1: Meaning of Formulae & Steps to Apply Formulae
Lecture 2: Most Frequently Used Formulae
Lecture 3: VLOOKUP – Syntax & Rules
Lecture 4: VLOOKUP – Practical Example
Chapter 4: Pivot Tables & Charts
Lecture 1: Basics of Pivot Tables
Lecture 2: Pivot Tables – Practical Example
Lecture 3: Charts
Chapter 5: Special Functionalities Available in the Microsoft Excel
Lecture 1: Special Functionalities – File Tab
Lecture 2: Special Functionalities – Home Tab
Lecture 3: Special Functionalities – Insert Tab
Lecture 4: Special Functionalities – Page Layout Tab
Lecture 5: Special Functionalities – Formulas Tab
Lecture 6: Special Functionalities – Data Tab
Lecture 7: Special Functionalities – Review Tab
Lecture 8: Special Functionalities – View Tab
Lecture 9: Special Functionalities – Help Tab
Lecture 10: Special Functionalities – File Extensions
Chapter 6: Advanced Functionalities available in Microsoft Excel
Lecture 1: Advanced Functionalities – Consolidate Button
Lecture 2: Advanced Functionalities – Relationships & Power Pivot
Lecture 3: Advanced Functionalities – What-if Analysis
Lecture 4: Advanced Functionalities – Forecast Sheet & Outline Section
Lecture 5: Advanced Functionalities – Advanced Formulae & Cell Referencing
Lecture 6: Advanced Functionalities – Microsoft Excel Templates
Lecture 7: POWER QUERY – Text Functions
Lecture 8: POWER QUERY – Date Functions
Lecture 9: POWER QUERY – Merge Tables or VLOOKUP
Lecture 10: POWER QUERY – Merge Queries From Different Workbooks
Lecture 11: POWER QUERY – Find Only Working Days
Lecture 12: Advanced Functionalities – Printing the Workbook
Chapter 7: Course Wrap Up & Next Steps
Lecture 1: Course Wrap Up & Next Steps
Instructors
-
CA Supreet Agrawal
Chartered Accountant (India) & Ex-EY India (Assurance)
Rating Distribution
- 1 stars: 1 votes
- 2 stars: 0 votes
- 3 stars: 3 votes
- 4 stars: 11 votes
- 5 stars: 17 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024