Master Excel Pivot Tables and Charts to boost your data analysis skills and career potential with this comprehensive course featuring clear tutorials and practical exercises.
This course dives into the magic of pivot tables and charts in Excel 2016, teaching you simple, yet powerful ways to analyze data. With hands-on examples, you'll quickly become a go-to expert at work, impressing everyone with your skills and saving tons of time.
Become indispensable at work! Become a power user and earn a huge raise by working Pivot magic in Excel.
This course provides an in-depth coverage of pivot tables and pivot charts in Excel 2016. These are two of the most powerful, if not the most 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 43 short 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.
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
3 Lectures
7 Lectures
13 Lectures
8 Lectures
Optima Train is a US-based training company using cutting-edge adult learning methodology to make our customers more effective in the workplace.Optima Train has the most comprehensive coverage of content created by experts with deep knowledge of how applications are used in the workplace.We are intricately linked to our customers. While most training companies have a tool-centric approach that leads to...
Cannot download the resources/file.
Enjoyed the course - learnt a lot would like to review this once again as it was too much to remember. Very well done, very clear voice and dictation and at a pace that you can learn and follow - would recommend users to pay and get these courses and very often there are offers on the prices which are well worth a bargain. Certainly would like that users take advantage. Good Job
I'm a software / database developer and use Excel as the end result of a lot of my applications where data is presented to the user. Hence, my knowledge of Excel has been spotty for a while. I've been using pivot tables and charts for a while but sitting through this course I learned some new things. Course was not long, which is good, and gave me some insights into how I can do more with Excel.
The short and concise segment methodology applied in this course helps a great deal with comprehension and retention of the skills you will learn. A great course for beginners to those with moderate mastery of Excel.
Solo faltó que el curso incluya actividades practicas, donde se aplique lo que están enseñando.
Yes it was very thorough, slightly more basic than anticipated, but presented very clearly and good refresher as well as learned some new points.
Pretty thorough course. As an experienced user I still learned a few things. Though I thought he mentioned we'd cover calculated fields and calculated items, but we never did. This would have been very helpful I think.
I've been using pivot tables for a long, long time but figured it was worth skimming through a 'deep dive' course to find things I don't already use, and there were a few:
Slicers - I've seen them but not used them much.
Histograms - I hadn't seen grouping used for histograms. Nice.
Field List - I had no idea that I could move it and change the view. I don't need to, but now I know that I can.
So, yeah, nice course. Well-organized, brief, and to the point.
If you use Transcription while watching the videos, beware of spelling, grammatical and formatting mistakes. The information isn't corrected as the word "rows" is typically translated as "Rose", "pane" is translated as "pain", etc.
Your email address will not be published. Required fields are marked *
Anne C.
Love the examples, the instructor's pace is good and he is clear