Microsoft Excel 2019 Step by Step

by Curtis Frye

Overview

The full text downloaded to your computer

With eBooks you can:

• search for key concepts, words and phrases
• make highlights and notes as you study
• share your notes with friends

eBooks are downloaded to your computer and accessible either offline through the Bookshelf (available as a free download), available online and also via the iPad and Android apps.

Upon purchase, you will receive via email the code and instructions on how to access this product.

Time limit

The eBooks products do not have an expiry date. You will continue to access your digital ebook products whilst you have your Bookshelf installed.

This is learning made easy. Get more done quickly with Excel 2019. Jump in wherever you need answers--brisk lessons and many screen shots 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
• Filter, sort, summarize, and combine data
• Analyse data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
• Visualise data with charts and graphs, including new sunbursts, waterfalls, and treemaps
• Build data models and use them in business intelligence analyses
• Create timelines, forecasts, and visualisations, including KPIs and PowerMap data maps
• Look up just the tasks and lessons you need

Product Details

ISBN-13:	9781509306169
Publisher:	Pearson Education
Publication date:	11/19/2018
Series:	Step by Step
Sold by:	Barnes & Noble
Format:	eBook
Pages:	480
File size:	37 MB
Note:	This product may take a few minutes to download.
Age Range:	18 Years

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: Create dynamic worksheets by using PivotTables
• 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