Excel insights : a Microsoft MVP guide to the best parts of Excel / by 24 Excel MVPs (Most Valuable Professionals)
By: 24 Excel MVPs.Publisher: Merritt Island, F.L. : Holy Macro! Books, 2020Description: 286 p. : ill. ; electronic resource.ISBN: 9781615470679.Subject(s): Excel | Data | SpreadsheetsOnline resources: Download as an eBook
|Item type||Home library||Call number||URL||Status||Notes||Date due||Barcode||Item reserves|
|EBook||International||ProQuest eBook (Browse shelf)||Link to resource||eBook||Available as an ebook here|
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.
Offers techniques, tricks and tips from twenty-two Excel experts.