## Excel Basics Introduction Video #6 – Autofill Function

This video, #6 in the series aimed at introducing Excel for small business, shows the autofill function, an extremely useful tool in Excel.  Small business owners may find autofill saves a ton of time when tracking costs and revenues, making future business plans, and preparing for a loan.

Excel Basics Video #1 – Introduction to Excel for Small Business

Excel Basics Video #2 – Opening up a Workbook

Excel Basics Video #3 – Arithmetic & Formatting

Excel Basics Video #4 – Sums and Averages

Excel Basics Video #5 – Formatting Cells

Post read (2814) times.

## Excel Basics Introduction Video #5 – Formatting

Small business owners need to know how to organize their customers, costs, revenues, loans, financial information, and more in spreadsheet format.  This video, #5 in a  series produced for a regional micro lending organization, continues to introduce key skills to help you get started with Excel.  Formatting cells, columns, and rows saves a ton of time and will serve you well as you grow your business.

Excel Basics Video #1 – Introduction to Excel for Small Business

Excel Basics Video #2 – Opening up a Workbook

Excel Basics Video #3 – Arithmetic & Formatting

Excel Basics Video #4 – Sums and Averages

Excel Basics Video #5 – Formatting Cells

Excel Basics Video #6 – Autofill

Post read (9081) times.

## Excel Basics Introduction Video #4 – Sums and Averages

Small business owners need to track all of their business numbers in Excel, and this video introduces the most commonly used functions, Sum and Average.  This is video #4 (of a total of 6) that I made on behalf of a regional micro lending organization, Accion Texas.

If you’ve never learned to use Excel before, here’s your chance to get started on this essential software tool.

Please see related videos:

Excel Basics Video #1 – Introduction to Excel for Small Business

Excel Basics Video #2 – Opening up a Workbook

Excel Basics Video #3 – Arithmetic & Formatting

Excel Basics Video #4 – Sums and Averages

Excel Basics Video #5 – Formatting Cells

Excel Basics Video #6 – Autofill

Post read (4889) times.

## Excel Basics Introduction Video #3 – Arithmetic and The Formula Bar

Excel is so useful for small businesses that I’m posting a series of short instructional videos I made in collaboration with Accion Texas, a regional micro lending organization.  The idea is to get entrepreneurs to start tracking their sales, customers, revenues, and profits in a more useful format than a sheet of paper or the back of a notebook.

This is video #3, introducing the idea that Excel can be programmed to do any math you can think of, something which is especially useful for small businesses.

Please see related posts:

Excel Basics Video #1 – Introduction to Excel for Small Business

Excel Basics Video #2 – Opening up a Workbook

Excel Basics Video #3 – Arithmetic & Formatting

Excel Basics Video #4 – Sums and Averages

Excel Basics Video #5 – Formatting Cells

Excel Basics Video #6 – Autofill

Post read (7140) times.

## Excel Basics Introduction Video #2 – Opening and Starting a Worksheet

Below is the second in a series of 6 videos introducing the idea of using Excel to track your small business information. This series was created to support the educational mission of Accion Texas, a regional micro lending organization, but I hope it has value to others starting out with their own business who may not have used Excel in the past.

And also, in case you missed it before, entrepreneurship is the key to building wealth, which I also wrote about here.

Please also see related video posts:

Excel Basics Video #1 – Introduction to Excel for Small Business

Excel Basics Video #2 – Opening up a Workbook

Excel Basics Video #3 – Arithmetic & Formatting

Excel Basics Video #4 – Sums and Averages

Excel Basics Video #5 – Formatting Cells

Excel Basics Video #6 – Autofill

Post read (5860) times.

## Excel Basics Video #1: Introduction for Small Business Owners

Lately I’ve been working with Accion Texas, a regional micro lender organization, to produce educational videos for entrepreneurs.  Below is an introduction to the first series of six videos, which covers the first steps in using Excel, such as how to open up a workbook, how to begin to format a worksheet, and how to program simple math in your spreadsheet.

The next series of videos – still to be produced – will be on how a small business owner can use Excel to tracks costs and revenues, and how to model future growth.

I’ll be posting the basic introductory series of six videos here in the next few days and weeks.

Eventually I hope to work my way up to showing how Excel helps us calculate key personal finance topics, such as modeling a home loan or car loan, calculating compound interest, and discounted cash flows.

One of the advantages of this very basic series is that – for anyone who has never used Excel but wants to learn those advanced skills – here’s a way to jump on the surfboard while the waves still move very slowly.

Please see related Posts:

Excel Basics Video #1 – Introduction to Excel for Small Business

Excel Basics Video #2 – Opening up a Workbook

Excel Basics Video #3 – Arithmetic & Formatting

Excel Basics Video #4 – Sums and Averages

Excel Basics Video #5 – Formatting Cells

Excel Basics Video #6 – Autofill

Post read (5960) times.