Power Excel with MrExcel - 2017 Edition: Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis

Front Cover
Tickling Keys, Inc., Oct 1, 2016 - Computers - 529 pages
0 Reviews
Reviews aren't verified, but Google checks for and removes fake content when it's identified
Updating the previous edition's tips to include features in Excel 2016, this new edition of MrExcel's popular software guide even incorporates suggestions sent in by readers. Each featured topic has a problem statement and description, followed by a broad strategy for solving the problem. MrExcel then walks readers through the specific steps to solve the issue. Alternate strategies are also provided, along with common scenarios that trip users up, leaving readers with not only answers to their specific dilemmas but also new and quicker ways to use formulas and spreadsheets.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Selected pages

Contents

Common terms and phrases

Additional Details Alternate Strategy arrow keys AutoComplete automatically AutoSum axis blank cell bottom button calculate cell pointer chart Click OK color column widths command convert copy the formula create Ctrl+C data set default Delete Design tab dialog box display dollar signs Double­click drag drop zone dropdown and choose Edit entry Excel Field List Figure fill handle Filter Flash Fill Follow these steps font formula bar function Gotcha Here’s Home tab hyperlink icon Insert keyboard shortcuts labels lookup table macro menu Microsoft month mouse move Options pivot chart pivot table Power Pivot Power Query press Enter Print Problem Quick Access toolbar range result Revenue ribbon tab Right­click Select cell shape shortcut slicers SmartArt sort sparklines spreadsheet style subtotals Tools ToolTip values VLOOKUP waterfall chart WordArt workbook worksheet zero

About the author (2016)

Bill Jelen is the host of www.MrExcel.com, Microsoft MVP, and writes the monthly Excel column for Strategic Finance Magazine. He is the author of 49 books about Excel.

Bibliographic information

QR code for Power Excel with MrExcel - 2017 Edition
TitlePower Excel with MrExcel - 2017 Edition: Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis
AuthorBill Jelen
PublisherTickling Keys, Inc., 2016
ISBN1615473556, 9781615473557
Length529 pages
Subjects ›  › 

Computers / Business & Productivity Software / Spreadsheets
Computers / Data Science / Data Analytics
  
Export CitationBiBTeX EndNote RefMan