Categories
Subscribers Excel 2010

Subscribers: How to Import CSV Text Files into Excel 2010

Comma Separated Value (CSV) formatted files are one of the easiest methods to store and transfer data because it is one of the most compatible files you can use. Even Notepad, which is a basic text editor, works well with them although I would not recommend using Notepad if you have a huge file. 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
Subscribers Excel 2010

Subscribers: How to Convert an AutoShape to a Different Shape in Excel Quickly & Easily

I personally do not find myself using AutoShapes frequently in Excel but a lot of other folks do, so this article is for you! If you have an existing AutoShape in your worksheet and would like to change it to another, you can very easily and quickly convert it without having to reinvent the wheel. […]

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
Subscribers Excel 2010

Subscribers: How To Join Text and a Number in an Excel Formula

In many cases you can use the Ampersand symbol (& - what most folks call the "and" sign) operator to join text with a number in your formula. If you want to combine text with the results of a formula in a cell you use Concatenation. Suppose you have calculated a range of cells using […]

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
Subscribers Excel 2010

Subscribers: How to Define a Single Condition in Excel

There is a very powerful feature that comes with Excel that will allow you to format the contents of a cell based completely on conditions that YOU specify. Of course, this is called Conditional Formatting. When you decide to use conditional formatting, it's all up to you and whether you want to define a single […]

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
Subscribers Excel 2010

Subscribers: How to Prevent Automatic Hyperlinks in Excel

Hyperlinks are great! I love to use them and I sometimes use them in Excel. Hyperlinks can be very useful in your Excel worksheet (i.e., links to data, other workbooks, documents, Websites, e-mail addresses, etc.) Even though hyperlinks are often useful in your worksheets though, it can be downright aggravating when you enter data (i.e., […]

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
Subscribers Excel 2010

Subscribers: How to Track Nothing in Excel

The title is intriguing isn't it? Actually I am going to show you how to track when there has been no activity in certain cells in your Worksheet! Suppose you have your own business and you have several hundred clients and your business is still growing. Now you want to make sure that you make […]

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
Subscribers Excel 2010

Subscribers: How to Correct a Capital Mistake in Excel

How many times have your fingers been flying over your keyboard and then you happen to glance down and discover that Caps Lock is on?  Isn't that so aggravating?? Fortunately, Excel can catch my error for me - IF I tell it to! Follow the steps below to learn how: On your Ribbon, Click 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
Subscribers Excel 2010

Subscribers: How to Shade Cells Based on Odd and Even In Excel

When your worksheet has a range of cells with a series of values, you may choose to use a different format to show the difference between the odd and even values. The method to do this is using the Conditional Formatting feature. Follow the steps below to learn how: Select the cells that contain odd […]

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
Subscribers Excel 2010

Subscribers: How to Use a Custom Drop-Down List for Choices in your Worksheet

There are myriad reasons why one would want to control a user's input in a worksheet.  My number one reason is that it saves time and keystrokes and everyone knows how much I love that! Another reason is that it will limit the choices and you will then be certain to get the data that […]

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
Subscribers Excel 2010

Subscribers: How to Find All Merged Cells on your Worksheet

Lots of folks used merged cells in their worksheets and then can definitely be helpful but many times, those helpful merged cells can cause you untold heartburn when selecting ranges, sorting and lots of other functions we use in Excel every day. Even if you do not use merged cells because you once experienced 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!