Normal view MARC view ISBD view

MrExcel LX the holy grail of Excel tips : covers Excel backwards and forwards / by Bill Jelen

By: Jelen, Bill.
Publisher: Merrit Island, F.L. : Holy Macro! Books, 2019Description: 476 p. : ill ; electronic resource.ISBN: 9781615470631.Subject(s): Excel | Spreadsheets | DataOnline resources: Download as an eBook
Contents:
Double-click the fill handle to copy a formula -- Break apart data -- Filter by selection -- Bonus tip - total the visible rows -- The fill handle does know 1, 2, 3... -- Fast worksheet copy -- Use default settings for all future workbooks -- Recover unsaved workbooks -- Simultaneously edit the same workbook in Office 365 -- New threaded comments allow conversations -- Create perfect one-click charts -- Paste new data on a chart -- Create interactive charts -- Show two different orders of magnitude on a chart -- Create waterfall charts -- Create funnel charts in Office 365 -- Create filled map charts in Office 365 -- Create a bell curve -- Plotting employees on a bell curve -- Add meaning to reports using data visualizations -- Sort east, central, and west using a custom list -- Sort left to right -- Sort subtotals -- Sort and filter by color or icon -- Consolidate quarterly worksheets -- Get ideas from artificial intelligence -- Create your first pivot table -- Create a year-over-year report in a pivot table -- Change the calculation in a pivot table -- Find the true top five in a pivot table -- Specify defaults for all future pivot tables -- Make pivot tables expandable using Ctrl + T -- Replicate a pivot table for each rep -- Use a pivot table to compare lists -- Build dashboards with sparklines and slicers -- See why GETPIVOTDATA might not be entirely evil -- Eliminate VLOOKUP with the data model -- Compare budget versus actual via power pivot -- Slicers for pivot tables from two data sets -- Use F4 for absolute reference or repeating commands -- Quickly convert formulas to values -- See all formulas at once -- Audit a worksheet with spreadsheet inquire -- Discover new functions by using fx -- Use function arguments for nested functions -- Calculate nonstandard work weeks -- Turn data sideways with a formula -- Handle multiple conditions in IF -- Troubleshoot VLOOKUP -- Use a wildcard in VLOOKUP -- Replace columns of VLOOKUP with a single MATCH -- Use the fuzzy lookup tool from Microsoft Labs -- Lookup to the left with INDEX/MATCH -- Preview what remove duplicates will remove -- Replace nested IFs with a lookup table -- Suppress errors with IFERROR -- Handle plural conditions with SUMIFS -- Geography & stock data types in Excel -- Dynamic arrays can spill -- Sorting with a formula -- Filter with a formula -- Formula for unique or distinct -- Other functions can now accept arrays as arguments -- One hit wonders with UNIQUE -- SEQUENCE inside of other functions such as IPMT -- Replace a pivot table with 3 dynamic arrays -- Dependent validation using dynamic arrays -- Complex validation using a formula -- Use A2:INDEX() as a non-volatile OFFSET -- Subscribe to Office 365 for monthly features -- Less CSV nagging and better AutoComplete -- Speed up VLOOKUP -- Protect all formula cells -- Back into an answer by using goal seek -- Do 60 what-if analyses with a sensitivity analysis -- Find optimal solutions with solver -- Improve your macro recording -- Clean data with Power Query -- Render Excel data on an iPad dashboard using Power BI -- Build a pivot table on a map using 3D maps -- The forecast sheet can handle some seasonality -- Perform sentiment analysis in Excel -- Fill in a flash -- Format as a facade -- Word cloud using custom visuals in Excel -- Surveys & forms in Excel -- Use the Windows magnifier -- Avoid whiplash with speak cells -- Customize the quick access toolbar -- Create your own QAT routines using VBA macros -- Favorite keyboard shortcuts -- Ctrl + click to unselect cells -- More excel tips.
Summary: Offers 125 essential Excel tips that will save users hours of work. Includes keyboard shortcuts.
Item type Home library Call number URL Status Notes Date due Barcode Item reserves
EBook EBook International
ProQuest eBook (Browse shelf) Link to resource eBook Available as an ebook here
Total reserves: 0

Double-click the fill handle to copy a formula -- Break apart data -- Filter by selection -- Bonus tip - total the visible rows -- The fill handle does know 1, 2, 3... -- Fast worksheet copy -- Use default settings for all future workbooks -- Recover unsaved workbooks -- Simultaneously edit the same workbook in Office 365 -- New threaded comments allow conversations -- Create perfect one-click charts -- Paste new data on a chart -- Create interactive charts -- Show two different orders of magnitude on a chart -- Create waterfall charts -- Create funnel charts in Office 365 -- Create filled map charts in Office 365 -- Create a bell curve -- Plotting employees on a bell curve -- Add meaning to reports using data visualizations -- Sort east, central, and west using a custom list -- Sort left to right -- Sort subtotals -- Sort and filter by color or icon -- Consolidate quarterly worksheets -- Get ideas from artificial intelligence -- Create your first pivot table -- Create a year-over-year report in a pivot table -- Change the calculation in a pivot table -- Find the true top five in a pivot table -- Specify defaults for all future pivot tables -- Make pivot tables expandable using Ctrl + T -- Replicate a pivot table for each rep -- Use a pivot table to compare lists -- Build dashboards with sparklines and slicers -- See why GETPIVOTDATA might not be entirely evil -- Eliminate VLOOKUP with the data model -- Compare budget versus actual via power pivot -- Slicers for pivot tables from two data sets -- Use F4 for absolute reference or repeating commands -- Quickly convert formulas to values -- See all formulas at once -- Audit a worksheet with spreadsheet inquire -- Discover new functions by using fx -- Use function arguments for nested functions -- Calculate nonstandard work weeks -- Turn data sideways with a formula -- Handle multiple conditions in IF -- Troubleshoot VLOOKUP -- Use a wildcard in VLOOKUP -- Replace columns of VLOOKUP with a single MATCH -- Use the fuzzy lookup tool from Microsoft Labs -- Lookup to the left with INDEX/MATCH -- Preview what remove duplicates will remove -- Replace nested IFs with a lookup table -- Suppress errors with IFERROR -- Handle plural conditions with SUMIFS -- Geography & stock data types in Excel -- Dynamic arrays can spill -- Sorting with a formula -- Filter with a formula -- Formula for unique or distinct -- Other functions can now accept arrays as arguments -- One hit wonders with UNIQUE -- SEQUENCE inside of other functions such as IPMT -- Replace a pivot table with 3 dynamic arrays -- Dependent validation using dynamic arrays -- Complex validation using a formula -- Use A2:INDEX() as a non-volatile OFFSET -- Subscribe to Office 365 for monthly features -- Less CSV nagging and better AutoComplete -- Speed up VLOOKUP -- Protect all formula cells -- Back into an answer by using goal seek -- Do 60 what-if analyses with a sensitivity analysis -- Find optimal solutions with solver -- Improve your macro recording -- Clean data with Power Query -- Render Excel data on an iPad dashboard using Power BI -- Build a pivot table on a map using 3D maps -- The forecast sheet can handle some seasonality -- Perform sentiment analysis in Excel -- Fill in a flash -- Format as a facade -- Word cloud using custom visuals in Excel -- Surveys & forms in Excel -- Use the Windows magnifier -- Avoid whiplash with speak cells -- Customize the quick access toolbar -- Create your own QAT routines using VBA macros -- Favorite keyboard shortcuts -- Ctrl + click to unselect cells -- More excel tips.

Offers 125 essential Excel tips that will save users hours of work. Includes keyboard shortcuts.

© 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