- ホーム
- > 洋書
- > 英文書
- > Computer / Spreadsheets
Full Description
Excel tips to skyrocket white-collar productivity.
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 VLOOKUP and 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 2021 adds information on LET and LAMBDA functions, amazing new data types, dynamic array formulas, and more.
Contents
1 - Fast Formula Copy2 - Break Apart Data3 - Convert text #'s4 - Filter by Selection5 - Total Visible Rows6 - The Fill Handle 1, 2, 3... 7 - Fast Worksheet Copy8 - Defaults Future WB9 - Recover Unsaved Workbooks10 - Search in File, Open11 - Show Changes 60 Days12 - Collab13 - Sheet View14 - Threaded Comments 15 - Perfect 1-Click Charts16 - Paste New Data on a Chart17 - Create Interactive Charts18 - Chart 2 Orders of Magnitude19 - Waterfall Charts20 - Funnel Charts21 - Map Charts22 - Bell Curve23 - Plot People on a Bell Curve24 - Data Visualizations25 - Cutout People26 - Semi-Transparent Image27 - Save any object as image28 - List Format29 - Sort Using a Custom List30 - Sort Left to Right31 - Sort Subtotals32 - Sort & Filter by Color / Icon33 - Consolidate Qtr Worksheets34 - Create Your First Pivot Table35 - PT Year-over-Year36 - Change PT Calculation37 - True Top 5 in a PT38 - Defaults for All Future PT39 - PT Expandable Using Ctrl+T40 - Replicate a PT for Each Rep41 - Use a PT to Compare Lists42 - Sparklines and Slicers43 - GETPIVOTDATA use44 - Ask a Question45 - Data Model to Eliminate XLOOKUP46 - Budg v. Act'l via Power Pivot47 - PT Slicers from 2 Data Sets48 - F4 for $A$1 or Repeat49 - Formulas to Values50 - See All Formulas51 - Audit With Inquire52 - New Fx by Using fx 53 - Fx Args Nested Fx54 - Nonstandard Work Weeks55 - Sideways with a Formula56 - Multiple Conditions IF57 - Troubleshoot VLOOKUP58 - Wildcard in Lookup59 - 12 Benefits of XLOOKUP60 - Preview Remove Duplicates61 - Nested IFs v. Lookup62 - Suppress Errors with IFERROR63 - Plural Conditions w/ SUMIFS64 - Geo, XE & Stock Data Types 65 - STOCKHISTORY66 - Wolfram Alpha67 - Historical Weather for City68 - Create Data Types using PQ69 - Which language in Bilingual70 - Dynamic Arrays Can Spill71 - Sorting with a Formula72 - Filter with a Formula73 - Formula for Unique or Distinct74 - Fx Can Accept Arrays75 - 1 Hit Wonders with UNIQUE76 - SEQUENCE inside IPMT77 - Random #'s in Excel78 - PT with 3 DA79 - Dependent Validation DA80 - Complex Validation Formula81 - Stack Arrays82 - Drop, Take, Choose from Array83 - Reshaping Arrays84 - UNIQUE of Rectangular Range85 - Shuffle & Deal Cards86 - A2:INDEX() non-Volatile OFFSET87 - Microsoft 365 features88 - Perf Improvements89 - Unhide Multiple Worksheets90 - Action Pen91 - Take Panes Collapse92 - Feedback to the Excel Team93 - Date Tricks94 - LET95 - LAMBDA96 - Lamda helper functions97 - MAXIFS98 - TEXTBEFORE or AFTER99 - TEXTSPLIT100 - Less CSV Nagging+Autocomplete101 - Protect All Formula Cells102 - Goal Seek103 - Do 60 What-If Analyses104 - Solver105 - Interpolate106 - Improve Macro Recording107 - Clean Data Power Query108 - Fuzzy Match in PQ109 - PT on a Map 3D Maps110 - Forecast Seasonality111 - Sentiment Analysis112 - Visio Flowcharts113 - Fill in a Flash114 - Format as a Faç ade115 - Taskbar all open workbooks116 - Paste to Other Computer117 - Surveys & Forms in Excel118 - Windows Magnifier119 - Scrolling Tricks120 - Word for Excellers121 - Speak Cells122 - Customize QAT123 - QAT VBA Macros124 - Fav Keyb Shortcuts125 - Ctrl+Click to Unselect126 - Collapse the Search Box127 - More Excel Tips128 - Excel Stories129 - Quick Fx Reference
