Who Is This Book For?

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.

This book assumes you have some basic knowledge of Excel. For brevity, this book does not cover the topics already covered in my Excel 2019 Basics book (unless absolutely necessary for the flow of the lesson). If you need to brush up on the basics (or if you’re new to Excel), then my Excel 2019 Basics book covers all the fundamentals you’ll need to use this book.

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.