Microsoft Excel 2019 Inside Out

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. He loves performing his live Power Excel seminars around the United States. He has produced more than 2,200 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 57 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches, working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company.

• Part I THE EXCEL INTERFACE1    What’s New in Excel 2019 and Office 3652    Using the Excel Interface3    Customizing Excel4    Keyboard Shortcuts  Part II CALCULATING WITH EXCEL5    Understanding Formulas6    Controlling Formulas7    Understanding Functions8    Using Everyday Functions: Math, Date and Time, and Text Functions9    Using Powerful Functions: Logical, Lookup, Web, and Database Functions10  Other Functions11  Connecting Worksheets and Workbooks12  Array Formulas and Names in Excel Part III DATA ANALYSIS WITH EXCEL13  Transforming Data with Power Query14  Summarizing Data Using Subtotals or Filter15  Using Pivot Tables to Analyze Data16  Using Slicers and Filtering a Pivot Table17  Mashing Up Data with Power Pivot18  Using What-If, Scenario Manager, Goal Seek, and Solver19  Automating Repetitive Functions Using VBA Macros20  More Tips and Tricks for Excel 2016  Part IV EXCEL VISUALS21  Formatting Worksheets22  Using Data Visualizations and Conditional Formatting23  Graphing Data Using Excel Charts24  Using 3D Maps25  Using Sparklines26  Formatting Spreadsheets for Presentation27  Printing28  Excel Online  APPENDIXESA    DAX FunctionsB    Power Query M Functions