Lookup Functions, Advanced Charts and Pivot tables (Udemy.com)
Excel charts and pivotes made it easy
Created by: MKCL India
Last updated March 2019
What you will learn
- Tools to automate, streamline, and absolutely revolutionize your workflow with Excel
- Maintain large sets of Excel data in a list or table
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.3 out of 5higher than 13% of them
- Reviews681#206 of 356 by number of reviews
- Length1.6 hoursshorter than 88% of them
- Last updatedMarch 2019earlier than 79% of them
Course Description
Graphics, images, and charts are great ways to visualize and represent the data, and Excel does exactly same thing for us by automatically creating the charts. After you enroll and complete this course, you will be proficient in all kinds of charts in Excel: Bar Charts, Column Charts, Line Charts, Pie Charts, Area Charts, X Y Scatter Charts, Bubble Charts. You will be able not only to create these charts in Excel, but also to format them quickly and easily.
This course also provides an in-depth coverage of pivot tables and pivot charts. These are two of the powerful data analysis tools in Excel's arsenal, and they should definitely be mastered by anyone who aspires to becoming an Excel “power user. Pivot Tables and Pivot Charts allow you to dynamically reorganize and display your data in many different ways and they help you get meaningful information from large amounts of data.
Instructor Details
- 4.3 Rating
681 Reviews
MKCL India
We are an eLearning company with more than 20 million learners for our courses. Our expertise is in creating eLearning courses which are self paced and rich in instructional design. We focus on the principles of 'learning by doing' in the courses by teaching the concepts and the tools while creating projects or assets.
More courses by MKCL India
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Kimberly M. Douglas on 6/14/2023
Very happy with all the info and teachings, was very informative - just wish the free version gave you a certificate of completion
By Sri vishnu valiveti on 6/14/2022
Taught with the right pace but nested V lookup could be a little more simplified or elaborated as I am watching it for 2nd time
By KAVITA SHETTY on 8/5/2021
Beautifully explained, infact I had completed the entire MS-CIT course from this Institute.
By Stefan Obermeier on 4/17/2021
First chapter was fine but the other were to short. It is not a good idea to make chapters of less than one minute in length. I did not finish the course because of that.
By VIGNESH on 3/29/2021
The explanation is really outstanding which anyone can understand easily.
By Siddhi Chari on 8/17/2020
The content is very good. But the videos inbetween are blur. So little difficult to understand. Rest everything good. Thanks
By Antoinette Sanders on 8/9/2020
I have gotten to the upper management level, have worked for various industries. However, I admit I am better with systems than working with excel. Excel has caused me jobs in the past. I am use to systems with large data and working with Business Intelligence but working with Raw Data is a problem creating V-Lookups and Pivot Tables.
By Abhijit Mathkari on 2/12/2020
The course is good to understand the excel function, if you would have provided excel files for practice that would have been better.
By Chanda Kaushik on 10/17/2019
It would have been great if demo files were shared for the students to practice at. Also, lots of concepts were discussed theoretically without any practical demo. Overall an average course. It could have been better.
By Bobbie Smith on 9/8/2018
Great course. Very informative and presented. Well worth taking. Thank you.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 86 / 100








