Microsoft Excel - MS Excel Formulas & Functions in just 3hrs

All important Microsoft Excel formulas and functions covered within 3 hours | Must-know MS Excel formulas and functions

4.43 (1451 reviews)
Udemy
platform
English
language
Microsoft
category
Microsoft Excel - MS Excel Formulas & Functions in just 3hrs
47,694
students
3.5 hours
content
Jan 2024
last update
$59.99
regular price

What you will learn

Knowledge of all the essential Excel formulas

Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match

Solid understanding of Microsoft Excel

Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match

Why take this course?

Start using Excel to its full potential to become proficient at your Excel tasks today!

Either you're new to Excel, or you've played around with it but want to get more comfortable with all the popular functions in Microsoft Excel, either way, this course will be great for you.

A Verifiable Certificate of Completion is presented to all students who undertake this Excel course.

Why should you choose this course?

This is a complete and concise tutorial on MS Excel formulas which can be completed within 3 hours. We know that your time is important and hence we have created this fast paced course without wasting time on irrelevant Excel operations.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been using Excel for over a decade.

We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! - Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Solution to Assignment is also shared so that you can review your performance.

What is covered in this course?

This course covers everything you need to crack Excel in the professional work place.

Below are the Excel course contents of this complete and concise course on Microsoft Excel:

  • Introduction - In this video, the structure and contents of the course are discussed.

  • Mathematical Functions - This lecture covers Mathematical formulas such as SUM, AVERAGE,RAND, MIN & MAX, SUMPRODUCT.

  • Textual Formulas - This Excel lecture covers Textual formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID

  • Logical Formulas - This lecture covers Logical formulas such as AND & OR, IF, COUNTIF, SUMIF

  • Date-time (Temporal) Formulas - This lecture covers Date-time related functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS

  • Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH

  • Data Tools - This lecture covers Data operating tools such as Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)

  • Pivot Tables - This Excel lecture covers Pivot tables end-to-end.

Content

Introduction

Introduction
Links

Essential Formulas

Mathematical Functions
Course Resources
Textual Formulas
Logical Formulas
Date-time (Temporal) Formulas
Lookup Formulas

Excel Charts

Excel Charts

Bonus Section

Bonus Lecture

Screenshots

Microsoft Excel - MS Excel Formulas & Functions in just 3hrs - Screenshot_01Microsoft Excel - MS Excel Formulas & Functions in just 3hrs - Screenshot_02Microsoft Excel - MS Excel Formulas & Functions in just 3hrs - Screenshot_03Microsoft Excel - MS Excel Formulas & Functions in just 3hrs - Screenshot_04

Our review

📘 **Course Overview** The course has been well-received by learners, with an impressive average rating of 4.43 out of 5 stars based on recent reviews. The majority of students have found the course beneficial for both beginners and those seeking to deepen their Excel skills. The course content is commended for being clear and easy to follow, providing practical examples that are useful in real-world scenarios. **Pros:** - **Comprehensive Content:** Students have learned a wide range of Excel formulas and functions, which has been very beneficial for both beginners and those looking to enhance their skills. - **Clear Instructions:** The course has been praised for its clear explanations that facilitate learning and understanding. - **Useful Practice Material:** Access to exercises and spreadsheets allows learners to apply what they've learned directly, enhancing retention and practical application of skills. - **Resource Availability:** The provision of resources is appreciated, as it helps learners who may struggle with the content. - **Multilingual Support:** The course offers support in both English and Spanish, which is a significant advantage for non-native English speakers. - **Real-world Application:** Students have highlighted the relevance of the content to real-world situations, making the learning experience practical and useful. **Cons:** - **Pacing Concerns:** Some learners have found the course to be too quick, especially in sections covering complex topics like Vlookup and Pivot tables, which could benefit from a slower pace for better comprehension. - **Accessibility Issues:** A few reviews mention difficulty understanding the instructor's accent, with suggestions that subtitles or clearer articulation would improve understanding. - **Video Quality Variance:** While video tutorials are available, some learners have found them less engaging compared to YouTube resources and have recommended seeking alternative learning materials. - **Exercise Clarity:** A few reviews suggest that some explanations could be clearer and that a more structured approach to learning would be beneficial. - **Technical Challenges:** One learner experienced issues with non-standard data separation in Excel, which was eventually resolved by using provided spreadsheets. **Additional Notes:** - It is recommended that the instructor receives training to improve teaching delivery, with suggestions for a more fluent and slower paced speech. - Some learners have pointed out that similar content can be found on YouTube but highlighted that having structured courses like this one can still offer significant value. In summary, this course has been a valuable resource for many learners looking to improve their Excel skills. While there are some areas for improvement in terms of pacing and instructor presentation, the practical exercises and clear explanations make it a worthwhile course overall. Students are encouraged to practice consistently and take advantage of the resources provided to get the most out of this learning experience.

Coupons

DateDiscountStatus
10/21/2021100% OFF
expired
11/1/2021100% OFF
expired
11/15/2021100% OFF
expired
11/22/2021100% OFF
expired
1/27/2022100% OFF
expired
2/2/2022100% OFF
expired
2/19/2022100% OFF
expired
3/25/2022100% OFF
expired
4/1/2022100% OFF
expired
4/13/2022100% OFF
expired
4/20/2022100% OFF
expired
4/26/2022100% OFF
expired
5/5/2022100% OFF
expired
5/17/2022100% OFF
expired
5/31/2022100% OFF
expired
6/13/2022100% OFF
expired
6/26/2022100% OFF
expired
7/10/2022100% OFF
expired
7/20/2022100% OFF
expired
7/30/2022100% OFF
expired
8/10/2022100% OFF
expired
8/21/2022100% OFF
expired
9/12/2022100% OFF
expired
10/18/2022100% OFF
expired
2/24/2023100% OFF
expired
2/28/2023100% OFF
expired
3/6/2023100% OFF
expired

Charts

Price

Microsoft Excel - MS Excel Formulas & Functions in just 3hrs - Price chart

Rating

Microsoft Excel - MS Excel Formulas & Functions in just 3hrs - Ratings chart

Enrollment distribution

Microsoft Excel - MS Excel Formulas & Functions in just 3hrs - Distribution chart
2443992
udemy ID
7/4/2019
course created date
7/12/2019
course indexed date
Bot
course submited by