<p style="margin:0px;">Part I THE EXCEL INTERFACE</p> <p style="margin:0px;">1    What’s New in Excel 2019 and Office 365</p> <p style="margin:0px;">2    Using the Excel Interface</p> <p style="margin:0px;">3    Customizing Excel</p> <p style="margin:0px;">4    Keyboard Shortcuts</p> <p style="margin:0px;"> </p> <p style="margin:0px;">Part II CALCULATING WITH EXCEL</p> <p style="margin:0px;">5    Understanding Formulas</p> <p style="margin:0px;">6    Controlling Formulas</p> <p style="margin:0px;">7    Understanding Functions</p> <p style="margin:0px;">8    Using Everyday Functions: Math, Date and Time, and Text Functions</p> <p style="margin:0px;">9    Using Powerful Functions: Logical, Lookup, Web, and Database Functions</p> <p style="margin:0px;">10  Other Functions</p> <p style="margin:0px;">11  Connecting Worksheets and Workbooks</p> <p style="margin:0px;">12  Array Formulas and Names in Excel</p> <p style="margin:0px;"><br></p> <p style="margin:0px;">Part III DATA ANALYSIS WITH EXCEL</p> <p style="margin:0px;">13  Transforming Data with Power Query</p> <p style="margin:0px;">14  Summarizing Data Using Subtotals or Filter</p> <p style="margin:0px;">15  Using Pivot Tables to Analyze Data</p> <p style="margin:0px;">16  Using Slicers and Filtering a Pivot Table</p> <p style="margin:0px;">17  Mashing Up Data with Power Pivot</p> <p style="margin:0px;">18  Using What-If, Scenario Manager, Goal Seek, and Solver</p> <p style="margin:0px;">19  Automating Repetitive Functions Using VBA Macros</p> <p style="margin:0px;">20  More Tips and Tricks for Excel 2016</p> <p style="margin:0px;"> </p> <p style="margin:0px;">Part IV EXCEL VISUALS</p> <p style="margin:0px;">21  Formatting Worksheets</p> <p style="margin:0px;">22  Using Data Visualizations and Conditional Formatting</p> <p style="margin:0px;">23  Graphing Data Using Excel Charts</p> <p style="margin:0px;">24  Using 3D Maps</p> <p style="margin:0px;">25  Using Sparklines</p> <p style="margin:0px;">26  Formatting Spreadsheets for Presentation</p> <p style="margin:0px;">27  Printing</p> <p style="margin:0px;">28  Excel Online</p> <p style="margin:0px;"> </p> <p style="margin:0px;">APPENDIXES</p> <p style="margin:0px;">A    DAX Functions</p> <p style="margin:0px;">B    Power Query M Functions</p> <p style="margin:0px;"> </p>