Lynda.com Excel 2010 Advanced Formulas and Function 英文版 CD

InExcel2010:AdvancedFormulasandFunctions,authorDennisTaylordemystifiesformulasandsomeofthemostchallengingofthenearly400functionsinExcelandshowshowtoputthemtotheirbestuse.Thecoursereviewsthebuilding-blockfunctions,alongwithafewcriticalkeyboardshortcutsthatwillspeedupworkingwithExceldata.ItalsocovershowtoperformadvancedsearchinganddataretrievalwithLOOKUPfunctions,tabulatedatawithcounting,statistical,andmathfunctions,reformatdatawithtextfunctions,andworkwithfinancialdatausingadvancedformulas.Exercisefilesaccompanythecourse.

Topicsinclude:

*Referencing,copying,updating,andconvertingformulas
*Usingthelogicalfunctionsandcreatingcompoundlogictests
*Searchingforandmatchingdatabasedonspecificcriteria
*Reconfiguringcelldatausingtextfunctions
*Calculatingdates,times,anddaysoftheweek
*Analyzingmathematicalandfinancialdata
*Usingthepowerfunctions,COUNTIFS,SUMIFS,andAVERAGEIFS
*Workingwithroundingfunctions
*Returningcellreferences