Get the Best Gifts for Dad in Time With Store Pick-Up Shop Father's Day
Microsoft Excel 2019 Step by Step (B&N Exclusive Edition)

Microsoft Excel 2019 Step by Step (B&N Exclusive Edition)

by Curtis Frye
Microsoft Excel 2019 Step by Step (B&N Exclusive Edition)

Microsoft Excel 2019 Step by Step (B&N Exclusive Edition)

by Curtis Frye

Overview

The quick way to learn Microsoft Excel 2019!

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
  • B&N Exclusive! Analyze cash flows and time value of money
  • B&N Exclusive! Get more out of your PivotTables and PivotCharts
  • B&N Exclusive! Create a dashboard worksheet

Product Details

ISBN-13: 9780135412169
Publisher: Microsoft Press
Publication date: 12/11/2018
Series: Step by Step Series
Edition description: B&N Exclusive Edition
Pages: 544
Product dimensions: 7.30(w) x 8.50(h) x 1.10(d)

About the Author

Curt Frye is the author of more than 30 books, including Microsoft Excel 2016 Step by Step and Microsoft OneNote Step by Step for Microsoft Press. He has also created and recorded more than 60 online training courses for lynda.com and LinkedIn Learning, including Office 365 for Mac: Excel Essential Training, Excel: Scenario Planning and Analysis, Excel: Statistical Process Control, and Microsoft Excel: Using Solver for Decision Analysis.

Curt is a popular conference speaker, offering his Improspectives® program on applying the techniques of improvisational theater to business and life as well as Which Game Are You Playing?, which applies lessons from the strategies and tactics of popular games to business. He earned his undergraduate degree in political science from Syracuse University in 1990 and will receive his MBA from the University of Illinois in December 2018.

Curt lives in Portland, Oregon with his wife Virginia

Table of Contents

Part 1: Create and format workbooks

Chapter 1: Set up a workbook

Chapter 2: Work with data and Excel tables

Chapter 3: Perform calculations on data

Chapter 4: Change workbook appearance

Part 2: Analyze and present data
Chapter 5: Manage worksheet data

Chapter 6: Reorder and summarize data

Chapter 7: Combine data from multiple sources

Chapter 8: Analyze alternative data sets

Chapter 9: Create charts and graphics

Chapter 10: Use PivotTables and PivotCharts

Part 3: Collaborate and share in Excel
Chapter 11: Print worksheets and charts

Chapter 12: Automate repetitive tasks by using macros

Chapter 13: Work with other Microsoft Office apps

Chapter 14: Collaborate with colleagues

Part 4: Perform advanced analysis
Chapter 15: Perform business intelligence analysis

Chapter 16: Create forecasts and visualizations

Part 5: Barnes & Noble Exclusive

Chapter 17: Analyze cash flows and time value of money

Chapter 18: Get more out of your PivotTables and PivotCharts

Chapter 19: Create a dashboard worksheet

From the B&N Reads Blog
Page 1 of

Related Subjects

Computers
Applications & Software
Microsoft Applications
Spreadsheets
Microsoft Excel
Microsoft Excel 2019
Computers
Applications & Software
Microsoft Applications
Spreadsheets
Microsoft Excel
Microsoft Excel 2019

Customer Reviews