Microsoft Excel For Business

Video description

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.

Publisher resources

Download Example Code

Introduction To Excel For Business

Marketing, Managing And Building Business With Excel 00:04:52

About The Author 00:07:51

What You Will Learn 00:03:38

Using The Working Files 00:03:23

Contact Management And Marketing With Excel

Contact Management And Marketing With Excel 00:03:52

Managing Customers Vendors And Employees - Part 1 00:10:14

Managing Customers Vendors And Employees - Part 2 00:08:33

Managing And Marketing With Personalized Communications - Part 1 00:08:23

Managing And Marketing With Personalized Communications - Part 2 00:10:19

Gaining Product And Service Insights 00:08:06

Analyzing Demographics 00:11:07

Creating Scheduling And Marketing Calendars 00:09:38

Managing Money With Excel

Managing Money With Excel 00:05:22

Building Budgets - Part 1 00:08:12

Building Budgets - Part 2 00:09:06

Building Budgets - Part 3 00:10:28

Planning And Tracking Loans - Part 1 00:09:04

Planning And Tracking Loans - Part 2 00:06:28

Keeping Account Registers 00:07:54

Supervising Sales With Excel

Supervising Sales With Excel 00:07:29

Participating In The Pipeline - Part 1 00:09:36

Participating In The Pipeline - Part 2 00:07:37

Assembling Schedules 00:08:00

Preparing Invoices 00:07:19

Assessing Account Aging 00:10:00

Gauging Business Status With Excel

Gauging Business Status With Excel - Part 1 00:03:59

Gauging Business Status With Excel - Part 2 00:10:19

Configuring Cash Flow Statements - Part 1 00:06:56

Configuring Cash Flow Statements - Part 2 00:07:17

Resolving Business Ratios - Part 1 00:05:57

Resolving Business Ratios - Part 2 00:04:25

Finalizing Financial Statements - Part 1 00:05:41

Finalizing Financial Statements - Part 2 00:06:41

Course Closing

What You Now Know 00:02:10

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.