Features
- Easy lessons for essential tasks
- Filled with helpful screen shots
- Skill-building practice files
- Copyright 2022
- Dimensions: 7-3/8" x 9-1/8"
- Pages: 480
- Edition: 1st
-
Book
- ISBN-10: 0-13-756427-9
- ISBN-13: 978-0-13-756427-9
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 answersbrisk 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
Downloads
Follow the instructions to download this book's lesson files.
- Click the Download button below to start the download.
- If prompted, click Save.
- Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.
Download
Sample Pages
Download the sample pages (includes Chapter 3)
Table of 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