%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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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%20noopener%20noreferrer%20noopener%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
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