Lynda.com Excel 2007 Creating Business Budgets 英文版 CD

Genre:eLearning

InExcel2007:CreatingBusinessBudgetsCurtFryeshowsbusinessownersandmanagershowtouseExceltocreateusefulbudgetsthathelpthemmanageresourcesprudently.ThecoursedemonstrateshowtouseExcelspreadsheetstotrackcashonhand,andhowtoprojectincomeandexpensesbasedonscenarios.ItalsoshowshowtotakeinformationfromvarioussourcestocreateasingleExceltable,andthenusePivotTablestoanalyzethatdata.Exercisefilesaccompanythecourse.

Topicsinclude:

*Trackingincomeandexpensesbycategoryandcontract
*Usingbalancesheets
*Designingworksheetstoassistdecisionmaking
*Creatingincomestatements
*Calculatingloanspaymentsandinterest
*Creatingcellreferencestootherworksheets
*Summarizingdatainachart
*Buildingalternativebudgetscenarios