Powerful ideas from top nonfiction
Try Blinkist to get the key ideas from 7,500+ bestselling nonfiction titles and podcasts. Listen or read in just 15 minutes.
Get started for free
Blink 3 of 8 - The 5 AM Club
by Robin Sharma
Excel 2019 Basics summary
Nathan George
Brief summary
Excel 2019 Basics by Nathan George is a comprehensive guide that teaches you the fundamental skills and functions of Excel. From creating spreadsheets to analyzing data, this book will help you master the essentials of Excel 2019.
Topics
Table of Contents
Excel 2019 Basics
Summary of key ideas
Exploring the Basics of Excel 2019
In Excel 2019 Basics by Nathan George, we delve into the core functionalities of Microsoft Excel, starting with the essential aspects of creating, editing, and formatting spreadsheets. The book provides a comprehensive understanding of Excel, ideal for beginners and those looking to refresh their knowledge.
The book kicks off with a detailed exploration of the Excel interface and its various components, such as the Ribbon, Quick Access Toolbar, and the different views available. George then introduces the basics of data entry, including how to input, edit, and delete data in a worksheet. He further explains how to navigate and select cells, columns, and rows efficiently.
Understanding Formulas and Functions
George then delves into Excel's most powerful feature: formulas and functions. He explains the distinction between the two and demonstrates how to create basic formulas for simple calculations. Moving on, he introduces a range of functions like SUM, AVERAGE, MAX, and MIN, explaining their usage and how to apply them to your data.
Once the foundational aspects are covered, the book progresses to more advanced functions such as IF, VLOOKUP, and HLOOKUP. George provides clear examples and step-by-step instructions, ensuring the reader understands how to use these functions effectively in various scenarios.
Working with Data and Tables
Following this, Excel 2019 Basics delves into data management. George explains how to sort and filter data, making it easier to analyze and understand. He then introduces the concept of Excel tables, explaining their advantages and how to create, format, and manage them.
George also covers more complex data management operations, such as removing duplicates, consolidating data from multiple sources, and using data validation to control the type of data entered into a cell. These topics are especially useful for professionals working with large datasets.
Visualizing Data with Charts and Graphics
In the latter part of the book, George explores Excel's visualization tools. He explains how to create various types of charts, including bar, line, pie, and scatter plots, and how to customize them to effectively represent your data. Additionally, he introduces sparklines, which are mini-charts that fit into a single cell.
Furthermore, George discusses the use of graphics and images in Excel, explaining how to insert, format, and manipulate them within your spreadsheets. He also touches upon SmartArt, a feature that allows you to create professional-looking diagrams and graphics directly in Excel.
Securing and Sharing Your Work
Finally, the book concludes with a discussion on securing and sharing your Excel work. George explains how to protect your data with passwords, restrict access to specific parts of your workbook, and how to track changes made by multiple users. He also covers the various options available for sharing your Excel files, including email, OneDrive, and SharePoint.
In conclusion, Excel 2019 Basics by Nathan George provides a comprehensive introduction to Microsoft Excel, covering everything from the fundamental features to more advanced functionalities. Whether you're a beginner or looking to expand your Excel skills, this book serves as an excellent guide to mastering one of the most widely used spreadsheet applications.
How do we create content on this page?
More knowledge in less time
Read or listen
Get the key ideas from nonfiction bestsellers in minutes, not hours.
Find your next read
Get book lists curated by experts and personalized recommendations.
Shortcasts New
We’ve teamed up with podcast creators to bring you key insights from podcasts.
What is Excel 2019 Basics about?
Excel 2019 Basics by Nathan George is a comprehensive guide designed to help beginners understand and navigate through Microsoft Excel. This book covers fundamental concepts such as creating spreadsheets, formatting data, using formulas and functions, and analyzing data through charts and tables. With step-by-step instructions and practical examples, it serves as an essential resource for anyone looking to master Excel 2019.
Excel 2019 Basics Review
Excel 2019 Basics by Nathan George is a comprehensive guide to mastering Excel for beginners. Here's why this book is worth reading:
- Explains Excel functions in a clear and concise manner, making complex concepts easy to grasp.
- Offers numerous hands-on exercises and examples for practical application, enhancing learning and retention.
- Provides tips and tricks for increasing efficiency and productivity, ensuring readers stay engaged and actively learning.
Who should read Excel 2019 Basics?
Individuals who want to learn the basics of Excel 2019
Beginners who are new to spreadsheets and data analysis
Professionals who need to improve their Excel skills for work
Categories with Excel 2019 Basics
Book summaries like Excel 2019 Basics
People ❤️ Blinkist
Sven O.
It's highly addictive to get core insights on personally relevant topics without repetition or triviality. Added to that the apps ability to suggest kindred interests opens up a foundation of knowledge.
Thi Viet Quynh N.
Great app. Good selection of book summaries you can read or listen to while commuting. Instead of scrolling through your social media news feed, this is a much better way to spend your spare time in my opinion.
Jonathan A.
Life changing. The concept of being able to grasp a book's main point in such a short time truly opens multiple opportunities to grow every area of your life at a faster rate.
Renee D.
Great app. Addicting. Perfect for wait times, morning coffee, evening before bed. Extremely well written, thorough, easy to use.
People also liked these summaries
4.8 Stars
Average ratings on iOS and Google Play
43 Million
Downloads on all platforms
10+ years
Experience igniting personal growth
Excel 2019 Basics FAQs
What is the main message of Excel 2019 Basics?
Master the fundamentals of Excel 2019 for efficient data analysis and management.
How long does it take to read Excel 2019 Basics?
Reading time for Excel 2019 Basics varies but expect a few hours. The Blinkist summary can be read in a few minutes.
Is Excel 2019 Basics a good book? Is it worth reading?
Excel 2019 Basics is recommended for beginners wanting to harness Excel's power efficiently.
Who is the author of Excel 2019 Basics?
The author of Excel 2019 Basics is Nathan George.
What to read after Excel 2019 Basics?
If you're wondering what to read next after Excel 2019 Basics, here are some recommendations we suggest:
- Big Data by Viktor Mayer-Schönberger and Kenneth Cukier
- Physics of the Future by Michio Kaku
- On Intelligence by Jeff Hawkins and Sandra Blakeslee
- Brave New War by John Robb
- Abundance# by Peter H. Diamandis and Steven Kotler
- The Signal and the Noise by Nate Silver
- You Are Not a Gadget by Jaron Lanier
- The Future of the Mind by Michio Kaku
- The Second Machine Age by Erik Brynjolfsson and Andrew McAfee
- Out of Control by Kevin Kelly