Microsoft Office Tips, Tricks, and How-to's to help you use MS Office like a pro!

Carol's Corner Office

Category Archives: Subscribers Excel 2010

Subscribers: How to Import CSV Text Files into Excel 2010

Posted on by Posted in Subscribers 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

Read More...

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!

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

Posted on by Posted in Subscribers Excel 2010

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.

Read More...

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!

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

Posted on by Posted in Subscribers Excel 2010

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

Read More...

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!

Subscribers: How to Define a Single Condition in Excel

Posted on by Posted in Subscribers Excel 2010

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

Read More...

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!

Subscribers: How to Prevent Automatic Hyperlinks in Excel

Posted on by Posted in Subscribers Excel 2010

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.,

Read More...

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!

Subscribers: How to Track Nothing in Excel

Posted on by Posted in Subscribers Excel 2010

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

Read More...

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!

Subscribers: How to Correct a Capital Mistake in Excel

Posted on by Posted in Subscribers Excel 2010

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

Read More...

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!

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

Posted on by Posted in Subscribers Excel 2010

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

Read More...

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!

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

Posted on by Posted in Subscribers Excel 2010

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

Read More...

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!

Subscribers: How to Find All Merged Cells on your Worksheet

Posted on by Posted in Subscribers Excel 2010

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

Read More...

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!