O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Excel For Business

Video Description

In this Microsoft Excel for Small Business training course, expert author Erin Olsen will teach you how to utilize the tools in Excel to managing and build your business. This course is designed for users that already have a general working knowledge of Excel. You will start out by learning how to manage your contacts, including customers, vendors, and employees, and also learn how to analyze your demographics and create scheduled and marketing calendars. Erin will teach you how to manage money in Excel by building budgets and planning and tracking loans. This video tutorial will show you how to supervise sales with Excel, prepare invoices, and gauge your business status with Excel. You will also cover topics including configuring cash flow statements, resolving business ratios, and finalizing financial statements. Once you have completed this computer based training course, you will be able to harness the power of Excel and use it for managing, marketing, and building your business. Working files are included, allowing you to follow along with the author throughout the lessons.

Table of Contents

  1. Introduction To Excel For Business
    1. Marketing, Managing And Building Business With Excel 00:04:52
    2. About The Author 00:07:51
    3. What You Will Learn 00:03:38
    4. How To Access Your Working Files 00:02:45
    5. Using The Working Files 00:03:23
  2. Contact Management And Marketing With Excel
    1. Contact Management And Marketing With Excel 00:03:52
    2. Managing Customers Vendors And Employees - Part 1 00:10:14
    3. Managing Customers Vendors And Employees - Part 2 00:08:33
    4. Managing And Marketing With Personalized Communications - Part 1 00:08:23
    5. Managing And Marketing With Personalized Communications - Part 2 00:10:19
    6. Gaining Product And Service Insights 00:08:06
    7. Analyzing Demographics 00:11:07
    8. Creating Scheduling And Marketing Calendars 00:09:38
  3. Managing Money With Excel
    1. Managing Money With Excel 00:05:22
    2. Building Budgets - Part 1 00:08:12
    3. Building Budgets - Part 2 00:09:06
    4. Building Budgets - Part 3 00:10:28
    5. Planning And Tracking Loans - Part 1 00:09:04
    6. Planning And Tracking Loans - Part 2 00:06:28
    7. Keeping Account Registers 00:07:54
  4. Supervising Sales With Excel
    1. Supervising Sales With Excel 00:07:29
    2. Participating In The Pipeline - Part 1 00:09:36
    3. Participating In The Pipeline - Part 2 00:07:37
    4. Assembling Schedules 00:08:00
    5. Preparing Invoices 00:07:19
    6. Assessing Account Aging 00:10:00
  5. Gauging Business Status With Excel
    1. Gauging Business Status With Excel - Part 1 00:03:59
    2. Gauging Business Status With Excel - Part 2 00:10:19
    3. Configuring Cash Flow Statements - Part 1 00:06:56
    4. Configuring Cash Flow Statements - Part 2 00:07:17
    5. Resolving Business Ratios - Part 1 00:05:57
    6. Resolving Business Ratios - Part 2 00:04:25
    7. Finalizing Financial Statements - Part 1 00:05:41
    8. Finalizing Financial Statements - Part 2 00:06:41
  6. Course Closing
    1. What You Now Know 00:02:10