Create Exponential Growth Curve in Excel - 2235

У вашего броузера проблема в совместимости с HTML5

Generate an exponential growth curve that will generate 600,000 units of sales in 70 days. Brandon sent in this question. It turns out that this is fairly easy to do using the GROWTH function in Excel.

Table of Contents
(0:00) Welcome & Problem
(0:21) Need to create an exponential growth curve that meets a certain size
(0:50) Use SEQUENCE function
(1:00) Add the word “Day” to each number using custom number format
(1:30) Using the GROWTH function with B14#
(1:50) Ctrl+* to select current region
(1:55) Inserting a chart
(2:25) Rejecting Goal Seek
(2:50) Formula to scale up using a constant
(3:45) Compounding the issue: four days are holidays with 0 sales
(4:10) Using COUNTA function
(4:30) Using WORKDAY.INTL function with no weekends syntax!
(5:40) Changing the Chart Data using Select Data
(5:52) Using F2 to edit in dialog box to prevent cell references being inserted
(6:45) Wrap-up