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
Table of Contents
Chapter 1 – Becoming Acquainted with Excel
Chapter 2 – Navigating and Working with Worksheets
Chapter 3 – Best Ways to Enter Data and Edit Data
Chapter 4: Formatting and Aligning Data
Chapter 5: Different Ways of Viewing and Printing Your Workbook
Chapter 6: Understanding Backstage
Chapter 7: Creating and Using Formulas
Chapter 8: Excel’s Pre-existing Functions
Chapter 9: Auditing, Validating, and Protecting Your Data
Chapter 10: Using Hyperlinks, Combining Text, and Working with the
Status Bar
Chapter 11: Transferring and Duplicating Data to Other Locations
Chapter 12: Working with Tables
Chapter 13: Working with Charts
Chapter 14: Importing Data
Chapter 15: Using PivotTables and PivotCharts
Chapter 16: Geography and Stock Data Types
Chapter 17: Enhancing Workbooks with Multimedia
Chapter 18: Icons, 3D Images and Object Grouping
Chapter 19: Automating Tasks with Macros
