Catalog

Record Details

Catalog Search

Search Results filters

Filtered by:
Publication Year
After 2019 ×

Back To Results
Showing Item 41 of 75

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

Record details

  • ISBN: 1615470670
  • ISBN: 9781615470679
  • Physical Description: print
    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
Summary, etc.: 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.
Subject: Microsoft Excel (Computer file) Microsoft Excel (Computer file)
Business Computer programs
Business intelligence Computer programs
Knowledge management Computer programs
Business Data processing
Microsoft Excel (Computer file) 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.

Location Call Number / Copy Notes Barcode Shelving Location Status Due Date
APLS 005.54 EXC 31291002933826 MODEL LIBRARY Available -

Back To Results
Showing Item 41 of 75

Additional Resources