Named Ranges

Named Ranges

Ryan Vaughn Ryan Vaughn

Ryan Vaughn

We apply analytics.

发布日期: 2019年2月21日
+ 关注

Scenario: You want to use the same number across different tabs (say total sales). The issue is you always have to click back to the original tab. What if you could make your formula look like "= sales"? In this lesson, I show you just that. This video is 2 minutes and 46 seconds.


要查看或添加评论，请登录

Ryan Vaughn的更多文章

  • Do Airlines Fly More in January or July?
    2021年1月25日

    Do Airlines Fly More in January or July?

    In this video, Dr. Winston explains whether airlines fly more in January or July.

  • The XLOOKUP Function
    2020年9月19日

    The XLOOKUP Function

    The XLOOKUP Function in Excel will replace the most popular functions such as VLOOKUP, HLOOKUP, and INDEX/MATCH. This…

  • Variance Analysis
    2019年5月24日

    Variance Analysis

    In this video, Dr. Winston shows how to decompose a sales variance into a volume, product mix, and price variance.

  • Product Line Pricing
    2019年5月22日

    Product Line Pricing

    In this video, Dr. Winston shows how changing the price of two products, (specialty and regular coffee) changes the…

  • The Butterfly Effect
    2019年5月21日

    The Butterfly Effect

    In this video, Dr. Winston illustrates the Butterfly effect: If a butterfly flaps its wings in Tahiti it may cause a…

  • The Gravity Model
    2019年5月16日

    The Gravity Model

    In this video, Dr. Winston shows how to implement a complex formula, the Gravity Model which computes market shares for…

  • Depreciation
    2019年5月16日

    Depreciation

    In this video, Dr. Winston shows how to model 3 different methods of depreciation used to depreciate a machine to its…

  • Amortization Schedule
    2019年5月13日

    Amortization Schedule

    In this video, Dr. Winston shows how a loan payment reduces the balance of a loan by the end of the loan term.

  • Modeling Fish in a Pond
    2019年5月13日

    Modeling Fish in a Pond

    In this video, Dr. Winston shows how to create a dynamic model that shows the evolution of the number of fish in a pond.

  • Modeling a Retirement Fund
    2019年5月6日

    Modeling a Retirement Fund

    In this video, Dr. Winston shows how to model the evolution of a retirement fund.

社区洞察

其他会员也浏览了