Microsoft Excel Step by Step (Office 2021 and Microsoft 365) (Step by Step)

Lambert, Joan/ Frye, Curtis

Addison Wesley（2022/01発売）

Addison Wesley（2022/01発売）

• 製本 Paperback:紙装版/ペーパーバック版／ページ数 480 p.
• 言語 ENG
• 商品コード 9780137564279
• DDC分類 005.54

Full Description

The quick way to learn Microsoft Excel!

 

This is learning made easy. Get more done, more quickly, with Microsoft Excel. 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 effective visual impact
Perform calculations and find and correct errors
Manage, filter, summarize, validate, reorder, and combine data
Identify trends, illustrate processes and relationships, and dynamically analyze data
Build sophisticated forecasts, key performance indicators (KPIs), and timelines
Visualize data with customized charts, 3D maps, and other powerful tools
Import, process, summarize, and analyze huge data sets with PowerPivot and Power Query
Use powerful Excel Data Models for advanced business intelligence

Contents

Introduction

Part 1: Create and format workbooks

1          Set up a workbook

2          Work with data and Excel tables

3          Perform calculations on data

4          Change workbook appearance

 

Part 2: Analyze and present data

5          Manage worksheet data

6          Reorder and summarize data

7          Combine data from multiple sources

8          Analyze alternative data sets

9          Create charts and graphics. 207

10        Create PivotTables and PivotCharts

 

Part 3: Collaborate and share in Excel

11        Print worksheets and charts

12        Automate tasks and input

13        Work with other Microsoft 365 apps

14        Collaborate with colleagues

 

Part 4: Perform advanced analysis

15        Perform business intelligence analysis

16        Create forecasts and visualizations