What do you think?
Rate this book
Microsoft Excel 2019 Step by Step
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
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
473 pages, Kindle Edition
Published November 19, 2018
23 people are currently reading
8 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
October 14, 2020
I am this book's target audience. I knew next to nothing about Excel before picking this book up. Most of the chapters covering the basics are well done and easy to understand. The chapters covering more complex features (macros, pivot tables, PowerPivot, and forecasting) are nearly unusable (I say that with my Computer Engineer husband, with tons of Excel experience, beside me nodding in agreement). If you're just looking for basic Excel functions, this book will be fine. If you're looking to maximize the potential of the program, keep looking.
There was a minor error on page 86.
The last sentence of the 2nd paragraph reads: "For example, you could find the number of customers from Washington who were billed at least $100,000 by using the formula =COUNTIF(D3:D6, "=WA", E3:E6, ">=100000")." There is no data in column E in the referenced set of data. It should read: =COUNTIF(C3:C6, "=WA", D3:D6, ">=100000").
In the practice questions for chapter 15:
AnalyzePowerPivotData Worksheet, you are asked to create a pivot table from the Power Pivot window and then add a calculated column. This is impossible. When you create a pivot table from the PowerPivot window the option to add a calculated column is greyed out. To complete that practice worksheet, I had to create the pivot table from the existing Excel table (which is not what you're instructed to do). Only then was the option to add a calculated column available. You can add a calculated column in the PowerPivot window, but that table was in a different configuration than the pivot table you are instructed to create.
ViewUsingTimelines Worksheet, I could not get a timeline to appear on the Summary tab. I created a new pivot table using the data in Sheet 1 and then had no problem creating a timeline on the new sheet. I'm not sure if there is some issue with the file or what, but that was frustrating to deal with.
In chapter 16:
=FORECAST.ETS.SEASONALITY(target_date, values, timeline, [seasonality], [data_completion], [aggregation])
According to Excel 2019:
=FORECAST.ETS.SEASONALITY(values, timeline, [data completion], [aggregation])
It was at this point I gave up. The information was so inaccurate as to be unusable. Yes, I am new to Excel. Yes, it's possible a file was corrupted somehow after it left the Microsoft website. But, there's no way this formula would be so wildly different.
And how hard is it to add screenshots of what the practice worksheets should look like? I had no way of verifying I had completed calculations correctly.
There was a minor error on page 86.
The last sentence of the 2nd paragraph reads: "For example, you could find the number of customers from Washington who were billed at least $100,000 by using the formula =COUNTIF(D3:D6, "=WA", E3:E6, ">=100000")." There is no data in column E in the referenced set of data. It should read: =COUNTIF(C3:C6, "=WA", D3:D6, ">=100000").
In the practice questions for chapter 15:
AnalyzePowerPivotData Worksheet, you are asked to create a pivot table from the Power Pivot window and then add a calculated column. This is impossible. When you create a pivot table from the PowerPivot window the option to add a calculated column is greyed out. To complete that practice worksheet, I had to create the pivot table from the existing Excel table (which is not what you're instructed to do). Only then was the option to add a calculated column available. You can add a calculated column in the PowerPivot window, but that table was in a different configuration than the pivot table you are instructed to create.
ViewUsingTimelines Worksheet, I could not get a timeline to appear on the Summary tab. I created a new pivot table using the data in Sheet 1 and then had no problem creating a timeline on the new sheet. I'm not sure if there is some issue with the file or what, but that was frustrating to deal with.
In chapter 16:
=FORECAST.ETS.SEASONALITY(target_date, values, timeline, [seasonality], [data_completion], [aggregation])
According to Excel 2019:
=FORECAST.ETS.SEASONALITY(values, timeline, [data completion], [aggregation])
It was at this point I gave up. The information was so inaccurate as to be unusable. Yes, I am new to Excel. Yes, it's possible a file was corrupted somehow after it left the Microsoft website. But, there's no way this formula would be so wildly different.
And how hard is it to add screenshots of what the practice worksheets should look like? I had no way of verifying I had completed calculations correctly.
Displaying 1 of 1 review