Normal view MARC view ISBD view

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

By: Frye, Curtis, 1968- [author.].
Publisher: [New York, New York] : Published with the authorization of Microsoft Corporation by Pearson Education, Inc., [2019]Copyright date: 2019Description: xxiv, 454 pages : illustrations ; 24 cm.Content type: text Media type: unmediated Carrier type: volumeISBN: 9781509307678; 1509307672.Subject(s): Microsoft Excel (Computer file) | Microsoft Excel (Computer file) | Business -- Computer programs | Electronic spreadsheets | COMPUTERS / Desktop Applications / Spreadsheets | Business -- Computer programs | Electronic spreadsheetsDDC classification: 005.54 LOC classification: HF5548.4.M523 | F7877 2019HF5548.4.M523 | F7876 2019
Contents:
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.
Summary: 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.
List(s) this item appears in: 2019 New Titles | Data Analysis
Item type Current location Call number Copy number Status Date due Barcode Item holds
BOOK BOOK NCAR Library
Foothills Lab
HF5548.4.M523 F7877 2019 1 Checked out 12/10/2021 50583020010140
Total holds: 0

"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.

Questions? Email library@ucar.edu.

Not finding what you are looking for? InterLibrary Loan.