内容简介
HelpyourstudentsmasterbothbasicandadvancedskillsinVisualBasicforApplications(VBA),theprogramminglanguageforMicrosoftOffice,withthisessentialtool.ChrisAlbright'sVBAFORMODELERS:DEVELOPINGDECISIONSUPPORTSYSTEMSWITHMICROSOFTOFFICEEXCEL,5Eprovideseverythingyouneedtoteachstudentshowtoautomatecommonspreadsheettasksaswellascreatethesophisticatedmanagementscienceapplicationsneededinbusinesstoday.ThefirsthalfofthebookintroducesstudentstothefundamentalsofVBAforExcel.ThesecondhalfputsknowledgeintoactionasitillustrateshowtoautomateanumberofmanagementsciencemodelsusingVBA.Studentslearnhowtouseapplicationstopresentauser-friendlyinterfaceforinputsandresults.Thisneweditionimprovescodereadability,introducesPowerPivotandtheExcelDataModelanddemonstratesanewmethodtopassinformationbetweenmodulesanduserformsthatavoidsusingglobalvariables.