This week's blog roundup brought to you by Excel MVPs Chandoo and Jeff 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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.