Beyond the Basics: A Quick Guide to the Most Useful Excel Data Analysis Tools for the Business Analyst

Beyond the Basics: A Quick Guide to the Most Useful Excel Data Analysis Tools for the Business Analyst is a concise guide for the most often used functions and tools that Excel has to offer, geared towards readers interested in data analysis. This guide is designed to go beyond an entry-level understanding of Excel for those that have worked with it before but may not be familiar with the most useful functions or tools in Excel’s arsenal, all in an effort to get an analyst’s job done faster. Each chapter covers either a function or formula and some of the built-in tools in Excel. Functions are broken down to their most basic elements. This book’s format and content are designed for you to quickly look up a function and its uses and apply it to your specific data sets for analysis. This text is designed to be your gateway into more complex uses of the functions and tools in Excel, depending on your specific business needs. If you are working as a data analyst, you may not need to go beyond what is presented within this book. The Excel elements covered in this book are: DCOUNTA, IF, VLOOKUP, INDEX&MATCH, SUMIFS, SUMPRODUCT, Conditional Formatting, Pivot Tables, MACROS, Charts, Importing External Files into Excel. Beyond the Basics will provide you with a great reference that will hone and expand your knowledge of the world’s most prominent data analysis tool.