Say GOODBYE to Excel ERRORS for GOOD
Finally, your guide to creating clean & error free workbooks.
How much could one spreadsheet error cost?
Well, it cost one bank almost $1b.
How A Rookie Excel Error Led JPMorgan To Misreport Its VaR For Years
So, if you work with spreadsheets, you (and your company) need this course.
HOW MUCH COULD ONE ERROR COST?
Research suggests over 90 percent of spreadsheets contain one or more errors. This course will show you how to deal with errors and how to fix them.
Spreadsheets are commonly riddled with errors and issues. So many courses focus on how to do new things in Excel. This course will show you how to improve your current models and pivot tables. If you're the person in the office who creates clean spreadsheets--and can handle errors on the spreadsheets of others--you'll become indispensable.
WHAT WORKS, WHAT DOESN'T, AND WHY.
Learn how to build right the first time and quickly apply your knowledge to future work.
LEARN FROM THE BEST!
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.
Error Checking for Excel BI Solutions is the quickest way to start building error free work.
Learn QUICKLY from 10 comprehensive lessons with over 1.5 hours of video content.
Lesson 1 The Need For Error Handling
Lesson 2 Building a Global Framework
Lesson 3 Building A Local Error Check Solution
Lesson 4 Error Checks pt 1
Duration: 5m 30s
Lesson 5 Error Checks pt 2
Lesson 6 Counting Total And Unique Table Entries
Lesson 7 Using Table Statistics To Cross Check Summaries
Lesson 8 Checking If A Pivot Is Updated
Lesson 9 Adding Pivot Checks Into A Model
Lesson 10 Final Testing
Here's What You’ll Get
1 hour of video content, 10 lessons and 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!
Is this Course Right for You?
This course is not for everybody.
WHO THIS IS FOR
- You believe you can make better business intelligence and reports faster and quicker if given the right guidance and tools.
- You are a longtime professional, student or junior employee, or recent career changer looking to get in front of leadership and management.
- You want to differentiate yourself in your office by having the best skills for the job.
- You love getting your hands dirty with data and formulas.
WHO THIS IS NOT FOR
- You are looking for a course with Visual Basic for Applications, macros, or Microsoft Access as a focus.
- You are looking for a course that specifically teaches Pivot Tables, Excel modeling or dashboards.
- You are looking for a quick guide that does not require time, effort or work.
We Stand Behind our course!
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.
Enroll now and get these bonuses!
These bonuses are just for this product launch! We can't promise to offer the same in the future!
Start Today! Choose Your Plan Below
Invest in your career.
Here are answers to some frequently asked questions:
Can I access the class from anywhere? Can I download the videos?
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.
I'm not an Excel expert and don't know macros or VBA, is this course for me?
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!
Once purchased, how long will this course be available?
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.
How long does it take to complete this course?
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.
What payment methods do you accept?
We accept all major credit cards including American Express, Master Card, Visa and Discover. We also accept PayPal.
I need help! Who can I contact?!
Will course materials be available for download?
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.
Do you offer in-person, hands-on training in addition to these courses?
Absolutely! We can help your team and organization realize its full potential. Please email [email protected] for more details.
Can I watch lessons using my mobile device?
Absolutely! Our video delivery system works across all desktop and mobile platforms. Enjoy at home, at work, and on the go.
Do you offer corporate discounts?
We offer corporate discounts for group purchases. Please inquire with Rick Grantham by emailing [email protected] to find out more.
What version of Excel do I need? Can I use Excel for Mac?
Ken to answer
Can my employer pay for this course?
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.