资源描述:
《hungry minds excel 2002 formulas (john walkenbach)外语英文电子书》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、4800-Xcover8/16/0110:52AMPage1Excel2002FormulasTMExcel2002FormulasWalkenbachExcel2002FormulasJohnWalkenbachAuthorofExcel2002PowerProgrammingwithVBAPROFESSIONALMINDWAREJohnWalkenbachisaprincipalofJWalkandAssociates,Inc.,aUnleashthePowerofExcelFormulasconsultingfirmthatspecializ
2、es“EvenifyoualreadyhaveashelffullofExcelreferencebooks,NowrevisedtocoverthenewfeaturesofExcel2002andexpandedwithtwoall-newinspreadsheetapplicationdevelopment,andistheauthorchaptersonfinancialformulas,thisone-of-a-kindreferencedeliversallthetipsandbesuretosqueezeinacoupleofinch
3、esforthisone.”ofmorethantwodozenbooks,techniquesyouneedtomaximizeoneofthemostpowerfulspreadsheettools:—MicrosoftOfficePromagazineonthepreviouseditionincluding,mostrecently,Excel2002formulas.Withclearexplanationsofoperators,nesting,andfunctionsplushundredsBibleandExcel2002Power
4、ProgrammingwithVBA.Hemaintainsofpractical,real-worldexamples,spreadsheetexpertJohnWalkenbachsharesproven“TheSpreadsheetPage,”apopularsolutionsfortypical(andnot-so-typical)Excelchallenges.FromworkingwithdatestoWebresourceatwww.j-walk.com/ss.performingtablelookupstocreatingarray
5、formulas,thisin-depthguidewillhelpyousuperchargeyourspreadsheets—andmakethemostofExcel.PowerUtilityPaktrialBONUSCD-ROMYourRoadMaptoHigh-PerformanceExcelFormulasandmoreonCD-ROMVisitusatmandtbooks.comINCLUDES•GetaconciseoverviewofExcel’smanyfeatures,includingcellformatting,analy
6、sis•Atrialversionoftheauthor’stools,andprotectionoptionsaward-winningPowerUtility•Masterbasicformulafacts—includingabsolutevs.relativereferences,operators,Pak2000errorvalues,namingtechniques,andmore•Ademooftheauthor’sSound-Proof2000•GetpracticaltipsonusingExcel’sworksheetfunct
7、ionsinyourformulas•ExampleExcelworkbooksfrom•Findexpandedcoverageofdiscounting,depreciation,andotherfinancialformulasthebook•PerformmagicwithpowerfularrayformulasSystemRequirementsPROFESSIONALMINDWAREPentiumPCwithWindows98orgreater;•Useyourformulastoenhancechartsandpivottables
8、32MBRAM;MicrosoftExcel2002.SeeAbouttheCDappendixfordetails•De