Named Ranges in Table Format

This quick video explains a useful way of simplifying formula in Excel.

Using named ranges from tables in formula is a useful way of simplifying formulae and ensuring that the formulae remain correct if the row count changes at a later time.

 

[et_social_follow icon_style="slide" icon_shape="rectangle" icons_location="top" col_number="auto" outer_color="dark"]

Be Brilliant at Excel. Save Hours each week and add Professional Certification to Your Resume

Even Microsoft use us to teach their employees Excel

Get access to The Ultimate Excel Training Course Bundle