Excel Tip Tuesday: Controlling Auto Correct in Excel

Posted by Lisa on January 29, 2019 at 10:30 AM

Excel can be a real know-it-all sometimes. Do you find yourself fighting with the software when it wants to auto correct certain letters or words that you type in...and that you know are correct? For example, I have a customer number that is WYA and Excel changes it to 'WAY' every time. Well, you can tell Excel not to make these types of corrections anymore! 

Read More

Topics: Excel, Excel Tip Tuesday

Excel Tip Tuesday: More about How to Arrange Windows

Posted by Lisa on January 22, 2019 at 10:30 AM

Last week, we looked at how to arrange numerous Excel workbooks without have to spread windows out all over the place. But what if you want to arrange multiple worksheets in the same workbook. Can’t be done, right? Wrong! You can definitely do it! Heres's how.

Read More

Topics: Excel, Excel Tip Tuesday

Excel Tip Tuesday: How to Arrange Windows

Posted by Lisa on January 15, 2019 at 10:30 AM

Do you become an Excel contortionist, spreading new windows all over your many monitors every time you need to see data in two or more workbooks at the same time? If you need to view or compare the contents of multiple workbooks, there's a better solution. Clicking the Arrange All button from the Window group on the View tab of the ribbon will present you with several options to accomplish the same thing while saving real estate on your monitors. When the Arrange Windows window opens, you'll see several options: Tiled, Horizontal, Vertical or Cascade.

Read More

Topics: Excel, Excel Tip Tuesday

Excel Tip Tuesday: Using Templates

Posted by Lisa on December 18, 2018 at 10:00 AM

Even though the list of templates comes up first when starting Excel, most people just skip past it, unintentionally preferring the hard road of building new worksheets from scratch. Yet if you want a nicely formatted form, list, chart, or report but you don't have a lot of time - or ideas - Excel provides hundreds of templates at the ready to help you begin your project.

Read More

Topics: Excel, Excel Tip Tuesday

Excel Tip Tuesday: Recent Workbooks and Using Pins

Posted by Lisa on December 11, 2018 at 10:00 AM

You may have dozens of Excel workbooks that you use, but chances are that there are a select few that you work with frequently and intensely. There are a couple ways within Excel to make those commonly used workbooks faster to access so that you can get your work accomplished with less clicking around.

Read More

Topics: Excel, Excel Tip Tuesday

Excel Tip Tuesday: How did you copy all that data?

Posted by Lisa on May 15, 2018 at 10:30 AM

When I'm teaching a class or doing a demo in Excel, people will often stop me suddenly and ask, "Wait, wait, wait! How did you just copy all of that data so fast?" Here's how you can speed things up for yourself.

Read More

Topics: Excel, Excel Tip Tuesday

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

  • There are no suggestions because the search field is empty.

Recent Posts

Posts by Topic

see all