Excel MVP Blog Roundup

Published Oct 23 2020 03:10 PM 3,511 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
%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%3CLINGO-SUB%20id%3D%22lingo-sub-2112737%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20MVP%20Blog%20Roundup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2112737%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20set%20up%20an%20Excel%20spread%20sheet%20on%20a%20simple%20loan%20calculator.%26nbsp%3B%20Problem%20is%20I%20need%20a%20spread%20sheet%20for%20a%20Monthly%20Loan%20Balance%20Calculator%20for%20Uneven%20mortgage%20payments.%26nbsp%3B%20I%20don't%20know%20how%20to%20adjust%20the%20principal%20and%20interest%20and%20ending%20balance%20on%20my%20spread%20sheet.%26nbsp%3B%20Can%20someone%20help%3F%26nbsp%3B%20Maggie%20Colburn%3C%2FP%3E%3C%2FLINGO-BODY%3E
Version history
Last update:
‎Oct 23 2020 08:10 PM
Updated by: