Redirecting...
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?
I explain Accounting from scratch and in plain English. This allows anyone to follow the material. Most of my students are Accounting students, professionals (ranging from Staff Accountant to Controller), CFOs, and even business owners.
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?
Just email me ([email protected]) and I will do my best to get back to you.
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)