Normal view MARC view ISBD view

MrExcel LIVe : the 54 greatest Excel tips of all time / by Bill Jelen

By: Jelen, Bill.
Publisher: Merritt Island, F.L. : Holy Macro! Books; 2018Description: 183 p. : ill.ISBN: 9781615470563.Subject(s): Excel | Spreadsheets | DataOnline resources: Download as an eBook
Contents:
THE TOP 54 TIPS:#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 Use default settings for all future workbooks -- #7 Recover unsaved workbooks -- #8 Create perfect one-click charts -- #9 Paste new data on a chart -- #10 New in Excel 2016: create waterfall charts and more -- #11 Add meaning to reports using data visualizations -- #12 Sort east, central, and west using a custom list -- #13 Sort left to right -- #14 Sort subtotals -- #15 Sort and filter by color or icon -- #16 Consolidate quarterly worksheets -- #17 Create a year-over-year report in a pivot table -- #18 Find the true top five in a pivot table -- #19 Specify defaults for all future pivot tables -- #20 Replicate a pivot report for each rep -- #21 Use a pivot table to compare lists -- #22 Build dashboards with sparklines and slicers -- #23 See why GETPIVOTDATA might not be entirely evil -- #24 Eliminate VLOOKUP with the data model -- #25 Compare budget versus actual via power pivot -- #26 Use F4 for absolute reference or repeating commands -- #27 Quickly convert formulas to values -- #28 See all formulas at once -- #29 Discover new functions by using fx -- #30 Calculate nonstandard work weeks -- #31 Turn data sideways with a formula -- #32 Handle multiple conditions in IF -- #33 Troubleshoot VLOOKUP -- #34 Replace nested ifs with a lookup table -- #35 Suppress errors with IFERROR -- #36 Handle plural conditions with SUMIFS -- #37 Cure triskaidekaphobia with a killer formula -- #38 Extract unique values with a CSE formula -- #39 Use A2:iNDEX() as a non-volatile OFFSET -- #40 Subscribe to office 365 for monthly features -- #41 Speed up VLOOKUP -- #42 Protect all formula cells -- #43 Back into an answer by using goal seek -- #44 Do 60 what-if analyses with a data table -- #45 Find optimal solutions with solver -- #46 Improve your macro recording -- #47 Clean data with power query -- #48 Render Excel data on an iPad dashboard using Power BI -- #49 Build a pivot table on a map using 3D maps -- #50 Perform sentiment analysis in Excel -- #51 Fill in a flash -- #52 Format as a facade -- #53 Word for Excellers -- #54 Avoid whiplash with speak cells -- #55 More Excel tips. 54 KEYBOARD SHORTCUTS -- EXCEL STORIES.
Summary: Offers concise tips and techniques to master Excel and solve common issues. Includes keyboard shortcuts and tips on Power Query and Power BI.
Item type Home library Call number URL Status Notes Date due Item reserves
Book Book Australia
276 JEL 2018 (Browse shelf) Issued 04/07/2018
EBook EBook International
EBL Ebook (Browse shelf) Link to resource eBook Available as an ebook here
Book Book New Zealand
276 MRE (Browse shelf) Issued 10/07/2018
Book Book New Zealand
276 MRE (Browse shelf) Issued 22/06/2018
Total holds: 12

THE TOP 54 TIPS:#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 Use default settings for all future workbooks -- #7 Recover unsaved workbooks -- #8 Create perfect one-click charts -- #9 Paste new data on a chart -- #10 New in Excel 2016: create waterfall charts and more -- #11 Add meaning to reports using data visualizations -- #12 Sort east, central, and west using a custom list -- #13 Sort left to right -- #14 Sort subtotals -- #15 Sort and filter by color or icon -- #16 Consolidate quarterly worksheets -- #17 Create a year-over-year report in a pivot table -- #18 Find the true top five in a pivot table -- #19 Specify defaults for all future pivot tables -- #20 Replicate a pivot report for each rep -- #21 Use a pivot table to compare lists -- #22 Build dashboards with sparklines and slicers -- #23 See why GETPIVOTDATA might not be entirely evil -- #24 Eliminate VLOOKUP with the data model -- #25 Compare budget versus actual via power pivot -- #26 Use F4 for absolute reference or repeating commands -- #27 Quickly convert formulas to values -- #28 See all formulas at once -- #29 Discover new functions by using fx -- #30 Calculate nonstandard work weeks -- #31 Turn data sideways with a formula -- #32 Handle multiple conditions in IF -- #33 Troubleshoot VLOOKUP -- #34 Replace nested ifs with a lookup table -- #35 Suppress errors with IFERROR -- #36 Handle plural conditions with SUMIFS -- #37 Cure triskaidekaphobia with a killer formula -- #38 Extract unique values with a CSE formula -- #39 Use A2:iNDEX() as a non-volatile OFFSET -- #40 Subscribe to office 365 for monthly features -- #41 Speed up VLOOKUP -- #42 Protect all formula cells -- #43 Back into an answer by using goal seek -- #44 Do 60 what-if analyses with a data table -- #45 Find optimal solutions with solver -- #46 Improve your macro recording -- #47 Clean data with power query -- #48 Render Excel data on an iPad dashboard using Power BI -- #49 Build a pivot table on a map using 3D maps -- #50 Perform sentiment analysis in Excel -- #51 Fill in a flash -- #52 Format as a facade -- #53 Word for Excellers -- #54 Avoid whiplash with speak cells -- #55 More Excel tips. 54 KEYBOARD SHORTCUTS -- EXCEL STORIES.

Offers concise tips and techniques to master Excel and solve common issues. Includes keyboard shortcuts and tips on Power Query and Power BI.

© 2017 Chartered Accountants Australia and New Zealand ABN 50 084 642 571 (CA ANZ).
Formed in Australia. Members of CA ANZ are not liable for the debts and liabilities of CA ANZ

Powered by Koha

Powered by Koha