Lookup Functions, Advanced Charts and Pivot tables – Free Udemy Courses

Graphics, images, and charts are great ways to visualize and represent the data, and Excel does the the 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, and 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 in-depth coverage of pivot tables and pivot charts. These are two of the most powerful data analysis tools in Excel’s arsenal, and they should be mastered by anyone who aspires to become 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.