learn excel Archives - Bankers Anonymous

December 12, 2013January 7, 2014

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.

December 12, 2013December 12, 2013

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 (9076) times.

December 5, 2013December 12, 2013

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 (7137) times.

September 16, 2013September 16, 2013

Excel Cheat Sheet – And Not Just For Beginners

I’ve been spending my days lately putting together lessons on Excel for beginners.

A reader sent a link to this printable info-graphic – a great way for folks new to Excel, as well as experienced Excel users, to dig into the power of the program.

The first two pages are very basic, and then the info-graphic really digs into more advanced stuff.

http://graduatedegreeprogram.net/excel-cheats/