Microsoft Excel Step by Step (Office 2021 and Microsoft 365)
1st Edition
Published on 26. February 2022
480 pages
978-0-13-756435-4 (ISBN)
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
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
More details
Series
Edition
1. Auflage
Language
English
Place of publication
Boston
United States
Publishing group
Pearson Education (US)
Target group
Professional and scholarly
File size
36,71 MB
ISBN-13
978-0-13-756435-4 (9780137564354)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Joan Lambert | Curtis Frye
Microsoft Excel Step by Step (Office 2021 and Microsoft 365)
Book
01/2022
1st Edition
Addison Wesley
€43.99
Available immediately
Persons
Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people seeking certification of their computer skills or who simply want to get things done efficiently. She has written more than 50 books about Windows, Office, and SharePoint technologies, including dozens of Step by Step books and five generations of Microsoft Office Specialist certification study guides. Students who use the GO! with Microsoft Office textbook products may overhear her cheerfully demonstrating Office features in the videos that accompany the series.
A native of the Pacific Northwest, Joan has had the good fortune to live in many parts of the world. She currently resides with her family-one daughter, two dogs, two cats, and seven chickens-in the Beehive State, where she enjoys the majestic mountain views every day...from her office chair.
A native of the Pacific Northwest, Joan has had the good fortune to live in many parts of the world. She currently resides with her family-one daughter, two dogs, two cats, and seven chickens-in the Beehive State, where she enjoys the majestic mountain views every day...from her office chair.
Content
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
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
