MicrosoftExcel2019PivotTableDataCrunching(BusinessSkills)By作者:BillJelen–MichaelAlexanderISBN-10书号:1509307249ISBN-13书号:9781509307241Edition版本:1出版日期:2019-01-18pages页数:(512)RenownedExcelexpertsBillJelen(MrExcel)andMichaelAlexanderhelpyoucrunchdatafromanysourcewithExcel2019pivottables.UseExcel2019pivottablesandpivotchartstoproducepowerful,dynamicreportsinminutesinsteadofhours,totakecontrolofyourdataandyourbusiness.Evenifyou’venevercreatedapivottablebefore,thisbookwillhelpyouleveragealltheirremarkableflexibilityandanalyticalpower–includingvaluableimprovementsinExcel2019andExcelinOffice365.Drawingonmorethan45combinedyearsofExcelexperience,BillJelenandMichaelAlexanderofferpractical“recipes”forsolvingrealbusinessproblems,helpyouavoidcommonmistakes,andpresenttipsandtricksyou’llfindnowhereelse.Byreadingthisbook,youwill:Mastereasy,powerfulwaystocreate,customize,change,andcontrolpivottablesControlallfuturepivottablesusingnewpivottabledefaultsTransformhugedatasetsintoclearsummaryreportsInstantlyhighlightyourmostprofitablecustomers,products,orregionsUsePowerQuerytoquicklyimport,clean,shape,andanalyzedisparatedatasourcesBuildgeographicalpivottableswith3DMapConstructandsharestate-of-the-artdynamicdashboardsRevampanalysesontheflybydragginganddroppingfieldsBuilddynamicself-servicereportingsystemsShareyourpivottableswithcolleaguesCreatedatamashupsusingthefullPowerPivotcapabilitiesofExcel2019andExcelinOffice365AutomatepivottableswithmacrosandVBASavetimebyadaptingreportswithGetPivotDataDiscovertoday’smostusefulpivottabletipsandshortcuts
2024/1/12 19:03:08
109.67MB
EXCEL
1