Go from basic to advance in MS-Excel and get mastered in utilizing two of the powerful data analysis tools in Excel’s arsenal – Pivot Tables and Pivot Charts
This course will provide you with all the practical knowledge on how to create advanced charts and pivot tables in MS Excel. Also, it’ll help you in understanding the complexities involved in it. Each and every concept in this course has been visually described and elaborated, in order to make it easy for you to understand and learn.
This course has 93 videos in total and will take you through all of these in just 1 hour. You can watch the videos at your own pace and accordingly can raise doubts or questions if you get stuck. There are only 2 basic requirement to enroll in this course, that is:
- Computer operating knowledge
- Microsoft Excel
Concepts covered in this course:
- In-depth coverage of pivot tables and pivot charts
- All kinds of charts in Excel: Bar Charts, Column Charts, Line Charts, Pie Charts, Area Charts, X Y Scatter Charts, Bubble Charts.
Layout of this course will be:
- Introduction to Pivot chart and tables – Basics
- Types of charts – Discover the types of charts present in MS Excel
- Sub-types of charts and its uses
- Modifying charts
- Chart Templates
- Sparklines
- Pivot charts
- Pivot tables
Some exceptional benefits associated with this course enrollment are:
- Quality course material on MS Excel
- Lifetime access to the course
- Instant & free course updates
- Access to all Questions & Answers initiated by other students as well
- Personalized support from the instructor’s end on any issue related to the course
- Few free lectures for a quick overview
Be it a working professional or a student, this course will be helpful to all. Don’t miss on this unique opportunity and enroll today itself!!
Curriculum
- 8 Sections
- 93 Lessons
- 52 Weeks
- Introduction to Pivot chart and tables1
- Types of charts8
- Sub-types of charts and its uses28
- 3.1Objective1 Minute
- 3.1Bubble chart1 Minute
- 3.1Stock charts with volumes1 Minute
- 3.1Creating a open-high-low – close chart1 Minute
- 3.1Varying period1 Minute
- 3.1Formatting a stock chart1 Minute
- 3.1Creating a high-low – close chart1 Minute
- 3.1Organization of data1 Minute
- 3.1Types of stock charts1 Minute
- 3.1Stock charts1 Minute
- 3.1Displaying legends1 Minute
- 3.1Coloring bubbles1 Minute
- 3.1Creating bubble chart1 Minute
- 3.1Types of scatter chart1 Minute
- 3.1Area Chart1 Minute
- 3.1Scatter chart with lines and markers1 Minute
- 3.1Line chart vs Scatter chart – part 21 Minute
- 3.1Line chart vs Scatter chart – part 11 Minute
- 3.1Using trendlines1 Minute
- 3.1Creating Scatter chart1 Minute
- 3.1What is regression analysis ?1 Minute
- 3.1Data plotting1 Minute
- 3.1Scatter chart1 Minute
- 3.1Stacked area chart1 Minute
- 3.1Making areas transparent1 Minute
- 3.13D Area chart1 Minute
- 3.1Converting area chart into line chart1 Minute
- 3.1Summary1 Minute
- Modifying charts16
- 4.1Objective1 Minute
- 4.1Surface chart1 Minute
- 4.1Types of surface charts1 Minute
- 4.1Creating a surface chart1 Minute
- 4.1Wireframe 3-D Surface chart1 Minute
- 4.1Contour chart1 Minute
- 4.1Wireframe contour chart1 Minute
- 4.1Radar chart1 Minute
- 4.1Creating a Radar chart1 Minute
- 4.1Types of Radar chart1 Minute
- 4.1Combination chart1 Minute
- 4.1Creating a combination chart1 Minute
- 4.1Changing chart type1 Minute
- 4.1Adding titles to vertical axes1 Minute
- 4.1Applying chart styles1 Minute
- 4.1Summary1 Minute
- Chart Templates8
- Sparklines15
- 6.1Objective1 Minute
- 6.1What are sparklines?1 Minute
- 6.1Sparklines vs charts1 Minute
- 6.1Types of sparklines1 Minute
- 6.1Creating sparklines1 Minute
- 6.1Altering the design of sparklines1 Minute
- 6.1Sparkline group vs individual sparklines2 Minutes
- 6.1Removing sparklines1 Minute
- 6.1Comparing sparklines with a group1 Minute
- 6.1Modifying display range2 Minutes
- 6.1Dealing with empty cells1 Minute
- 6.1Empty cells – option 230 Minutes
- 6.1Empty cells – option 31 Minute
- 6.1Data in hidden rows and columns1 Minute
- 6.1Summary1 Minute
- Pivot charts8
- Pivot table9
- 8.1Objective1 Minute
- 8.1Creating pivot table1 Minute
- 8.1Multiple fields in row, column or data section2 Minutes
- 8.1Creating pivot charts1 Minute
- 8.1Creating and using calculated fields2 Minutes
- 8.1Adding and using data slicer1 Minute
- 8.1Using the new timeline filter option1 Minute
- 8.1Pivot table styles1 Minute
- 8.1Summary1 Minute
We are an E-learning company with more than 10 million learners for our courses. Our expertise is in creating e- learning courses which are self paced and rich in instructional design. We focus on principles of 'learning by doing'in the courses by teaching the concepts and tools while creating projects or assets.
Courses you might be interested in
-
15 Lessons
-
10 Lessons
-
13 Lessons
-
39 Lessons