Excel insights : a Microsoft MVP guide to the best parts of Excel
This is not like a normal book used to learn Excel. This book is a selection of self-contained articles covering hot topics such as rich data types, collaboration, dynamic arrays and other brand new functions, as well as charting tricks, data analysis/PivotTables, financial modeling, number formatting, Power Pivot, Power Query and VBA tips.
Record details
- ISBN: 1615470670
- ISBN: 9781615470679
- Physical Description: 286 pages : illustrations ; 27 cm
- Publisher: Merritt Island, FL : Holy Macro! Books, 2020.
Content descriptions
General Note: | Includes index. |
Formatted Contents Note: | 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 |
Search for related items by subject
Available copies
- 1 of 1 copy available at State Library of Alabama.
Holds
- 0 current holds with 1 total copy.
Show Only Available Copies
Location | Call Number / Copy Notes | Barcode | Shelving Location | Status | Due Date |
---|---|---|---|---|---|
APLS | 005.54 EXC | 31291002933826 | Stacks | Available | - |
Summary:
This is not like a normal book used to learn Excel. This book is a selection of self-contained articles covering hot topics such as rich data types, collaboration, dynamic arrays and other brand new functions, as well as charting tricks, data analysis/PivotTables, financial modeling, number formatting, Power Pivot, Power Query and VBA tips.