Spreadsheets

We all have to manage money, whether it's our personal budget or planning a conference for our company. One of the easiest ways to manage money is to use an electronic spreadsheet. Let's take a look at some videos that will take you from the basics to more advanced applications.

---

Video #1 - Overview of Excel from SchoolFreeWare

---

Video #2 - Autofill in Excel Tutorial from SchoolFreeWare

---

Video #3 - Format Text in Excel 2007 (2 minutes)

---

Video #4 - Format Cells as a Table in Excel

---

Video #5 - Basic Math in Excel

---

Video #6 - Keyboard Shortcuts

---

Video #7 - Formula Basics using the equal sign & ampersand

---

Video #8 - Calculating Formulas - Using Percentage (monthly payments)

---

Video #9 - Sorting Data in Excel

---

Video #10 - Create a Cluster Column Chart in Excel 2007

---

Video # 11 - Creating and Editing Charts in Excel 2007 - clear instructions/sound - creates a chart based on a survey

---

Video #12 - Creating Excel Pie Charts

---

Video #13 - Using Themes

---

Series links: on YouTube

DemoTrainer videos (high quality, professional videos) -- I'd rank them #1 (however, they can't be embedded, so must be watched at YouTube) http://www.youtube.com/user/DemoTrainer

Excelsfun videos -- you can also download the free workbook to go along with this series of videos -- http://www.youtube.com/user/ExcelIsFun

MotionTraining Excel Videos -- http://www.youtube.com/user/MotionTraining

---

This material was gathered by Linda Aksomitis

Instructor for Introduction to Internet Writing Markets

and Credenda Virtual College

---