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.
BECOME INDISPENSABLE
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
Duration: 11m
Lesson 2 Building a Global Framework
Duration: 8m
Lesson 3 Building A Local Error Check Solution
Duration: 16m
Lesson 4 Error Checks pt 1
Duration: 5m 30s
Lesson 5 Error Checks pt 2
Duration: 50m
Lesson 6 Counting Total And Unique Table Entries
Duration: 4m
Lesson 7 Using Table Statistics To Cross Check Summaries
Duration: 2m
Lesson 8 Checking If A Pivot Is Updated
Duration: 8m
Lesson 9 Adding Pivot Checks Into A Model
Duration: 5m
Lesson 10 Final Testing
Duration: 4m
About Ken Puls, Microsoft Excel MVP
Welcome to my course!
I've spent over twenty years working in public practice accounting and industry as both a Controller and an IT Director. I've lead led the installation of over a dozen systems—and have worked with business systems and data of all types. You name it—I’ve done it.
Today, I work on my own, helping businesses realize value with their data. And I want to share what I’ve learned with you!
I love teaching people how to build awesome business intelligence systems and reports with Excel. My work will save YOU time and make you more efficient.
Here's What You’ll Get
INCREDIBLE CONTENT!
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!
Excel TV Courseware & Community
Join the Excel.TV community, which includes of a growing knowledgebase of free video content, special discounts to course members, and exclusive deals not available to the general public.
You also get access to our awesome courseware! When you purchase this course, you can begin immediately. Because we host everything ourselves, there are no third parties! You deal with us directly!
+
1-Hour Live Webinar Q&A Session with Ken
Have a question as you're going through the course? What to get live help from Ken? Join now and get access to a live Q&A session with Ken. (We'll follow up to schedule.)
Can't make it? That's OK, there will be more than one. And past videos will always be available in your online course library.
Start Today! Choose Your Plan Below
Invest in your career.
Error Checking for Excel BI Solutions
$47
- Over 1 hour of content
- Exclusive Q&A Webinar with Ken and no-questions-asked, money back guarentee
- Lifetime access
Error Checking for Excel BI Solutions +
Building BI with PivotTables
$197
- Everything in Building BI with PivotTables
- Save over $100 when bundled!
Error Checking for Excel BI Solutions
+ Building BI with Pivot Tables + Data Modelling in Excel
$297
- Life time access to Building BI with Pivot Tables and bonuses!
- Lifetime Access to Data Modelling in Excel
- Best Deal!