Essential Excel 2019: A Step-By-Step Guide

✍ Scribed by David Slager, Annette Slager

• Publisher: Apress
• Year: 2020
• Tongue: English
• Leaves: 924
• Edition: 2nd ed.
• Category: Library

✦ Synopsis

Create, edit, sort, analyze, summarize, and format data as well as graph it in Excel 2019. Chock full of visuals, user-friendly instructions, and reader exercises, this in-depth guide makes it easy for you to get on the bandwagon taking advantage of this powerful software and what it can do. Essential Excel 2019 doesn’t mess around. It provides the most clear and concise, but complete, information you need to successfully use the expansive features of Excel in your work environment.

The second edition of this soup-to-nuts book delivers essential how-to and reference information for users who are new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to speed on the latest changes and features in Excel 2019. It is heavy on the practical examples and light on the theory, providing a step-by-step process of what you need to do when you are working with Excel. You will begin with the basics, advancing as each chapter builds on knowledge from previous chapters. You will appreciate real-life examples and exercises that reinforce what you have learned, and upon finishing the book, you will have the confidence to use much more than the typical 10% that most people use in Excel.

What You Will Learn

• Create amazing visualizations of your data
• Get up to speed on easy and accurate methods for entering data
• Extract the information you want from imported data; manipulate and format it to meet your needs
• Export your results to other programs or share with others in the cloud
• Organize, summarize, filter, and consolidate your data in multiple ways
• Audit, validate, and protect your data

Who This Book Is For
Anyone new to Excel or looking to take better advantage of the advanced features of the platform

✦ Table of Contents

Front Matter ....Pages i-xxiv
Becoming Acquainted with Excel (David Slager, Annette Slager)....Pages 1-39
Navigating and Working with Worksheets (David Slager, Annette Slager)....Pages 41-73
Best Ways to Enter and Edit Data (David Slager, Annette Slager)....Pages 75-129
Formatting and Aligning Data (David Slager, Annette Slager)....Pages 131-196
Different Ways of Viewing and Printing Your Workbook (David Slager, Annette Slager)....Pages 197-232
Understanding Backstage (David Slager, Annette Slager)....Pages 233-288
Creating and Using Formulas (David Slager, Annette Slager)....Pages 289-345
Excel’s Pre-existing Functions (David Slager, Annette Slager)....Pages 347-411
Auditing, Validating, and Protecting Your Data (David Slager, Annette Slager)....Pages 413-459
Using Hyperlinks, Combining Text, and Working with the Status Bar (David Slager, Annette Slager)....Pages 461-495
Transferring and Duplicating Data to Other Locations (David Slager, Annette Slager)....Pages 497-542
Working with Tables (David Slager, Annette Slager)....Pages 543-582
Working with Charts (David Slager, Annette Slager)....Pages 583-664
Importing Data (David Slager, Annette Slager)....Pages 665-706
Using PivotTables and PivotCharts (David Slager, Annette Slager)....Pages 707-763
Geography and Stock Data Types (David Slager, Annette Slager)....Pages 765-798
Enhancing Workbooks with Multimedia (David Slager, Annette Slager)....Pages 799-850
Icons, 3D Images, and Object Grouping (David Slager, Annette Slager)....Pages 851-873
Automating Tasks with Macros (David Slager, Annette Slager)....Pages 875-901
Back Matter ....Pages 903-914

✦ Subjects

Computer Science; Microsoft and .NET; Professional Computing; Statistics, general; Computer Applications