Intro -- Smart Uses of Custom Number Formatting -- Ctrl + Enter -- Auto-Magically Master INDEX MATCH (and Other Formulas) -- Relative Named Ranges -- When Named Ranges Go Walkabout -- An Introduction to Excel's New Data Types -- A Look to the Future -- Dynamic Arrays -- XLOOKUP Debuts in Excel -- Why the Love / Hate for Pie Charts? -- Intermediate Charting in Excel -- Creating Charts for Presentations -- Advanced Filter -- Power Query: Manipulate Your Data Like a Pro -- Combine All Files in a Folder -- Power Query M Code Approximate Match Lookup Formula
The Power Behind the Boringest Sentence in Excel -- Understanding Context in Power Pivot -- Thinking Through the Modelling of a Seating Chart -- Financial Modelling -- Creative Excel Model Development -- An Introduction to Simulation in Excel -- Staying out of Trouble -- Make Your Own VBA Worksheet Functions -- An Overview of Modern VBA Best Practices -- About the MVPs -- Index
Local Note
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America