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
Szilvia "XSzil" Juhasz
Excel Expert, Trainer, Author, Consultant
I've consulted with business analysts, controllers, accountants, and more--people just like you.
Together, we've used Excel to integrate processes, and tools to save time and money, and enhance productivity. Along the way I’ve developed some clever approaches to messy data problems using Microsoft Excel. And I can't wait to share them with you.
Now it’s time to unveil my favorite “trade secrets," so you can elevate your Excel modelling game. It’s all in my new course. And I'm so happy to have you join me.
Sincerely,
Szilvia
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.
+
Lifetime Access
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
with
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!
Enroll Today!
Choose Your Plan Below.
Data Modelling in Excel
$297
- 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
$497
- 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
$697
- 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!