Wednesday, July 24, 2019

Create an Exploding Pie Chart

If you wanted to get fancier then the ordinary pie charts how about making a 3D pie chart that has the slices come out from the center. In this video, I'll cover how to create a pie chart with an exploding pie slice.  Also covering how to change the rotation and adding some 3D effects.

Tuesday, July 23, 2019

Calculate the Interest Rate on a Car Loan

Use the Excel RATE Function to calculate the annual interest rate.  This will give you an idea how much interest you are paying if you change the monthly amount or number of payment periods.

Monday, July 22, 2019

Create a Stock Chart

Are you tracking a stock investment and wanted to see how it's trending over a period of time?  But not just happy looking at numbers in a table?  Well create a chart....more specifically create a stock chart! This type of chart will let you look at the trend of high/low/open/close price of a stock over a period of time and let you visually see how it's been faring.  Did you also know this type of chart is as old as dirt?  The concept of the stock charts takes from candlestick charts which were supposedly created in 18th century in Japan by a rice trader.  So when creating your stock chart, you'll be in good company knowing that it's origin had the same purpose as it does today - to track investments.  See the video on how to create the stock chart.