Excel 2019 Advanced Topics Leverage More Powerful Tools to Enhance Your Productivity by Nathan George

Excel 2019 Advanced Topics covers a selection of topics that will enable you to take advantage of more powerful features in Excel 2019 in creating quick and robust solutions for your data. My Excel 2019 Basics book covered the essentials of Excel and how to use Excel tools to create solutions for common Excel tasks. Excel 2019 Advanced Topics does not rehash the content of that book. Rather, it goes beyond the basics and covers intermediate to advanced topics. The aim of this book is to provide you with tools and techniques that enable you to solve data challenges that require more than just a basic knowledge of Excel.

With Excel 2019 Advanced Topics, you’ll learn how to use features that make Excel one of the best data processing and analysis tools in the market. The topics covered include, automating Excel tasks with macros, analysing alternate data sets and creating data projections with What-If Analysis,

analysing large data sets with pivot tables and pivot charts, solving complex problems with advanced functions, consolidating data from different worksheets, removing duplicate data, troubleshooting formula errors, and many more. Unlike many other books, this book does not only show you how to use specific features, but also in what context those features need to be used.

Excel 2019 Advanced Topics is for you if you want to go beyond the basics and become an Excel power user. In this book you’ll learn how to use some of the more powerful tools to address complex tasks and create quicker results. This is not an exhaustive guide on advanced Excel, but a selection of intermediate to advanced topics relevant to real world productivity tasks you’re likely to encounter at home or at work requiring more than a basic knowledge of Excel.

Excel 2019 Advanced Topics is aimed at readers with Microsoft Excel 2019, however, many of the core Excel features remain the same for earlier versions of the software like Excel 2016 and 2013. So, you would still find many of the lessons in this book relevant even if you have an earlier version of Excel. As much as possible, I point out the features new in Excel 2019 when covered. Note however that if you’re using an earlier version of Excel, some of the file related tasks described in this book may not match your old version of Excel. This is due to Microsoft changing command options and the screens for many file-related tasks compared to older versions.

This book can be used as a step-by-step training guide as well as a reference manual that you come back to from time to time. You can read it cover to cover or skip to certain parts that cover topics you want to learn. Although the chapters have been organised in a logical manner, the book has been designed to enable you to read a chapter as a standalone tutorial to learn how to carry out a certain task.

If you are using Excel 2019 on a Mac, then simply substitute any Windows keyboard commands mentioned in the book for the Mac equivalent. All the features within Excel remain the same for both platforms. If you’re using Excel on a tablet or touchscreen device, again, simply substitute any keyboard commands mentioned in the book with the equivalent on your touchscreen device.