Catalog

Record Details

Catalog Search


Back To Results
Showing Item 10 of 28

Excel insights : a Microsoft MVP guide to the best parts of Excel. Cover Image Book Book

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

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.

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
Subject: Microsoft Excel (Computer file)
Business > Computer programs.
Business intelligence > Computer programs.
Knowledge management > Computer programs.
Business > Data processing.
Microsoft Excel (Computer file)
Business > Computer programs.
Business > Data processing.

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 -

Back To Results
Showing Item 10 of 28

Additional Resources