Accounting 101: Using Microsoft Excel For Accounting

Template Included For Download! Learn How To Do Basic Accounting, Track Revenue, Expenses, Profit and Cash.

4.30 (56 reviews)
Udemy
platform
English
language
Accounting & Bookkeeping
category
246
students
2 hours
content
Oct 2022
last update
$49.99
regular price

What you will 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!

Description

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 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.  


***CLICK "BUY NOW" AND LEARN HOW TO USE MICROSOFT EXCEL TO DO ACCOUNTING! ***


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

Content

Introduction

Course Introduction
Instructor Introduction
Udemy Review System
Excel Basics - Formatting, Reports and Charts

Basics of Accounting and Excel

Basics of Microsoft Excel
Basics of Accounting

Accounting In Excel

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
Dashboard
Wrapup

Course Conclusion

Course Conclusion
2020 Update - What's New In The Business For 2020
Recommended Next Steps
Bonus Lecture: Discount For ALL Of My Other Courses

Screenshots

Accounting 101: Using Microsoft Excel For Accounting - Screenshot_01Accounting 101: Using Microsoft Excel For Accounting - Screenshot_02Accounting 101: Using Microsoft Excel For Accounting - Screenshot_03Accounting 101: Using Microsoft Excel For Accounting - Screenshot_04

Reviews

Michel
June 20, 2023
Chris does a super job! He is a great instructor and for me that was looking for spreadsheet accounting, this is a really good start. I bought two other course from Chris and I can'T wait to learn more in depth accounting.
John
June 12, 2023
Voice instructions good, easy to understand, Over half of videos unusable because extremely blurry on 3 different PCs. PLEASE REPLACE VIDEOS or REFUND
Carla
April 29, 2023
This is good for someone who has limited accounting/excel experience. Would advise my clients to take this course as a starting point. What I dislike is the recording of the information twice, but at this introductory level, I wouldn't get hung up on that idea.
Jennifer
March 24, 2023
This a a very good course. I've been searching for something simple to help me when I start my small business. I find excel easy to use and I wanted to find a course that could show me how to keep my accounting easy and manageable. This course has helped demystify accounting for tracking revenues and expenses. Very easy to follow course. I recommend taking it if you are looking for a simple, practical way to keep your books.
Jade
September 10, 2021
It didn't touch on much of what I was expecting to get out of the course-mainly more complex formulas, data, etc
Adaobi
August 27, 2020
I'm already an Accountant so i knew the things Chris was saying but have taken this course as a guide to start my own courses
Mayur
August 21, 2020
Learning in this is below expection, even free tutorial in youtube provide better & deeper understanding.
Bill
July 30, 2020
Hmmm......I can't honestly see anyone with the Excel skills assumed in the course actually needing anything as basic as this. But, hey-ho, it was very cheap and I might even use the template spreadsheet.
Josh
June 14, 2020
Good course! I'm starting a business and don't really need Quickbooks or some complicated software. Excel is a practical and simple solution, and it provides everything I need. This is a quick course. You'll probably learn some Excel tricks (I did). In the end, you have a simple accounting tool that gets the job done and can easily be customized. Plus, I feel more confident that I understand accounting- it's actually simple (for a small business), and there's no need to be intimidated.
Nadia
June 10, 2020
I really enjoyed the concept and the instructor was very knowledgable and easy to follow plus made the topic fun with enthusiasm. Thank you!
Sendy
May 27, 2020
Since I have already used Microsoft Excel for many years, this material is not interesting for me, but it is explained well, clear and easy to be understood.
Sabir
August 31, 2019
Thank you. The instructions were clear but the sound of breath in between making it tough to have a complete understanding
Agnes
January 10, 2019
Great for beginner for Excel program. Really basic Excel functions and accounting ideas, as described. The sound quality is a little soft. Download in the APP is slow and unreliable.
K
December 10, 2018
Taking this course was a great decision I took, very practical and useful information on accounting for a small business. Instructor is passionate and delivery was crisp and student focused for easy understanding. I highly recommend this for entrepreneurs and those who are thinking of getting on to business venture. Thank you very much Chris for such an amazing course on accounting with great simplicity! A. Rehman

Charts

Price

Accounting 101: Using Microsoft Excel For Accounting - Price chart

Rating

Accounting 101: Using Microsoft Excel For Accounting - Ratings chart

Enrollment distribution

Accounting 101: Using Microsoft Excel For Accounting - Distribution chart

Related Topics

2033474
udemy ID
11/18/2018
course created date
11/20/2019
course indexed date
Bot
course submited by