Inbox Zero

This week, while thinking over what tips I can provide about Microsoft Outlook, I realized that this would be the perfect time to embed a video that’s been on the Internet for a while now. Merlin Mann is the founder of the website 43 Folders, and a longtime proponent for the ‘get things done’ ideal. Here’s a talk he gave on the campus of Google back in 2007 about managing your time. FYI, this is a nearly hour-long video; it’s worth it, but you’ll need to set aside some time!

To help you manage your day-to-day work, Learn iT! has a course entitled Manage Your Everyday With Outlook. If you feel like you need a more thorough explanation of Microsoft Outlook, try out our Outlook courses.

My Favorite Sites: Kuler

When designing anything – websites, pamphlets, a ‘Lost Dog’ poster – color is one of your major considerations. I’m fond of saying that I never took a Color Theory course in college, and that’s absolutely true. When faced with a choice between one shade of purple and another, or to select brown or black to go with a particular shade of green, I immediately freeze up. So, I need resources.

Kuler, a powerful color selection resource for designers.The website Kuler from Adobe (pronounced ‘color’, if you can believe that) is a very powerful tool for the forces of beauty and useability. Try out this link to see what I’m talking about: Awesome Color Picker. You’ll need the latest version of Flash Player to get it to function for you. Let me walk you around some of the possibilities:

First, at the very top – do you want to register on this site? That’s a good question. The short answer is ‘not yet’. You can use the functionality of Kuler without a registration. If you’d like to save color schemes for later use, or to throw them out to the community, you’ll need an account. Let’s not get ahead of ourselves.

Next, what is the color scheme that I see in front of me? It happens to be one of the more popular saved schemes that a user has created recently. If you look at the list of schemes directly below it, you can see that clicking one of your options on the list changes the scheme above. Pretty nice, to be able to use color schemes that others have created and still others have voted in.

Kuler, a powerful color selection resource for designers.Finally, you have the bottom-left corner. You can see that you’re currently in the Themes section and browsing some Highly Rated schemes; you can also search by key terms for a scheme that does what you need it to do. Anytime you like, click the button that looks like color sliders (see inset), and you can get the number values (HSV, RGB, CMYK, HEX) that represent the scheme you like. Then use those number values to input into the program of your choice (Photoshop, Dreamweaver, the like). One of my favorite features, though, is the button that says ‘Create’. I’ll click there and dive into more possibilities.

As you can see, you’re currently creating a color scheme that adheres to a color theory rule called ‘Analogous’. This means that the colors within the scheme are all on the same part of the color wheel, and all have the same base color. As you can see, this results in a scheme that works, but is very one-note. This can be perfect for deciding which colors to use in addition to white, black, or brown.

Kuler, a powerful color selection resource for designers.If you change rules, you’ll see that the markers on the color wheel slide around, giving you greens with reds, or even yellows and blues with your reds (Superman color scheme!). Then, when you think you’ve seen enough from the red end of the spectrum, feel free to grab the markers on the wheel and begin pulling them around the wheel, or in and out. A color from the outside part of the wheel is very ’saturated’, or has a lot of pigment, whereas the ones from the center of the wheel are washed out, or ‘desaturated’.

Between these two possibilities (using someone else’s scheme or creating your own), you should be pretty well set on colors for most of your designs. However, there are times when you need a little something more. For example, if you’d like a design that feels ‘beachy’ or one that reminds you of a warm autumn afternoon in the Northeast, you may not be able to find the exact colors that ring true. For that purpose, you have the option to Create your color scheme From an Image. Simply click that option on the left, then upload the photo of your choice. Kuler automatically pulls complementary colors from the photograph. It’s a beautiful thing.

Kuler, a powerful color selection resource for designers.

Learn iT! offers courses that use these tools regularly. You may want to check out our Adobe Illustrator line, or perhaps come into our Guided Web Design Lab. This will give you ample opportunity to select complementary colors and see if they work for your designs!

Five Great Excel Selection Tricks

If you want to move more quickly and confidently in Microsoft Excel, here’s a couple of useful tips:

Start by having all your data touching, or contiguous. Extra rows, columns, and other spaces breaking up your data make this trick tougher. Then click any of the cells in the data set.

Have you drag-selected a big hunk of data? We all have. The keyboard shortcut that will save you a lot of grief is <CTRL> + <A>. This selects all the data that’s touching (this works in Excel 2003 and 2007). Make sure your selection is inside the data before you try it.

 Select all the cells with content.

If you needed to select just the row you were in, the keyboard shortcut is <SHIFT> + <SPACE>. To select the column, it’s <CTRL> + <SPACE>. This selects the entire row or the entire column, the same as when you click the column header.

Select an entire column.

Select an entire row.

Finally, the one I like the best: selection of a column or row from within a data set. The difference with this tool is that you’re selecting only a single column or row, not the entire set of information, and you’re only selecting the cells with information in them.

First, click the label of a column, or the first cell of a row. Then, hold down <CTRL>+<SHIFT>. Then, press the arrow key in the direction of your data. To select the entire column, <CTRL>+<SHIFT>+<DOWN ARROW>. To select an entire row, <CTRL>+<SHIFT>+<RIGHT ARROW>.

Select the column of data.

Select the row of data.

If you want to know every keyboard shortcut in Excel, visit Microsoft.com.

For more training in Microsoft Excel, look into our Microsoft Excel 2003 Course or Microsoft Excel 2007 Course. For more efficiency using Microsoft Office, including some killer keyboard shortcuts, check out our course in Microsoft Office Efficiency.