Lookup Functions, Advanced Charts and Pivot tables

Excel charts and pivotes made it easy
Rating: 4.5 out of 5 (519 ratings)
11,998 students
English
English [Auto]

Tools to automate, streamline, and absolutely revolutionize your workflow with Excel
Maintain large sets of Excel data in a list or table

Requirements

  • Basic computer operating knowledge
  • Microsoft Excel

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.   

Who this course is for:

  • From beginners, to advanced users, this course is perfect for all ability levels
  • Anyone hoping to expand their analytics skill set, work more efficiently with data

Course content

10 sections96 lectures1h 33m total length
  • Lookup Functions
    12:42
  • Lookup and Reference Functions
    09:34

Instructor

Creating a Knowledge Lit World
MKCL India
  • 4.2 Instructor Rating
  • 6,885 Reviews
  • 122,116 Students
  • 27 Courses

We are an eLearning company with more than 10 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.