Wednesday, September 22, 2010

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








Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)