官术网_书友最值得收藏!

Excel數據透視表從新手到高手
會員

本書詳細介紹了Excel數據透視表的各項功能和使用方法,以及在多個行業中的實際應用。本書各章的先后順序以創建、設置、使用數據透視表的整體流程來進行安排,便于讀者學習和理解。本書包含大量示例,示例文件包括操作前的原始文件和操作后的結果文件,既便于讀者上機練習,又可以在練習后進行效果對比,快速掌握數據透視表的操作方法和技巧。本書共有13章和1個附錄,內容主要包括數據透視表的組成結構和常用術語、創建數據透視表的基本流程、創建和整理數據源、使用不同類型的數據源創建數據透視表、創建動態的數據透視表、布局字段、數據透視表的基本操作、改變數據透視表的布局和格式、設置數據的顯示方式、組合數據、查看明細數據、刷新數據、排序和篩選數據、設置數據的匯總方式和計算方式、創建計算字段和計算項、創建和編輯數據透視圖、在Excel中創建數據模型和數據透視表、使用PowerPivot創建數據模型和數據透視表、使用VBA自動化創建數據透視表,以及數據透視表在銷售、人力資源、財務、學校管理中的應用等內容。本書贈送所有案例的原始文件和結果文件、重點內容的多媒體視頻教程、教學PPT、Excel公式與函數基礎教程電子書、Excel圖表基礎教程電子書、ExcelVBA實用案例基礎教程電子書、Excel文檔模板、Windows10多媒體視頻教程。

宋翔編著 ·辦公軟件 ·11.2萬字

Learn Microsoft Project 2019
會員

ExploredetailedexplanationsandexamplestogetupandrunningwiththefivephasesoftheprojectmanagementlifecycleandintegrateprojectmanagementprinciplesinavarietyofprojectsKeyFeatures*ExplorevariousalgorithmsandthelatestfeaturesofMSProjecttoorganizeandkeeptrackofyourprojects*UnderstandWorkBreakdownStructure(WBS)toimproveproductivity*Applyreal-worldbestpracticesanddiscoverthetips,tricks,andpitfallsofschedulemanagementBookDescriptionMicrosoftProjectisoneofthemostpopularprojectmanagementtoolsforenterprisesofallsizesthankstoitswidevarietyoffeaturessuchasprojectscheduling,projectbudgeting,built-intemplates,andreportingtools.LearningMicrosoftProject2019willgetyoustartedwiththebasicsandgraduallyguideyouthroughthecompleteprojectlifecycle.StartingwithanoverviewofMicrosoftProject2019andabriefintroductiontoprojectmanagementconcepts,thisbookwilltakeyouthroughthedifferentphasesofprojectmanagement–initiation,planning,execution,control,andclosure.Youwillthenlearnhowtoidentifyandhandleproblemsrelatedtoscheduling,costing,resourcing,andworkallocation.Understandhowtousedynamicreportstocreatepowerful,automatedreportsanddashboardsattheclickofabutton.ThisMicrosoftProjectbookhighlightsthepitfallsofoverallocationanddemonstrateshowtoavoidandresolvetheseissuesusingawidespectrumoftools,techniques,andbestpractices.Finally,youwillfocusonexecutingAgileprojectsefficientlyandgettogripswithusingKanbanandScrumfeatures.Bytheendofthisbook,youwillbewell-versedwithMicrosoftProjectandhavetheskillsyouneedtouseiteffectivelyineverystageofprojectmanagement.Whatyouwilllearn*CreateefficientprojectplansusingMicrosoftProject2019*Gettogripswithresolvingcomplexissuesrelatedtotime,budget,andresourceallocation*Understandhowtocreateautomateddynamicreports*Identifyandprotectthecriticalpathinyourprojectandmitigateprojectrisks*Becomewell-versedwithexecutingAgileprojectsusingMSProject*UnderstandhowtocreatecustomreportsandmakethemavailableforfutureprojectsWhothisbookisforIfyouuseMicrosoftOfficeandarelookingtouseMSProjecttomanageyourprojectsefficiently,thisbookisforyou.Projectmanagersoranyoneinterestedinprojectmanagementwillalsofindthisbookuseful.BasicknowledgeofWindowsUIandMSOfficeproductsisrequired.

Srikanth Shirodkar ·辦公軟件 ·10.4萬字

QQ閱讀手機版

主站蜘蛛池模板: 文化| 襄城县| 婺源县| 大英县| 永善县| 怀安县| 嘉善县| 许昌县| 平山县| 建阳市| 云梦县| 蓝山县| 丰县| 牙克石市| 涞水县| 佛坪县| 宁明县| 正阳县| 唐海县| 柞水县| 郓城县| 淮南市| 太白县| 新化县| 修水县| 高平市| 黔江区| 邵阳市| 蛟河市| 寻乌县| 韩城市| 门源| 开原市| 宁远县| 长顺县| 赤峰市| 宜宾县| 苗栗县| 土默特左旗| 华容县| 渝中区|