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

Carol's Corner Office

Monthly Archives: March 2014

Subscribers: Show Dates with Weekday in Excel

Posted on by Posted in Subscribers Excel 2010

I freely admit that I am not an Excel guru. Having said that, I still love to save time and keystrokes and so I try to avail myself of all the available information I can find that will enable me to do that. A lot of folks seem surprised when they enter a date in

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: View All Text Horizontally in Word

Posted on by Posted in Subscribers Word 2010

By default, Word displays the text on your screen the same way it will appear when you print your document.  Most trainers call this WYSIWYG (what you see is what you get). There are times, however, when viewing your document in this way doesn't work for you. (i.e., very wide documents, screens with low resolution).

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: Create a Sidehead in your Word Document

Posted on by Posted in Subscribers Word 2010

Sidehead?  What in the world is a sidehead??  A lot of folks scratch their heads when I mention this topic as they have never heard of a sidehead. Well sideheads are document headings that are in the margin of your document rather than in the body of your document.  Something new, to shake things up

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!

Determine the Day of the Year in Macros in Excel

Posted on by Posted in Excel 2010

This tip may not be for everyone, but for those who  write macros in VBA and have a need for it, it will certainly be appreciated.

Sometimes when you are creating a macro in VBA, there comes a time when you need to determine the current day of the year.  For example, you might want to know that March 15 is the 74th  day of the year.

Luckily, VBA includes a nifty little function that will allow you to speedily determine the current day of the year and the bonus is – it’s very easy to to!

Follow the steps below to learn how:

iThisDay = DatePart(“y”, Date)

When executed,  iThisDay will be equal to the current day number.

Thanks to Alan Wyatt for this information!

Subscribers: Enlarge your Formula Bar in Excel

Posted on by Posted in Subscribers Word 2010

As you know, when you select a cell in your worksheet in Excel, you can see the contents of that cell in your Formula Bar.  If, however, the content is longer that what can be displayed in a single line on your Formula Bar, the depth of the Bar will grow so that your entire

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: Extract Records From a List in Excel

Posted on by Posted in Subscribers Excel 2010

Many businesses use Excel to manage data that employees work with on a daily basis (i.e., invoice data, shipping records, product name, etc.). In some instances, when working with this information, it becomes necessary to extract records based on different criteria. This is a prime example of when you would use filtering.  Just suppose you

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!