Accounting 101: Using Microsoft Excel For Accounting in 2020
3.9 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
145 students enrolled

Accounting 101: Using Microsoft Excel For Accounting in 2020

Template Included For Download! Learn How To Do Basic Accounting, Track Revenue, Expenses, Profit and Cash.
3.9 (28 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
145 students enrolled
Last updated 7/2020
English [Auto]
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 1 article
  • 6 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Learn From A Top Rated Instructor Who Has Been Teaching On Udemy Since 2013 and Taught Over 100,000 Students!
  • Template Available For Download at Course End!
  • Track Revenues
  • Track Expenses
  • Track Cash Balances
  • Track Cash Spending
  • Determine Profitability
  • Make Decisions
  • Strategize
  • Track Basic Accounting
  • And Much More!
  • A spreadsheet program - Microsoft Excel or Google Sheets (free)

Does The Idea Of Learning An Entire Accounting System Like Quickbooks Not Appeal To You?

Do You Run A Business You Want To Properly Do Accounting For But With Ease and Low Effort?

Do You Want A Free Solution To Doing Accounting?

Do You Want An Intuitive Method For Doing Accounting Without Having An Accounting Degree?

Do You Want To Increase Your Knowledge Of Your Business Performance?

If You Answered "Yes" To Any Of The Above, Look No Further.  This Is The Course For You!

*** Updated in July 2020 with new content! ***

Enroll today and join the 100,000+ successful students I have taught as a Top Rated Udemy instructor!

Three reasons to TAKE THIS COURSE right now:

  1. You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads

  2. You can ask me questions and see me respond to every single one of them thoroughly! 

  3. You will are being taught by a professional with a proven track record of success!

  4. Bonus Reason: I provide the template we build in this course for you to download at the end!

Recent Review:

Steve S. says: "Great information in this course, I really didn't want to learn accounting or buy accounting software for my small business, I'm too busy and not interested.  I knew though I needed to keep track of my books somehow, and this course helped greatly! Now I can actually run my business and track results with ease."

Why You Should Take This Course:

As an entrepreneur, you have to wear many hats.  One which often gets ignored is having a full understanding of how much money is coming in, where its being spent, how you are growing, and what you could be doing to grow more!  Basic accounting at its finest if you will.

By spending a little bit of time each week to do accounting, setting goals and tracking your results, you'll have far greater insight into what works and what doesn't, and how to proceed.  You will also be documenting a history of your sales for you to refer to in the future. 

In this course I teach you how to build a relatively simple but VERY effective accounting system in Excel (or Google Sheets) to track actual results.   Take your business to the next level.

When your business grows further to needing a fully dynamic accounting system you can easily import the data you've tracked in Excel (Sheets). 

What We Learn In The Course:

  • Learn basic Excel concepts for anyone not familiar with the program

  • Learn basic accounting concepts

  • Learn how to set up a proper revenue/expense/cash tracking spreadsheet

  • Learn how to create reports to track your businesses profit and cash balance

  • Learn how to properly set sales goals and what factors should be considered

  • Graph your results for visual representation of how you are performing

  • Make intelligent business decisions

  • And more! By the end of the course you'll be ready to take your business to the next level.

This course is not meant to be a complete introduction to accounting, instead it is for entrepreneurs who want to do basic tracking of revenue, expenses, cash and profitability.

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  


About The Instructor

Chris Benjamin, MBA & CFO is a seasoned professional with over 25 years experience in accounting, finance, financial reporting, small business and accounts receivable.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course on Udemy. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA

Who this course is for:
  • Small business owners
  • Cash based businesses
  • Online sellers
  • Anyone with a business that brings in money and has some expenses
Course content
Expand all 20 lectures 02:08:30
+ Introduction
4 lectures 23:22
Instructor Introduction
Udemy Review System
Excel Basics - Formatting, Reports and Charts
+ Accounting In Excel
10 lectures 01:02:38
Introduction To The Spreadsheet
Revenue Sheet Part 1
Revenue Sheet Part 2
Expense Sheet
Profit Sheet Part 1
Profit Sheet Part 2
Profit Sheet Part 3
Cash Tracking Sheet
+ Course Conclusion
4 lectures 23:41
Course Conclusion
2020 Update - What's New In The Business For 2020
Recommended Next Steps
Bonus Lecture: Discount For ALL Of My Other Courses