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










0 comments:

Post a Comment

Blog Archive