Home > Store

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

eBook

  • Your Price: $30.39
  • List Price: $37.99
  • Includes EPUB and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    Adobe Reader PDF The popular standard, used most often with the free Acrobat® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.

About

Features

  • Easy lessons for essential tasks
  • Filled with helpful screen shots
  • Skill-building practice files

Description

  • Copyright 2022
  • Pages: 480
  • Edition: 1st
  • eBook
  • ISBN-10: 0-13-756434-1
  • ISBN-13: 978-0-13-756434-7

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

Downloads

Follow the instructions to download this book's lesson files.

  1. Click the Download button below to start the download.
  2. If prompted, click Save.
  3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.
Download

Sample Content

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

Updates

Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.