Power Excel with MrExcel - 2017 Edition: Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis
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.
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 Doubleclick 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 Rightclick Select cell shape shortcut slicers SmartArt sort sparklines spreadsheet style subtotals Tools ToolTip values VLOOKUP waterfall chart WordArt workbook worksheet zero