Learn to build
Excel Models that work.
PLAN, DESIGN, and MAINTAIN Excel models that
save your company money, increase efficiency, and solve real business problems.
Data Modelling in Excel is a complete, step-by-step online course showing you everything you need to know - regardless of skill level.
Want to take your excel analysis skills to the next level? This course is for you.
THE ART OF THE POSSIBLE. THE SCIENCE TO DELIVER.
This course breaks down important concepts, showing you the art of what's possible and the science to execute your vision. The course instructor, Szilvia Juhasz, has been praised for her creative teaching style, combining wit and charm with extensive instruction.
PLAN. DESIGN. BUILD. MAINTAIN. RINSE. REPEAT.
This course will show you how to build an Excel model from soup-to-nuts. Nothing is left out. And the best part is, you can make it once and then reuse it forever.
MASTER EXCEL. SET YOURSELF APART.
In today's data age, you need the skills to will help you save your company money, get that promotion, and take control of your career. This course will show you the latest and greatest of Excel's capabilities. They don't teach this stuff in an MBA program.
LEARN FROM THE BEST!
This course was personally developed with you in mind. Whether you're an analyst, accountant, new graduate, veteran, or someone looking to switch into the data field, this course differentiate you. Szilvia brings her experience as an Excel author, consultant, and trainer of all types and skill levels to you. This course shows you what you need to know, when you need to know it.
This course is
packed with 9 hours of video across 6 modules, examples, hands-on demos, and labs.
Module 1 Designing Great Excel Models Step by Step
- What is the Art-Science of Excel modeling? What does it mean for me?
- What are the 9 steps to designing great Excel models?
Module 2 Thinking Like Excel
- How to think like Excel.
- How to use "spatial relationships" in your own work.
- The single most important Excel modelling concept to master.
Module 3 Advanced Excel Formula Mastery
- The best formulas to know.
- Common Excel formula writing pitfalls
- The fuss about with VLOOKUP versus INDEX MATCH
Module 4 Anatomy of an Excel Model
- The components of an Excel model.
- The best way to organize your inputs.
- Making a model “easy” for others to use without the risk of their breaking its design.
Module 5 Upgrading to Excel Tables
- What is a “modern” Excel Table, and why should I care?
- PivotTables and Excel Tables, working together.
- Table formulas you should know.
Module 6 Next-Level Excel + Database Solutions
- Build next level Excel models
- Microsoft Access and Excel Models
- How to get databases to communicate
Here's What You’ll Get
TONS OF INCREDIBLE CONTENT!
Over 9 hours of content with 6 amazing modules. 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. This course has everything you need to be successful!
Is this Course Right for You?
This course is not for everybody.
WHO THIS IS FOR
- You want to learn how to build fast, interactive Excel models to change minds in your organization.
- You are a longtime professional, student or junior employee, or recent career changer looking to get a raise, promotion, or the ear (and eyes) of leader.
- You believe in yourself, and know all that's needed to do a good job are the right tools, skills, and the thirst to learn.
- You love getting your hands dirty with data and visualizing data for insights.
WHO THIS IS NOT FOR
- You've never used Excel before.
- You are looking for a course that teaches the full Power BI suite or Power BI Desktop.
- 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'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 a 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!
Webinar Q&A Session with Szilvia
This is only available for a limited time for the people who have signed up for early access. Submit your course and Excel questions for a live Q&A webinar.
Can’t make the webinar? That’s OK, we’ll provide recorded versions only available to course takers.
That’s right. We’re giving you lifetime access.
This material changed will change how your work. Learning is lifelong, and we believe you should have access to this material for as long as you’d like.
Labs & Companion Files
Along with step-by-step video instruction, you’ll receive all available companion files plus labs to reinforce learning. We’ll also include periodic quizzes to your mastery of the material.
The best part is, you can use the course files for your own work! Download, edit, and then use them however you see fit.
The 40 Greatest Excel Tips of All Time
The Excel Lover's Guide to Cocktails
Get instant access!
With the purchase of this course, you'll receive a FREE copy of her book, The 40 Greatest Excel Tips of All Time, co-written with Bill Jelen. Inside you'll find incredible Excel tips and tricks--and Szilvia's Excel cocktail book, filled spirited and spreadsheet inspired drinks--perfect for a night out with data.
Excel TV Courseware & Community
Join the Excel.TV community, which includes of a growing knowledge base 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!
Choose Your Plan Below.
Data Modelling in Excel
- 9 Hours of step-by-step instruction, labs, examples, quizzes and demos
- Exclusive Q&A Webinar with Szilvia Juhasz
- Free copy of The 40 Greatest Excel Tips of all Time
- Lifetime access
Data Modelling in Excel +
Building BI with Pivot Tables
- Everything in Data Modelling in Excel
- Complete course access to Building BI with Pivot Tables + 6.5 hours across 8 comprehensive modules
- GREAT DEAL: Save over $100 when you combine!
Data Modelling in Excel +
Building BI with Pivot Tables +
Excel Dashboard Pro
- Everything in Data Modelling in Excel
- Complete course access to Building BI with Pivot Tables
- Complete course access to Excel Dashboard Pro
- BEST DEAL: Save over $200 when you combine!
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?
Absolutely! In fact, there is no coding in this course at all!
This course is soup-to-nuts. It provides everything you need to learn how to build awesome Excel models. The course starts with the basic elements and builds up from there. This course was designed to appeal to multiple skill levels. And, even if you're a beginner, we believe you'll find the content with your grasp.
When does this course start? When does it end?
This course starts immediately upon registration and payment. You will have lifetime access to the course and can rewatch videos as many times as you’d like.
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 9 hours of video-based course material available. This number does not include labs, quizzes, or bonus content.
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.
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.
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 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.
What version of Excel do I need? Can I use Excel for Mac?
Excel 2016 is used for course instruction. We strongly recommend using Excel 2013 or later. While this course can be completed using Excel 2010, we do not support version differences.
Excel 2007 and earlier will not be useful for this course.
Excel for Mac is not support as the features described within this course only exist on Windows computers.
What payment methods do you accept?
We accept all major credit cards including American Express, Master Card, Visa and Discover. We also accept PayPal.
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.
Do you offer in person training?
Absolutely! We can help your team and organization realize its full potential. To get started, select the right plan for you from the available options. Next, we’ll contact you to get the details. If you have questions, contact Rick Grantham by emailing [email protected] to help us craft the perfect learning experience for you and your organization.
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.
I need help! Who can I contact?!
Having trouble using the site? ordering the course? need help?
Let us know if you need anything. Email [email protected] with you questions, comments, concerns, and feedback.