Microsoft Excel 2019 : step by step /
by Curtis Frye.
- USA : Pearson Education, 2019.
- xxiv, 454 pages : illustrations ; 24 cm.
"Published with the authorization of Microsoft Corporation"--Title page verso. Includes index.
Part 1: Create and format workbooks Chapter 1: Set up a workbook Chapter 2: Work with data and Excel tables Chapter 3: Perform calculations on data Chapter 4: Change workbook appearance Part 2: Analyze and present data Chapter 5: Manage worksheet data Chapter 6: Reorder and summarize data Chapter 7: Combine data from multiple sources Chapter 8: Analyze alternative data sets Chapter 9: Create charts and graphics Chapter 10: Create dynamic worksheets by using PivotTables Part 3: Collaborate and share in Excel Chapter 11: Print worksheets and charts Chapter 12: Automate repetitive tasks by using macros Chapter 13: Work with other Microsoft Office apps Chapter 14: Collaborate with colleagues Part 4: Perform advanced analysis Chapter 15: Perform business intelligence analysis Chapter 16: Create forecasts and visualizations
This is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers--brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewing -- Perform calculations and find and correct errors -- Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines -- Visualize data with 3D maps, funnel charts, and other powerful tools -- Import, process, summarize, and analyze huge datasets with Excel's improved PowerPivot and Power Query -- Build powerful data models and use them in business intelligence -- Look up just the tasks and lessons you need.--