Overview

"Inspiring Excel tips designed to save 100 hours per year. Originally designed for Bill Jelen's live Power Excel seminars, the target audience already uses Excel 40 hours a week. These tips are the ""aha"" tips that uncover secret methods in Excel. The book covers general Excel functions, pivot tables, and formulas such as VLOOKUPand the new XLOOKUP. It introduces elements of modern Excel such as the Power Pivot Data Model and cleaning data with Power Query. Updated annually, this edition for 2022 adds information on collaboration features, LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more."

Full Product Details

Author:   Bill Jelen
Publisher:   Holy Macro! Books
Imprint:   Holy Macro! Books
Edition:   Sixth edition
Dimensions:   Width: 20.90cm , Height: 1.50cm , Length: 27.30cm
Weight:   0.680kg
ISBN:  

9781615470778

ISBN 10:   1615470778
Pages:   298
Publication Date:   01 September 2022
Audience:   General/trade ,  General
Format:   Paperback
Publisher's Status:   Active
Availability:   In stock  
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Table of Contents

#1 Double-Click the Fill Handle to Copy a Formula#2 Break Apart Data#3 Filter by Selection#4 The Fill Handle Does Know 1, 2, 3…#5 Fast Worksheet Copy#6 Recover Unsaved Workbooks#7 Simultaneously Edit the Same Workbook in Office 365#8 New Threaded Comments Allow Conversations#9 Create Perfect One-Click Charts#10 Paste New Data on a Chart#11 Create Waterfall Charts#12 Creat a Bell Curve#13 Add Meaning to Reports Using Data Visualizations#14 Sort East, Central, and West Using a Custom List#15 Sort Left to Right#16 Sort Subtotals#17 Sort and Filter by Color or Icon#18 Consolidate Quarterly Worksheets#19 Get Ideas from Artificial Intelligence#20 Create Your First Pivot Table#21 Create a Year-over-Year Report in a Pivot Table#22 Find the True Top Five in a Pivot Table#23 Specify Defaults for All Future Pivot Tables#24 Replicate a Pivot Table for Each Rep#25 Use a Pivot Table to Compare Lists#26 Build Dashboards with Sparklines and Slicers#27 See Why GETPIVOTDATA Might Not Be Entirely Evil#28 Eliminate VLOOKUP with the Data Model#29 Compare Budget Versus Actual via Power Pivot#30 Slicers for Pivot Tables From Two Data Sets#31 Use F4 for Absolute Reference or Repeating Commands#32 Quickly Convert Formulas to Values#33 See All Formulas at Once#34 Discover New Functions by Using fx #35 Calculate Nonstandard Work Weeks#36 Turn Data Sideways with a Formula#37 Handle Multiple Conditions in IF#38 Troubleshoot VLOOKUP#39 Replace Nested IFs with a Lookup Table#40 Suppress Errors with IFERROR#41 Handle Plural Conditions with SUMIFS#42 Geography & Stock Data Types in Excel#43 Dynamic Arrays Can Spill#44 Sorting with a Formula#45 Formula for Unique or Distinct#46 Other Functions Can Now Accept Arrays as Arguments#47 One Hit Wonders with UNIQUE#48 SEQUENCE inside of other Functions such as IPMT#49 Replace a Pivot Table with 3 Dynamic Arrays#50 Complex Validation Using a Formula#51 Use A2:INDEX() as a Non-Volatile OFFSET#52 Subscribe to Office 365 for Monthly Features#53 Speed Up VLOOKUP#54 Protect All Formula Cells#55 Back into an Answer by Using Goal Seek#56 Do 60 What-If Analyses with a Sensitivity Analysis#57 Find Optimal Solutions with Solver#58 Improve Your Macro Recording#59 Clean Data with Power Query#60 Render Excel Data on an iPad Dashboard Using Power BI#61 Build a Pivot Table on a Map Using 3D Maps#62 The Forecast Sheet Can Handle Some Seasonality#63 Perform Sentiment Analysis in Excel#64 Fill in a Flash#65 Format as a Façade#66 Surveys & Forms in Excel#67 Use the Windows Magnifier#68 Word for Excellers#69 Avoid Whiplash with Speak Cells#70 Customize the Quick Access Toolbar#71 Favorite Keyboard Shortcuts#72 More Excel Tips

Reviews

Author Information

Bill Jelenis the host of www.MrExcel.com, a Microsoft MVP, and the author of 65 books about Excel. He lives in Merritt Island, Florida.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions