The SUBSTITUTE Function

The SUBSTITUTE Function

Ryan Vaughn Ryan Vaughn

Ryan Vaughn

We apply analytics.

发布日期: 2018年12月28日
+ 关注

Scenario: You have data in a cell that you want to substitute with a different value. For example, you want to make every space a dash. This lesson shows how to do that with the SUBSTITUTE Function and is 1 minute 52 seconds long.


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

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.

社区洞察

其他会员也浏览了