Finally, a step-by-step course to Wrangle, Crunch, and Visualize Your Data!
Become a Business Intelligence Master with Pivot Tables
Time is money. If you have to rebuild your business intelligence delivery each time, you're wasting your most valuable resource. This course will show you step-by-step how to quickly build business intelligence solutions once and then reuse them across your organization.
This video course will show you exactly how to transform everyday data sets into rich Pivot Tables, dashboards, and reports with little effort.
Don't waste time with Excel features and expensive third party platforms you don't need. Learn how best to collect, organize, transform, present, and secure your data from unwanted eyes and prying analysts!
Acclaimed Excel and Business Intelligence expert, Ken Puls. brings decades worth of hard-won knowledge delivering business intelligence solutions to small business and enterprise-level leadership. He has been awarded the prestigious Microsoft MVP award every year since 2006, has authored two books on Excel development, and is founder of Excel Guru.
- The Business Intelligence Lifecycle
- Why You Should Care About PivotTables
- Creating Your First Pivot Table
- Learn the perfect data layout
- Easily connect to your source data
- Feed data directly into Pivot Tables, Excel Tables, and Data Models
- Learn tricky Pivot Tables formats
- Group important data together for reporting
- Best sorting techniques to show top and bottom metrics
Duration: 1h 52m
- Mastery Power Query to manipulate data
- Consolidating data across platforms
- Fast unpivoting/flattening data
- Database joins in Excel!
- Statistical calculations
- Running totals
- Variances and differences
- Calculated fields & items
- Slice and dice your data
- Working with slicers and timelines
- Keeping everything looking nice
- Toggling options
- Conditional formatting key metrics
- Keeping pivots in sync
- Tricks for extracting key info
- Working with Pivot Charts
- Working with external and local data sets
- Securing your data
TONS OF INCREDIBLE CONTENT!
Over 6.5 hours, 8 amazing modules, and 79 lessons. Plus lifetime access!
KEEP YOUR SKILLS CURRENT!
Quizzes, demos, labs, and bonuses keep your sharp. Use what you learn immediately!
LEARN FROM THE BEST!
Get the help you need. Ken will be there to guide you throughout the course. Leave a question under any video when you need help!
Within the first couple of modules it was apparent Ken has been through it all. He speaks in a way that resonates both with professionals out in the field today and for those only now starting their journey. I will say for all the years I fought kicking and screaming learning PivotTables I wish I would have had this course at my disposal. Even now as an experienced PivotTable user I found myself rushing back to my daily reports throughout his lessons with aggregate methods. They say a blackbelt becomes a whitebelt when they realize there's still more to learn.
I’m certainly no BI or PivotTable newbie but there is so much to learn in this course!
This course is not for everybody.
When you buy this course, you get the Excel.TV Guarantee. We guarantee you'll immediately learn to build awesome Pivot Tables and deliver insightful Business Intelligence to your managers and stakeholders.
We're so confident in our product, we're happy to guarantee its success. If you don't find immediate value within the first thirty days, we promise to give your money back. And we don't play games.
That's right, it's our no-questions-asked policy. Let us know within 30 days of your purchase you'd like a refund. IT'S THAT SIMPLE.
These bonuses are just for this product launch! We can't promise to offer the same in the future!
If you'd like to learn more about the American Red Cross's Disaster Relief efforts, click here.
Jordan Goldmeier, Cofounder, Excel TV Media Group
Invest in your career.
You can watch these videos on any device! That means you can learn Excel from the comfort of your desktop and on the go on your phone.
No internet? No problem! Every video can be downloaded and enjoyed offline.
First, there are no macros or VBA in this course! Second, Ken has trained hundreds of students with varying skills. You don't need to be an Excel expert to learn.
Ken shows you step-by-step how to develop BI solutions with Pivot Tables. If you have a working knowledge of Excel, love to get your hands dirty with data, and have an appetite to learn then you're all set!
FOREVER. This course comes with lifetime access. There is no time limit to complete this course. Learning is life long process, so you should have access to this course for as long as you’d like.
There is about 6.8 hours of video-based course material available. This number does not include labs or quizzes.
The course is self-paced and there is no correct amount of time it should take. We encourage you to spend time with the material until you fully understand it, whether that’s simply watching a video once or multiple times, or implementing what you’ve learned at work.
We accept all major credit cards including American Express, Master Card, Visa and Discover. We also accept PayPal.
Yes, all associated course materials can be found within their associated lessons. We strongly encourage you to supplement your learning by following along with the course files, taking quizzes, and completing labs.
Absolutely! We can help your team and organization realize its full potential. Please email [email protected] for more details.
Absolutely! Our video delivery system works across all desktop and mobile platforms. Enjoy at home, at work, and on the go.
We offer corporate discounts for group purchases. Please inquire with Rick Grantham by emailing [email protected] to find out more.
Ken to answer
Absolutely. You’ll have to talk to your employer to see what specifics are required. We suggest using a corporate credit card or PayPal account if available. Otherwise, you’ll receive a receipt immediately upon payment authorization that you can supply to your employer for reimbursement.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.