Excel Fundamentals for Entrepreneurs
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Fundamentals for Entrepreneurs to your Wishlist.

Add to Wishlist

Excel Fundamentals for Entrepreneurs

Learn how to crunch numbers, create financial records and manage data using Excel
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7 students enrolled
Created by Shawn Myers, M.S.
Last updated 2/2017
English
Price: $90
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 67 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create spreadsheets that predict future performance
  • Create spreadsheets that evaluate past performance
  • Make better financial decisions
  • Use your Excel skills to create good financial records
View Curriculum
Requirements
  • You should have access to Microsoft Excel 2010 or higher
Description

Why I created this course

This video course was put together after I spent a considerable amount of time thinking about some of the challenges that the small business owners I’ve worked with have faced. I then came up with a collection of “real world” lessons that will help current (and future) small business owners avoid some of the pitfalls that I’ve seen cause small businesses to fail or fail to achieve the level of success that the business owner had hoped for.

You must know your numbers!

We’ve all heard this before, but what does it really mean? If you’re just starting out, it means you should know your numbers well enough to have the confidence to move forward with your business idea, knowing that you have a better than average chance of succeeding. It also means that you should know your numbers well enough to not pursue a business idea, if the numbers tell you that it’s too much of a risk and that you should change your strategy.

If you already own a business, knowing your numbers will help identify ways to increase profitability, keep expenses under control and create a plan for long-term success.

How this course will help you

You will learn both financial management best practices and Excel skills at the same time, which means that you will retain more and it will be easier to put what you’ve learned into practice.  I have been using this teaching method for many years with both private clients and university students, and it works! I also use a no-fluff, straight-to-the point style of teaching, which means that I can show you how to become a skilled manager of small business finances using Excel in less than two hours.

Who is the target audience?
  • Full-time and part-time business owners
  • Anyone who is interested in starting a business
  • Professional service providers, including physicians, lawyers, etc.
  • Bookkeepers and accountants that work with small business owners
  • Providers of entrepreneurship education
  • Undergrad and graduate students
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
02:05:19
+
Welcome to the Course!
1 Lecture 04:18

This video will give you an overview of the course

Preview 04:18
+
Forecasting Future Performance
2 Lectures 11:03

Topics covered:

  • What is break-even analysis? 
  • Calculate the break-even point 
  • Calculate margin of safety values
  • How to use Goal Seek to modify a break-even analysis
Do a Break Even Analysis
05:36

Topics covered: 

  • Definition of a cash flow forecast
  • Two kinds of cash flow forecasts
  • Create a forecast for a cash-only business
  • Create a forecast for a cash + accounts receivables business
Create a Cash Flow Forecast
05:27
+
Basic Accounting and Financial Statement Evaluation
4 Lectures 18:31

Topics covered:

  • The accounting cycle explained
  • Double entry vs. single entry accounting
  • How to create a revenue and expense journal in Excel
Recording Financial Transactions
03:31

Topics covered:

  • Profit margin values and growth rates 
  • How to calculate profitability ratios
  • Vertical and horizontal analysis
Evaluate an Income Statement
06:01

Topics covered:

  • Definition of a balance sheet
  • Owner's equity statements vs. a partner's capital statement
  • Working capital and liquidity ratios
  • Vertical and horizontal analysis
Preview 04:29

Topics covered: 

  • How to create a financial management plan (based on lessons 1-5)
  • The difference between revenue and cash flow 
  • How to create a budget analysis spreadsheet 
  • Compare monthly sales results to an annual sales goal
Preview 04:30
+
Financial Planning and Decision Making
4 Lectures 19:24

Topics covered: 

  • Use the Payback method to evaluate business investment opportunities
  • Use the Discounted Cash Flow method to evaluate business investment opportunities
Return on Investment Decisions
04:36

Topics covered: 

  • How to use Excel's financial functions to help make purchase decisions 
  • Borrowing money from a bank vs. borrowing money from family, friends or other private investors
Major Purchase Financing Decisions
05:30

Topics covered: 

  • How to calculate price markups and markdowns
  • What to consider when offering price discounts
  • Use Goal Seek to help make pricing decisions
Cost and Pricing Decisions
04:33

Topic covered:

  • Three ways to estimate how much a business is worth
  • Buyer and seller negotiations
Business Valuation Methods
04:45
+
Accounts Receivables and Payables
2 Lectures 14:06

Topics covered:

  • Benefits and risks of extending credit  
  • How to create an accounts receivables journal 
  • How to create an aging report
  • "Factoring" accounts receivables
  • How to create and send invoices
Managing Accounts Receivables
09:00

Topics covered:

  • The accounts payable process
  • Trade discounts
  • Cash discounts
  • How to create an accounts payable journal
Managing Accounts Payables
05:06
+
The Excel Toolbox
12 Lectures 38:30

Topics covered:

  • Definition of a formula
  • Definition of a function
  • How functions can be used to create a template
Preview 02:46

Topics covered:

  • Five kinds of chart elements
  • How to create a column chart
  • How to create a pie chart
Preview 02:40

Topics covered:

  • How to create named cell references
  • How to use break-even numbers to create a Scenario Manager Report
Scenario Manager
02:10

Topics covered:

  •  Use the Consolidate tool to create a quarterly income statement
  • Use the Consolidate tool to calculate the average values between multiple worksheets


Preview 02:23

Topics covered:

  • How to create a financial report, organized by categories and subcategories


Outlines and Subtotals
01:32

This video provides a brief introduction to Pivot Tables. More detailed information is available in the Excel Fundamental's Reference Guide, which can be found in Section 7.

Topics covered:

  • Three questions that should be answered before creating a Pivot Table
  • Two examples of how to create a simple Pivot Table
  • How to insert and use a Timeline Filter
  • How to insert and use Slicers
  • How to create and use a Pivot Chart
Introduction to Pivot Tables
06:01

Topics covered:

  • Adding Solver to the Ribbon
  • Use Solver to create a projected (aka pro forma) income statement
  • Use Solver to create a cash flow forecast
Create a Financial Forecast using Solver
03:41

Topics covered:

  • Use the Net Present Value (NPV) and Internal Rate of Return (IRR) functions to evaluate investment opportunities
  • How and when to use the XNPV and XIRR functions
  • Evaluate the cost of financing using the PMT, CUMPRINC and CUMIPMT functions
Advanced Financial Functions
05:10

Topics covered:

  • How to use Conditional Formatting to highlight a financial report
  • How to add a legend to a spreadsheet that has Conditional Formatting
Conditional Formatting
02:40

Topics covered:

  • Create filters based on one or more criteria
  • Change the order of how data appears using Sort options
  • How to use the SUBTOTAL function 
  • Evaluate financial data using an Advanced filter
Sorting and Filtering Data
05:13

Topics covered:

  • Definition of relative, absolute and mixed cell references
  • Example of when to use an absolute cell reference
  • Example of when to use a mixed cell reference
Absolute and Mixed Cell References
02:07

Topics covered:

  • How to add the Form tool to the Ribbon
  • Use the Form tool to add data to a Revenue and Expense Journal
  • Use the Form tool to search for data within a large Excel file
Use the Form Tool to Enter Data
02:07
+
Excel Fundamentals Library
1 Lecture 01:29
How to Use the Templates
01:29
About the Instructor
Shawn Myers, M.S.
0.0 Average rating
0 Reviews
7 Students
1 Course
Adjunct Instructor, Software Trainer

My interest in entrepreneurship started in 2010 when I was hired to create a series of workshops for the Business Opportunity and Workforce Development program, which focused on financial management training for entrepreneurs. This eventually led to opportunities to work with other government agencies and dozens of small business owners, where I provided help related to cash flow forecasting and general accounting. In 2011, I began teaching classes as a Certified Facilitator for the Kaufman Foundation’s FastTrac program, which is one of the largest providers of entrepreneurship education in the United States.

I’ve been a graduate school adjunct instructor at Wilmington University in New Castle, Delaware since 2013. My areas of specialization include technology management, course redevelopment, creating video content and Microsoft Office application training.

Testimonials

"Mr. Myers is extremely knowledgeable in business practices related to small business management and finances. I trust his expertise and will not hesitate to utilize his services again for future events”.

Ken R. Anderson, Director of Entrepreneurial and Small Business Support
Delaware Economic Development Office

“Mr. Myers is very knowledgeable about several business practices, especially in the area of financial planning and management. Not only is Mr. Myers professional, but he engages the class in his teachings and provides a wealth of information for students to peruse".

Mechell Burgette

Project Assistant – The BOWD Program

 “Shawn took what was seemingly a difficult subject and made it simple to understand; I look forward to more finance classes as I now understand many businesses have failed because of lack of knowledge in finances.”

Kauffman FastTrac student

“I was uncomfortable with this portion of the class (financial discussion) prior to the class because of previous experiences in school. However, Shawn really made sense of all the information and presented it in a manner that anyone could understand.”

Kauffman FastTrac student