Discover the significance of Pivot Tables and learn the essentials of creating them efficiently. Explore diverse methods for summarizing data and delve into various tools, mastering their implementation for insightful analysis. Gain expertise in style options, insert slicers for enhanced interactivity, and seamlessly change data sources. Understand the importance of refreshing data for dynamic updates. Conclude with a comprehensive summary, ensuring a solid grasp of Pivot Table fundamentals.
Transition seamlessly to Excel Graphs and Charts, where you'll receive a concise introduction to their role in data visualization. Implement and understand various chart types within Excel workbooks, concluding the course with a summary to solidify your proficiency in both Pivot Tables and Excel Graphs. Elevate your Excel skills and make data-driven decisions effortlessly!
What you'll learn
Pivot Tables in Excel
Data Analysis
Data Summarization
Excel Reporting
Pivot Table Tools
Excel Style Options
Data Slicers
Data Source Management
Data Refresh
Excel Graphs and Charts
Data Visualization
Excel Workbook
Syllabus 15
Pivot Tables in Excel
Pivot tables are used to sort, count, total or reorganize the data stored in a table. Pivot tables are one of the most powerful features in Excel for Data Analytics. In this module, understand what Pivot tables are used for and how they are used by looking into examples shared by the instructor.
Pivot Table and Its Importance
How to create a Pivot Table
Different ways to summarize data
Various Tools
Implementation of various tools
Style Options
Insert Slicer
Change Data Source
Refresh
Summary on Pivot table
Agenda to Excel Graphs and Charts
Introduction to Graphs and Charts in Excel
Implementation and Explanation of Charts on Excel Workbook
Summary on Graphs and Charts
Advantages and disadvantages
Advantages
Free, short, with a free certificate.
Made in India, with examples Indian students will recognise.
Free certificate when you finish.
Completely free.
Self-paced: start any time.
A clear syllabus (15 parts) you can see before you start.
Disadvantages
Introductory; the certificate carries little weight with employers.
Expect follow-up calls and emails about paid programs.
Some points apply to every course of this kind; see how we rank.
Free, with a free certificate
Free: Sign up with your email or phone to watch.
Certificate: Free when you finish the videos and quiz.
Taught by
Tony TomTony Tom is a Research Analyst at Great Learning, bringing strong analytical skills and a structured engineering mindse…
MIT 18.650 Statistics for Applications, Fall 2016 View the complete course: http://ocw.mit.edu/18-650F16 Instructor: Philippe Rigollet This course offers an in-depth the theoretical foundations for statistical methods that are useful in many applications. The goal is to understand the role of mathe…
-Learn more and enroll in the program: https://online.stanford.edu/programs/generative-ai-technology-business-and-society-program Recent advancements in generative AI are reshaping industries, pushing technological boundaries, and revolutionizing creative processes. In this fast-changing landscape…
For more information about Stanford's Artificial Intelligence programs visit: https://stanford.io/ai Delve into the exciting world of Artificial Intelligence with insights and research from the world's top experts. This playlist offers a comprehensive journey, from foundational machine learning con…
Led by Andrew Ng, this course provides a broad introduction to machine learning and statistical pattern recognition. Topics include: supervised learning (generative/discriminative learning, parametric/non-parametric learning, neural networks, support vector machines); unsupervised learning (cluster…
View the complete course: http://ocw.mit.edu/6-034F10 Instructor: Patrick Winston In these lectures, Prof. Patrick Winston introduces the 6.034 material from a conceptual, big-picture perspective. Topics include reasoning, search, constraints, learning, representations, architectures, and probabili…