Excel MVP Blog Roundup

By
Published 10-23-2020 03:10 PM 1,964 Views
Microsoft

This week's blog roundup brought to you by Excel MVPs Chandoo and Jeff Lenning.

 

ChandooChandooJeff LenningJeff Lenning

 

6 Must Know Line Chart variations for Data Analysis, Chandoo

6 line chart variations that every business analyst and data person should know - including indexed charts, spaghetti charts, forecasting and more.

 

Treasure Maps 1, Jeff Lenning

This is the first post in the Treasure Maps series, where we discover the treasure of efficiency with mapping tables. This series covers three ways to implement a mapping table: SUMIFS, Power Query, and Power Pivot.

 

Click the Like hand and/or leave a comment below

 

1 Comment
Occasional Visitor

I have set up an Excel spread sheet on a simple loan calculator.  Problem is I need a spread sheet for a Monthly Loan Balance Calculator for Uneven mortgage payments.  I don't know how to adjust the principal and interest and ending balance on my spread sheet.  Can someone help?  Maggie Colburn

%3CLINGO-SUB%20id%3D%22lingo-sub-1814062%22%20slang%3D%22en-US%22%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1814062%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20week's%20blog%20roundup%20brought%20to%20you%20by%20Excel%20MVPs%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F4024544%3FfullName%3DPurnachandra%2520R%2520Duggirala%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EChandoo%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fmvp.microsoft.com%2Fen-us%2FPublicProfile%2F5003752%3FfullName%3DJeff%2520Lenning%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EJeff%20Lenning%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22chandoo.jpg%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228942iA68AC2D793F0C823%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20role%3D%22button%22%20title%3D%22chandoo.jpg%22%20alt%3D%22Chandoo%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EChandoo%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jeff.jpg%22%20style%3D%22width%3A%20200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228943i7BBA66CE312DA11B%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20role%3D%22button%22%20title%3D%22jeff.jpg%22%20alt%3D%22Jeff%20Lenning%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EJeff%20Lenning%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fchandoo.org%2Fwp%2Fline-chart-variations%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSTRONG%3E6%20Must%20Know%20Line%20Chart%20variations%20for%20Data%20Analysis%3C%2FSTRONG%3E%3C%2FA%3E%2C%20Chandoo%3C%2FP%3E%0A%3CP%3E6%20line%20chart%20variations%20that%20every%20business%20analyst%20and%20data%20person%20should%20know%20-%20including%20indexed%20charts%2C%20spaghetti%20charts%2C%20forecasting%20and%20more.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excel-university.com%2Ftreasure-maps-1%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSTRONG%3ETreasure%20Maps%201%3C%2FSTRONG%3E%3C%2FA%3E%2C%20Jeff%20Lenning%3C%2FP%3E%0A%3CP%3EThis%20is%20the%20first%20post%20in%20the%20Treasure%20Maps%20series%2C%20where%20we%20discover%20the%20treasure%20of%20efficiency%20with%20mapping%20tables.%20This%20series%20covers%20three%20ways%20to%20implement%20a%20mapping%20table%3A%20SUMIFS%2C%20Power%20Query%2C%20and%20Power%20Pivot.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EClick%20the%20Like%20hand%20and%2For%20leave%20a%20comment%20below%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1814062%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSC17_collaboration_009_noBG.png%22%20style%3D%22width%3A%20821px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F215690iF4223357BE7EBB69%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22MSC17_collaboration_009_noBG.png%22%20alt%3D%22MSC17_collaboration_009_noBG.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3ECheck%20out%20this%20week's%20latest%20from%20Excel%20MVPs%20Chandoo%20and%20Jeff%20Lenning%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1814062%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20MVP%20Blog%20Roundup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Oct 23 2020 08:10 PM
Updated by: