Categories
Microsoft Excel Office 2016

How To Apply Range Names To Formulas In Excel

Named ranges can be great when you are writing formulas. Suppose if you assign the name WidgetPrice to cell A5, you can then use the name WidgetPrice in your formulas instead of A5. This will make your formula (and its purpose) easier to understand when you are working with them on a later date This […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Microsoft Excel

Fill Effects in Excel – What you Need to Know

Excel does not purport to be a specialized graphics program. It is a Worksheet program.  Having said that, you can insert drawing objects that could be helpful to the viewer regarding the information you are trying to convey to them in your worksheet. You can even get fancy and  fill them with a color. Follow […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Microsoft Excel

How to Create a Web Page in Excel

You may not think so, but creating a Web page from one of your existing Excel workbooks is extremely easy. Basically all you need do is drill down to the workbook you want to use and then click F12, which will open the Save As dialog box. You must be sure that you change the […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Microsoft Excel

How to Quickly Select Excel Worksheets

We all know that Excel workbooks can contain any number of worksheets and the tabs identifying those worksheets are located at the bottom of the screen. I think most of my subscribers also know that when you have a workbook with many, many worksheets and all the tabs will not fit at the bottom of […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Microsoft Excel

Copying Between Two Instances of Excel

The first thing I am going to do is clarify that copying information between two instances of Excel is not the same as copying information between two worksheets opened in one instance of Excel. Nowadays there are many offices with desks with two monitors on them. Amazing the advances we have made isn't it? All […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Microsoft Excel

Use Formulas to Join Text in Excel

You can use the ampersand operator (&) in MS Excel when you need to join text. In Excel the ampersand operator is known as the concatenation operator. For instance, the formula =A2&B2 will join the text values shown in the two cells A2 and B2 below. When using the ampersand operation you may want to […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Microsoft Excel

How to Calculate a Median Age in Excel

Martin, who works in the HR Department of his company, wrote to me recently with a query. It seems he had a list of ages in column A of his worksheet. The ages were from 1 to 100. In column B he had the number of folks of each age. His query was - can […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Microsoft Excel

How to AutoFill for Every Other Day in Excel

A reader wrote to me recently asking me how to use AutoFill in Excel to reflect every other day rather than consecutive days. Seems he was setting up a worksheet to keep track of his diabetes and wanted to use readings every other day. I was happy to tell him that it was very easy […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Microsoft Excel

How to Set Excel Height & Width Using Your Keyboard

Those of you like me, who love to use their keyboard to save time will love this information and those of you who didn't know you could accomplish this task with your keyboard will be very happy to learn that you can! Unfortunately, this is not terribly easy, but it can be accomplished. Follow the […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!
Categories
Microsoft Excel

How to Display Negative Time in Excel 2007 and 2010

Have you ever used Excel to record employee start and finish time? I know I tried it a long time ago and quickly became very frustrated because it would not display negative time. I tried everything and finally gave up in frustration. Luckily I know some very smart folks who are much more proficient than […]

This content is exclusively for Carol's Corner Office Subscribers.
If you are a Subscriber please Log In below.

Not a Subscriber? Please Consider becoming one today for ONLY $20/yr. Your subscription supports the site and gives you access to many exclusive resources not available to non-subscribers, as well as substantial discounts on Carol's Microsoft Office books.

  • Exclusive in-depth content ONLY for subscribers. Use Microsoft Office like a Pro!
  • Large color screenshots illustrate the instructions so following along is easy!
  • Email notification of each new exclusive post for subscribers!
  • Exclusive discounts on Office books and other products!