Excel 2019 Beginners

Uncover the secrets of data analysis, explore multiple graphs and charts, and understand the nuances of Excel Web App integration. There are downloadable Follow-along Files for the student to practice each skill. The objectives, tips, exercises and tests are all easy to follow. The book refers and applies to Excel 2010 on the Windows 7 platform exclusively. It does not refer to other versions, platforms, or operating systems.

For example, the text didn’t explain what TRUE and FALSE means in VLOOKUP instructions until Chapter 5. Before that, the reader was simply told to use one or the other without an explanation. There were several instances in which instructions didn’t match with given data sets and/or screenshots. For example, the reader was asked to update a chart with a title that did not yet exist, and several screenshots included formatting and modified chart elements that weren’t explained. When asked to remove duplicates from a table, the instructions given did not produce the expected result. I had to use a different method to remove the duplicates, so I believe there was an instruction missing.

Everyday Excel

The spreadsheets that are provided use real-life data examples that students from a variety of backgrounds may find familiar, like calculating a monthly budget or a car payment. The organizational flow of this textbook is appropriate, especially for an entry-level textbook. It begins with the most basic elements of using Microsoft Excel such as how to open the program or even where to find the program in the start menu. This author starts the very basics in getting students to be able to understand how to even get the program open where to look for it. The text then, at an appropriate pace, develops the students understanding of Excel in a very thorough yet realistic manner.

  • Excel is a required or recommended skill for a variety of roles across industries, including accounting, auditing, finance, project management, marketing, technology, and education.
  • All chapters and sections flow well, so students do not need to waste time going back and forth unnecessarily.
  • In chapter 5, the screenshots for the pivot table don’t match the correct values while in progress, although the final screenshot does show the correct totals.
  • Any jargon used is defined and simplified for the readers with visual aids as applicable.
  • The reading level is appropriate for high school or post-secondary students.

Cultural references do not apply to this textbook on MS Excel. The examples used in the text appear to be from a wide range of gender, race, and ethnicity. Microsoft Excel 2019 Lessons Multiple images, figures, and charts use abbreviations. Chapters are well defined with terms, figures, and important terms are clearly marked and bold.

About the Book

ZDNET’s recommendations are based on many hours of testing, research, and comparison shopping. We gather data from the best available sources, including vendor and retailer listings as well as other relevant and independent reviews sites. And we pore over customer reviews to find out what matters to real people who already own and use the products and services we’re assessing. The chapters and sections are very consistent, as are the end-of-chapter exercise and test materials. The examples in the book were business-oriented vs. people-oriented, so they were not culturally insensitive or offensive in any way.

  • We’ve added 500+ learning opportunities to create one of the world’s most comprehensive free-to-degree online learning platforms.
  • In a subscription-based world, it’s hard to come across an app or software package that you can use for life with just a one-time purchase.
  • With enough practice, courses, tutorials, and boot camps can help you become familiar with the program for personal and professional use.

Leave A Comment

Your email address will not be published. Required fields are marked *

x

Lost Password