Microsoft Excel 2019 : step by step / by Curtis Frye.

"Microsoft Press"--Back cover.

Includes index.

Part 1: Create and format workbooks. Set up a workbook ; Work with data and Excel tables ; Perform calculations on data ; Change workbook appearance -- Part 2: Analyze and present data. Manage worksheet data ; Reorder and summarize data ; Combine data from multiple sources ; Analyze alternative data sets ; Create charts and graphics ; Use PivotTable and PivotCharts -- Part 3: Collaborate and share in Excel. Print worksheets and charts ; Automate repetitive tasks by using macros ; Work with other Microsoft Office apps ; Collaborate with colleagues -- Part 4: Perform advanced analysis. Perform business intelligence analysis ; 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"--Publisher's description.