Use Excel’s Color Scales to Spot an Outlier

Can you spot the cell that is different than the rest in the screenshot below?


excel before


Select the cells, click the Home tab then Conditional Formatting–> Color Scales. Your outlier will stick out with a different color than the rest.


excel color scales


Posted in Excel | Tagged | Leave a comment

Excel Conditional Formatting on Sales Greater Than $500,000 [Video]

Posted in Excel | Tagged | Leave a comment

Create Labels in Word Using a Mail Merge

This post I’ll share how to make labels in Word using a mail merge. First you click on the Mailings tab (Word 2007, 2010, and 2013) and click Start Mail Merge. Then click Labels.

In the Label Options box, choose the vendor and product name. In this example, I have selected Avery US letter 5160. This is popular template with 30 labels per page.


start mail merge labels


label options

The next step is to connect to a data source like Excel. As long as you have a header row with fields like first, last, address, city, state, and zip you will be good to go.

Click Select Recipients and then Use and Existing List. This will open up a box to browse for your address file.

use exisiting list word

You will then need to add the address block to the top left cell. Click the address block command from the mailings tab. If the fields do not match up you can click match fields.

address block goes in top cell

match fields

You can click Update Labels. This is an important step that makes all the labels show up instead of just the first one.

update labels word

After you click preview results and you like the format you are ready to finish the mail merge.

Preview Results

Click Finish and Merge then either print or edit individual documents. Print will print all pages and edit individual documents will create a new file with all the pages filled with addresses.





Posted in Word | 2 Comments

My Top 7 Excel Keyboard Shortcuts

  1. Control + Semicolon to enter today’s date
  2. Control + Shift + arrow key  to select range of cells
  3. Control + Tab to switch between workbooks
  4. F4  to repeat formatting
  5. Control + C  to copy
  6. Control + V  to paste
  7.  Control + mouse wheel  to zoom in and out

Download my Excel Keyboard Shortcuts PDF guide for more Excel shortcuts.

excel 3013 logo

Posted in Excel, Shortcuts | Leave a comment

Don’t Show the Backstage when opening or saving files in Office 2013

If you have Office 2013, you no doubt have experienced a delay with opening and saving documents. That is because the backstage view appears and gives you many options. My assumption is that this allowed a view/ exposure to drive curiosity to the OneDrive account. I’m in favor of saving to the cloud, but I also want to be able to use my Control + O to open documents from the normal open dialog box with files on my computer. I found a handy solution to this this in the Options. Get to options from Excel, Word or PowerPoint by clicking the File tab, then click options. Click the Save category then check “Don’t show the backstage when opening or savings files.” And if I want to save to the cloud using my OneDrive account then I’ll happily click File–>Save As–>OneDrive.

Word backstage save and open

Posted in Excel, PowerPoint, Word | Leave a comment

Free Excel 2013 Self-Paced Courses By Microsoft

excel 3013 logo

Click here  to check the beginner, intermediate and advanced Excel 2013 courses.

Posted in Excel | 2 Comments

Free Self-Paced Training Courses for Access 2013 By Microsoft

access 2013 logo

Access this link for beginner and intermediate self-paced courses for Access 2013 produced by Microsoft.


Posted in Access | 2 Comments