Practical Excel 2010 Pivot Tables and Pivot Charts
Practical Excel 2010 Pivot Tables and Pivot Charts , available at $19.99, has an average rating of 4.4, with 45 lectures, based on 26 reviews, and has 183 subscribers.
You will learn about An understanding of how pivot tables allow you to break down numerical data by categories, something other Excel tools can do, but not nearly so quickly or easily How to build pivot tables by clicking and dragging An understanding of the advantages of using Excel tables as a basis for pivot tables How to sort and filter in pivot tables How to build pivot charts, which are automatically synchronized with the corresponding pivot tables Methods for grouping categories, especially dates, with many categories in pivot tables An understanding of the role of pivot caches for extremely fast pivot table calculation How conditional formatting in pivot tables provides even more insightful reports How to create calculated items and calculated fields for pivot tables How to use pivot tables for finding unique values, creating histograms, and classification (learning which variables are related to a Yes/No variable) This course is ideal for individuals who are Any competent Excel users who want to take their Excel data analysis skills to a whole new level It is particularly useful for Any competent Excel users who want to take their Excel data analysis skills to a whole new level.
Enroll now: Practical Excel 2010 Pivot Tables and Pivot Charts
Summary
Title: Practical Excel 2010 Pivot Tables and Pivot Charts
Price: $19.99
Average Rating: 4.4
Number of Lectures: 45
Number of Published Lectures: 45
Number of Curriculum Items: 45
Number of Published Curriculum Objects: 45
Original Price: $22.99
Quality Status: approved
Status: Live
What You Will Learn
- An understanding of how pivot tables allow you to break down numerical data by categories, something other Excel tools can do, but not nearly so quickly or easily
- How to build pivot tables by clicking and dragging
- An understanding of the advantages of using Excel tables as a basis for pivot tables
- How to sort and filter in pivot tables
- How to build pivot charts, which are automatically synchronized with the corresponding pivot tables
- Methods for grouping categories, especially dates, with many categories in pivot tables
- An understanding of the role of pivot caches for extremely fast pivot table calculation
- How conditional formatting in pivot tables provides even more insightful reports
- How to create calculated items and calculated fields for pivot tables
- How to use pivot tables for finding unique values, creating histograms, and classification (learning which variables are related to a Yes/No variable)
Who Should Attend
- Any competent Excel users who want to take their Excel data analysis skills to a whole new level
Target Audiences
- Any competent Excel users who want to take their Excel data analysis skills to a whole new level
This course provides an in-depth coverage of pivot tables and pivot charts in Excel 2010. These are two of the most powerful, if not themost powerful, data analysis tools in Excel’s arsenal, and they should definitely be mastered by anyone who aspires to becoming an Excel “power user.” As this course will illustrate with many examples, the tools are surprisingly easy to learn and use—once you know they exist. To learn Excel Pivot Tables & Pivot Charts quickly and effectively, download the companion exercise files so you can follow along with the instructor by performing the same actions he is showing you on the videos.
***** THE MOST RELEVANT CONTENT TO GET YOU UP TO SPEED *****
***** CLEAR AND CRISP VIDEO RESOLUTION *****
***** COURSE UPDATED: February 2016*****
“The Optima Train two part series on Pivot Tables is pure gold! The material is so amazingly thorough and clear that anyone watching the videos and doing the exercises provided will without a doubt become a true expert at working with Pivot Tables and likely become a hero at work by applying and sharing this new-found knowledge. There is nothing like it on the market.” – Phil, FORMER TREASURY OPERATIONS MANAGER – EXXONMOBIL
“When I first looked up this site I was a bit skeptical, but I soon realized how amazing these courses are. They have helped me excel in all my business classes. The PowerPivot course now makes business analytics easy and at my fingertips.” – Wilson Xu, STUDENT
90% of Excel users do not use Pivot Tables but those that do save hours of time and become valuable assets in their companies. The hours of time you’ll save translates to real money in your pocket of earning potential! Imagine the power you will have as a knowledge worker in your company that people go to when they need help. Upper management will notice your sharp analysis and will not be able to do without you. Pivot Tables has been called the best thing since sliced bread. Once you start using it you’ll never stop. Pivot Tables and Pivot Charts are not difficult to learn and it’s bewildering that not many people use it – you can take advantage of that short supply of power users in the workforce by becoming a power user yourself and an indispensable resource to your work place. Simplify your work and personal life by learning this extremely useful tool.
This is the most comprehensive Excel Pivot Tables & Pivot Charts course and has 43short video tutorials. The follow-on course of PowerPivot & Advanced Business Intelligence Tools builds on where this course ends. There is zero fluff and no time wasted in this course. The instructor, Dr. Chris, has decades of experience using Excel in real-world settings solving complex business problems. There is no quicker way to learn Excel than to watch these videos and follow along with the free companion exercise workbooks which are downloadable. If you want to stand out among your colleagues, earn a promotion, further your professional development, save tons of hours every year, and learn Excel Pivot Tables & Pivot Charts in the quickest and simplest manner then this course is for you!
You’ll have lifetime online access to watch the videos whenever you like, and there’s a Q&A forum right here on Udemy where you can post questions.
Course Curriculum
Chapter 1: Introduction to Course
Lecture 1: Welcome to Pivot Tables and Pivot Charts Course
Lecture 2: How to download Exercise Files and Handouts
Lecture 3: REMINDER: Turn on HD
Chapter 2: Why Pivot Tables?
Lecture 1: What Pivot Tables Do for You
Lecture 2: Life Without Pivot Tables
Chapter 3: Creating a Pivot Table
Lecture 1: Data Structure for Pivot Tables
Lecture 2: Creating a Pivot Table
Lecture 3: Excel Tables
Lecture 4: Pivot Tables Based on a Table
Chapter 4: Basic Pivot Table Tools
Lecture 1: Pivot Table Field List Options
Lecture 2: Placing Fields in a Pivot Table
Lecture 3: Multiple Fields in the Values Area
Lecture 4: Pivot Table Layouts
Lecture 5: Value Field Settings for a Numeric Field
Lecture 6: Displaying Counts in a Pivot Table
Lecture 7: Show Values As Options
Lecture 8: Filtering and Collapsing on Row and Column Fields
Lecture 9: Field Settings for a Categorical Field
Lecture 10: Sorting in Pivot Tables
Lecture 11: Sorting with a Custom List
Lecture 12: More Filters for Row and Column Fields
Lecture 13: Slicers for Filtering
Lecture 14: Pivot Charts
Lecture 15: Styles for Pivot Tables and Charts
Lecture 16: Grouping by Category
Chapter 5: Other Pivot Table Tools
Lecture 1: Pivot Cache
Lecture 2: Converting a Pivot Table to Static Values
Lecture 3: More on Grouping by Dates
Lecture 4: Grouping by Selection
Lecture 5: Showing Report Filter Pages
Lecture 6: Displaying Cells with No Data
Lecture 7: PivotTable Options Dialog Box
Lecture 8: Selecting, Copying, Moving, Clearing, and Deleting a Pivot Table
Lecture 9: Refreshing a Pivot Table
Lecture 10: Avoiding Pivot Cache Sharing
Lecture 11: Conditional Formatting in Pivot Tables
Lecture 12: Calculated Fields
Lecture 13: Calculated Items
Lecture 14: Formulas Referencing Pivot Table Cells
Lecture 15: Using GetPivotData for Custom Reports
Lecture 16: Efficiency Tips for Pivot Tables
Chapter 6: Selected Uses of Pivot Tables
Lecture 1: Finding Unique Values with a Pivot Table
Lecture 2: Creating a Histogram with a Pivot Table
Lecture 3: Using Pivot Tables for Classification
Chapter 7: Conclusion to Course
Lecture 1: Conclusion to Pivot Tables and Pivot Charts Course
Instructors
-
Optima Train
Practical Training for Today's Knowledge Worker
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 0 votes
- 3 stars: 6 votes
- 4 stars: 8 votes
- 5 stars: 12 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024