excelisfun | Poke

Import Worksheet of Data From External Excel File into Current Excel File

Increase Excel Row Height for Multiple Columns

Opposite of TEXTJOIN? It's TEXTSPLIT used to Split Sub-text from Text String. Excel Short 76 Part 3

Array of Delimiters in TEXTJOIN for the Perfect Join! Excel Magic Trick Short # 76 part 02

Turn Off GETPIVOTDATA Function So I Can Refer To My PivotTable With A Cell Reference. Excel Short 77

Excel TEXTJOIN Function Trick to Join Text from 2 Columns into 1 Cell! Excel Short Magic Trick 76

Mind-Blowing: GROUPBY Function Beats PivotTable, Hands-down. Beats COUNTIFS Too! Excel Short # 75

Add Slicer to PivotTable & Chart To Enable Quick Analysis Excel Short Magic Trick 74

Fast Keyboard to Create Excel PivotTable Excel Short Magic Trick 73

Why Excel Table Feature is Amazing & How To Create Them: Excel #Short Magic Trick 72

Remove Duplicates From Excel Data Validation Drop Down List!?!? Short Excel # 71

Excel History: From Bricklin & Frankston to Joe McDaid & the New Excel Frontier. Short Excel # 70

Increase All Numbers by a Multiple of 10: Excel Paste Special Multiply Magic!! Short Excel Trick 69

Data Set Random Sales Numbers: RANDBETWEEN or NORM.INV Function? Excel Short 68

LET Function to Define LAMBDA as f, then Perform Column Iteration With Vertical Spill. #Short 67

LET & BYCOL Functions to Spill Column Aggregate calculations Vertically. #Short 66

Spill Aggregate Totals with the AGGREAGATE Function. #Short 65

Spill Aggregate Totals with BYCOL Function (GEOMEAN too), Across Bottom of Table! #Short 64

AI Doesn't Know This: Best Solution for Excel Table Running Count Error! #Short Excel Trick 63

Excel's WRAPCOLS Array Function to Undo Table Into a Specified # of Columns. #Short Excel Trick #62

No More VBA! Amazing WRAPROWS Function Converts Column of Records to Table. #Short Excel Trick 61

Best Formula for % Change (Daily Stock Returns). #Short Excel Trick 60

Stock Portfolio Expected Return & Beta with single cell array formula. Bonus Trick Too! #Short 59

Expected Return & Standard Deviation 4 Portfolio of Stocks Single Cell Excel Array Formula #Short 58

Expected Return & Standard Deviation for 2 Stocks: Single Cell Excel Spilled Array Formula #Short 57

Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56

Excel's Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55

Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54. ACCTG 455 #68.4

Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53. ACCTG 455 #68.3

Net Present Value: Do We Buy Asset? PV or NPV Function? #Short 52. ACCTG 455 #68.2

Build Text Formula for Dynamic Label For Financial Model. #Short 51. ACCTG 455 #68.1

Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50. ACCTG 455 #63.2

Visualize How Stock Values Changes as Dividend Growth Rate Changes. #Short 49. ACCTG 455 #63.1

Bond Rate Risk: Lower Coupon Rate, The More YTM Affects Bond Price. #Short 48. ACCTG 455 #54.2

Excelisfun Needs Your Help in Solving A Formula Number Formatting Mystery. #Short 52 Part 02

Bond Rate Risk: Longer Maturity, More YTM Affects Bond Price. #Short 47. ACCTG 455 #54.1

Visualize Inverse Relationship for Bond Price & YTM Rate. #Short Excel Trick 46. ACCTG 455 50.4

Spill Bond Valuation PV Function Formula Across YTM Rates. #Short Excel Trick 45. ACCTG 455 #50.3

IFS Function for Bond Value "Par", "Discount", or "Premium". #Short Excel Trick 44. ACCTG 455 # 50.2

Conditional Formatting for Bond Sold at Discount or Premium. #Short Excel Trick 43. ACCTG 455 # 50.1

Deep Discount Loan Spilled Amortization Table (Treasury Bonds) . #Short Excel Trick 42. ACCTG 455.

Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41. ACCTG 455.

Excel Spilled Loan Amortization Table. #Short Excel Trick 40. ACCTG 455.

What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39

CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38

Excel Formulas: Arrow Keys or Mouse? Return on Assets & Return on Equity Show the Best! #Short ET 37

I Can’t See All of My Excel Worksheet Tabs!?!?! #Short Excel Trick 36

Subtle Excel Keyboard Awesomeness: Ctrl + Shift + Arrow, then, Shift + Arrow #Short Excel Trick 35