Applied Microsoft Excel 2016

Applied Microsoft Excel 2016 is a full-featured spreadsheet program that helps you quickly and efficiently develop dynamic, professional workbooks to summarize and present your data. This book offers a comprehensive look at the features of Excel that most people will use most frequently in a more practical sense. Chapters 1 – 2 address basic skills such as customizing the program window, setting up workbooks, managing data within workbooks, creating formulas to summarize your data and introduction to sorting and filtering. Chapters 3 – 7 looks at organizing and analyzing data in more depth through creating and using named ranges, using Excel functions, summarizing and managing data using Excel tables, applying the use of conditional formatting techniques for data visualization and using Excel - subtotals. Chapters 8 – 15 cover Excel array functions, 3D references, Excel charts & Shapes, Text functions, Date functions, managing comments, Excel Lookup & Reference functions, PivotTables and Pivot Charts. Chapters 16 – 20 cover Excel macros, managing workbook options and settings, Excel tricks to improve efficiency, using shortcuts & a summary table for all Excel built in functions.