Excel 2007 Macros Made Easy
出版时间:
2008-10
ISBN:
9780071599580
定价:
274.80
装帧:
平装
开本:
其他
纸张:
其他
页数:
208页
正文语种:
英语
-
GetbeyondthebasicswithExcel2007macros
NowyoucantakeyourExcelskillstothenextlevelwithhelpfromthishands-onguide.Excel2007MacrosMadeEasyshowsyouhowtocreate,run,andrevisemacrostosimplifyrepetitivetasksandstoretheinstructionsforcomplicatedones.You'lllearntouseVisualBasicforApplications(VBA),addmacrostotheExceltoolbar,andshareyourmacroswithotherusers.Discoverhoweasyitistodevelopcustommacros,savetime,andboostproductivity.
Recordandeditmacros
CreateanddebugmacrosinVBA
SavemacrostothePersonalMacroWorkbookorotherworkbooks
CreateVBAsubroutinesandfunctions
Developinteractivemacros
Formatcellsusingmacros
Createvariablesandarrays
ApplylogictomacroswithIf/Then/Elseroutines
Useloopstoprocessdata
Addcontrolstoyourworksheets
GailPerryisaCPA,financialjournalist,theauthormorethan20booksonfinancialsoftware,taxes,andpersonalfinance.SheisthemanagingeditorforAccountingWEB,acontributingeditorforSMBFinancemagazine,andaninstructor. Introduction
Chapter1.RecordingMacros
Chapter2.EditingMacros
Chapter3.CreatingMacrosinVisualBasic
Chapter4.StoringMacros
Chapter5.UnderstandingMacroCommands
Chapter6.UsingVisualBasicSubroutinesandCreatingFunctions
Chapter7.CreatingInteractiveMacros
Chapter8.UsingMacrostoFormatCells
Chapter9.UsingVariablesinMacros
Chapter10.CreatingIf/Then/ElseRoutines
Chapter11.ExploringLoops
Chapter12.AddingControlstoYourWorksheetsIndex
-
内容简介:
GetbeyondthebasicswithExcel2007macros
NowyoucantakeyourExcelskillstothenextlevelwithhelpfromthishands-onguide.Excel2007MacrosMadeEasyshowsyouhowtocreate,run,andrevisemacrostosimplifyrepetitivetasksandstoretheinstructionsforcomplicatedones.You'lllearntouseVisualBasicforApplications(VBA),addmacrostotheExceltoolbar,andshareyourmacroswithotherusers.Discoverhoweasyitistodevelopcustommacros,savetime,andboostproductivity.
Recordandeditmacros
CreateanddebugmacrosinVBA
SavemacrostothePersonalMacroWorkbookorotherworkbooks
CreateVBAsubroutinesandfunctions
Developinteractivemacros
Formatcellsusingmacros
Createvariablesandarrays
ApplylogictomacroswithIf/Then/Elseroutines
Useloopstoprocessdata
Addcontrolstoyourworksheets
-
作者简介:
GailPerryisaCPA,financialjournalist,theauthormorethan20booksonfinancialsoftware,taxes,andpersonalfinance.SheisthemanagingeditorforAccountingWEB,acontributingeditorforSMBFinancemagazine,andaninstructor.
-
目录:
Introduction
Chapter1.RecordingMacros
Chapter2.EditingMacros
Chapter3.CreatingMacrosinVisualBasic
Chapter4.StoringMacros
Chapter5.UnderstandingMacroCommands
Chapter6.UsingVisualBasicSubroutinesandCreatingFunctions
Chapter7.CreatingInteractiveMacros
Chapter8.UsingMacrostoFormatCells
Chapter9.UsingVariablesinMacros
Chapter10.CreatingIf/Then/ElseRoutines
Chapter11.ExploringLoops
Chapter12.AddingControlstoYourWorksheetsIndex
查看详情
暂无旧书在售