Using Excel Tables

Using Excel Tables

Dr. Wayne Winston Dr. Wayne Winston

Dr. Wayne Winston

Professor and Higher Education Consultant

发布日期: 2019年7月8日
+ 关注

This video shows how making data a Table ensures that formulas update automatically when new data is added.

If you like this video and would like to enroll in my FREE 21 day course, you can do so by visiting this link:


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

Dr. Wayne Winston的更多文章

  • Introduction to the Excel Solver
    2019年8月5日

    Introduction to the Excel Solver

    In this video we introduce the concept of optimization and show how the Excel Solver can be used to find a…

    1 条评论
  • Creating Worksheet Templates
    2019年8月1日

    Creating Worksheet Templates

    This video shows that if you need a worksheet for each state set up in an identical format, how to easily use worksheet…

    1 条评论
  • One Way Data Tables
    2019年7月29日

    One Way Data Tables

    This video shows how to use a One Way Data Table to determine how changing a single spreadsheet input affects multiple…

  • How to Audit a Formula
    2019年7月25日

    How to Audit a Formula

    This video shows how to use Precedents to see which cells are needed to compute a formula and using Dependents to find…

  • Keystroke Formatting Shortcuts
    2019年7月22日

    Keystroke Formatting Shortcuts

    In this video we show Keystroke shortcuts that are useful in formatting cells. If you like this video and would like to…

  • Data Labels
    2019年7月19日

    Data Labels

    In this video we show how to add Data Labels to a column chart. If you like this video and would like to enroll in my…

  • Combo and Secondary Axis Charts
    2019年7月15日

    Combo and Secondary Axis Charts

    In this video we create combination charts and charts with a secondary axis. If you like this video and would like to…

    1 条评论
  • Creating Icon Sets
    2019年7月11日

    Creating Icon Sets

    In this video we show how to use the WINGDINGS3 font to create customized Icon sets. If you like this video and would…

  • Vertical Lookup
    2019年7月5日

    Vertical Lookup

    This video shows how to use the VLOOKUP function to compute a tax rate based on income and a products price based on…

    1 条评论
  • The OFFSET Function
    2019年7月1日

    The OFFSET Function

    In this video we define the complex, powerful, and often misunderstood OFFSET function. If you like this video and…

    3 条评论

社区洞察

其他会员也浏览了