Blog Post

Excel Blog
1 MIN READ

Excel MVP Blog Roundup

cuong's avatar
cuong
Icon for Microsoft rankMicrosoft
Oct 23, 2020

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

 

ChandooJeff 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

 

Updated Oct 24, 2020
Version 4.0
  • 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