What you get:
- Video lectures 📺 to show you (via real life examples) every function you need in Excel to succeed in Accounting and Financial Analysis. Org. priced at $700
- Bonus: Excel Downloads of my most used Accounting templates, valued at $400
- Certificate of Graduation: Once you complete the lectures (6 hours total) and pass multiple choice quizzes
Total value offered $1,100 Yours today for $399
Lock in your price, before price increases as I am adding new content (lectures)
Overview
This is a 6-hour online course that will teach you the most important Excel functions you need to Succeed in Accounting or Financial Analysis.
This course will be launched in installments as follows:
Module 1 - Excel Basics
Module 2 - Data Cleaning & Mass Changes
Module 3 - Data Lookups - Coming Dec 2023
Module 4 - Pivot and Macros - Coming Jan 2024
Module 5 - Using Excel as a Controller or Financial Analyst (Real life cases) - Coming Feb 2024
FAQs
Who is this course ideal for?
This is ideal for ALL Finance professionals. This includes Accountants, FP&A, Bookkeepers, and Business college students.
What is the prerequisite/prior knowledge needed for this program?
High school or equivalent is sufficient. If you have an Accounting class/work experience it could help you progress faster, but not required for this program.
Is this course on-demand?
Yes, you can watch & study the course on your own pace. Each of the 5 modules is broken down to 1-10 minutes lectures that are easy to understand and explained in Bill's famous way of breaking down the concepts.
What do I get?
1) 6-hours of video lectures, where I show you how to perform a Controller's job, based on my experience.
2) Lifetime access to the material.
3) Downloadable Excel files so you can visualize the work we will do together.
4) Certificate of graduation 🎉
What if I have a question?
You can ask me directly in the 'Question Box' inside each video lecture. I typically provide an answer within 24 hours.
Will I get a certificate of graduation?
Yes! After watching the lectures and passing a few multiple choice quizzes (you can re-take them, it's only to designed to get you thinking)
Course Curriculum
- M1 Lecture 1 Introduction (1:13)
- M1 Lecture 2 How is Excel used in Finance (2:24)
- M1 Lecture 3 How much Excel should you know (2:14)
- M1 Lecture 4 Mac vs. PC when it comes to Excel (2:59)
- M1 Lecture 5 Use ready-templates to save time (2:36)
- M1 Lecture 6 Navigation bar breakdown (2:47)
- M1 Lecture 7 How to name your files and folders (3:08)
- M1 Lecture 8 Amazing Shortcuts (4:58)
- M1 Lecture 9 How to properly format an Excel Report (4:27)
- M1 Lecture 10 Proper Formatting Continued (5:11)
- M1 Lecture 11 Text to columns (3:05)
- M1 Lecture 12 Create drop down menu (1:36)
- M1 Lecture 13 Conditional formatting (3:51)
- M3 Lecture 1 Introduction to Lookups - HD 1080p (5:17)
- M3 Lecture 2 Vlookup, why it is helpful and why it-s has issues - HD 1080p (9:44)
- M3 Lecture 3 Xlookup and its many benefits - HD 1080p (8:24)
- M3 Lecture 4 Xlookup - Bring the last match, and why - HD 1080p (3:53)
- M3 Lecture 5 Horizontal Xlookup - HD 1080p (1:51)
- M3 Lecture 6 Wildcard - a type of Fuzzy lookup - HD 1080p (3:00)
- M3 Lecture 7 Filter - when there are multiple results - HD 1080p (3:14)
- M3 Lecture 8 Index Match - Another way to lookup data - HD 1080p (7:18)
- M3 Lecture 9 Xlookup with multiple criteria - HD 1080p (3:00)