Skip to content
You are not logged in |Login  
Limit search to available items
Record:   Prev Next
More Information

Title Excel insights : a Microsoft MVP guide to the best parts of Excel.

Publication Info. Merritt Island, FL : Holy Macro! Books, 2020.

Item Status

Description 1 online resource
Contents 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
Subject Microsoft Excel (Computer file)
Microsoft Excel (Computer file)
Business -- Computer programs.
Business intelligence -- Computer programs.
Knowledge management -- Computer programs.
Business -- Data processing.
Business -- Computer programs.
Business -- Data processing.
Genre/Form Electronic books.
Other Form: Print version: Excel insights. Merritt Island, FL : Holy Macro! Books, 2020 1615470670 9781615470679 (OCoLC)1120692496
ISBN 9781615471539 (electronic bk.)
1615471537 (electronic bk.)