Microsoft Excel Tips - Quickly Create And Use A Named Range In A Formula

If you would like to get more tips
from The Excel Addict every week,
please click here.

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

February 6, 2018

Hi fellow Excel Addict,

Today's tip is quick and simple. I hope you enjoy it.

If you find it helpful, please share it with others who may also benefit from it.

Take care and keep on Excelling,
Francis Hayes (The Excel Addict)
Email: fhayes[AT]TheExcelAddict.com

P.S. If you haven't already checked out Mynda's Excel Dashboard course, her 20% discount is available for only a couple of more days

Francis Hayes - Learn to work smarter with Excel at TheExcelAddict.com

Knowing How to Make Amazing Excel
Dashboards Could Take Your Career
to the Next Level

Best Online Excel Training with Mynda's Excel Dashboard Course and Power BI Course

Discover what email marketing can do for your company...

If you missed my last newsletter, you can click here to view it online.

Quote of the Day

"There is a real magic in enthusiasm.
It spells the difference between
mediocrity and accomplishment."

-- Norman Vincent Peale --

If you have a favourite quote, send it to me and I may post it in my newsletter.

Quickly Create And Use A Named Range In A Formula

To make it easier to use a cell or range in your formulas:

Create a named range:
1) Select the cell or range of cells;
2) Type a name in the Name Box (i.e. white space to the left of the Formula Bar);
3) Press Enter.

http://www.theexceladdict.com/images/create_a_named_range_in_Microsoft_Excel_2007_2010_2013_2016_365.png

Use a Named Range in a Formula:

Enter your formula as usual but now you can use the name instead of the cell reference.

Use Named Range In A Formula in Microsoft Excel 2007 2010 2013 2016 365

For more in depth information check out this Microsoft article,

If you've found this tip helpful, please share it.

Excel Dashboard Reporting
Course Now Open for Registration

This Excel Dashboard Reporting Course is hosted by Excel MVP, Mynda Treacy. It comes with a 12-month membership so, if you don't find the time to get through this course in the next 6 weeks, you'll have plenty of time to dig into it and become a master of Excel Dashboard Reporting.

Excel Webinars
Mynda has three free webinars that explains to you what dashboards are and how they're used in Excel. She will show you step-by-step how to create your first one. Even if you don't plan on taking the course, you will learn the basics of creating dashboards just from watching these webinars (includes practice workbooks).

And did I mention these webinars are free.

There are three webinars to choose from:

Creating Excel Dashboards
Dashboards With Power Query & Power Pivot
Power BI Dashboards for Excel Users.

Click here to get access to all of them.

If you would like to get more tips
from The Excel Addict every week,
please click here.

Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are EVER not completely satisfied with anything I recommend, please let me know and you will get your money...GUARANTEED. You can't lose.

"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630