Normal view MARC view ISBD view

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
Contents:
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.
Summary: Offers techniques, tricks and tips from twenty-two Excel experts.
List(s) this item appears in: Excel at Excel
Item type Home library Call number URL Status Notes Date due Barcode Item reserves
EBook EBook International
ProQuest eBook (Browse shelf) Link to resource eBook Available as an ebook here
Total reserves: 0

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.

© 2017 Chartered Accountants Australia and New Zealand ABN 50 084 642 571 (CA ANZ).
Formed in Australia. Members of CA ANZ are not liable for the debts and liabilities of CA ANZ

Powered by Koha

Powered by Koha