Quick Tip: Outlook: Search

Quick Tip: Microsoft Outlook: Search

In just about any application you can think of, from web browsing to document review and more, there is a search capability – even when it comes to Outlook. Every once in a while, though, search doesn’t always gives you the results you want, when you want them. I’ll help you learn how you can refine your searches with different criteria to make it easier to find the email you need in this quick tip.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Quick Tip: OneNote: Screen Clippings

Quick Tip: Microsoft OneNote: Screen Clippings

Images are a great way to supplement the notes you take, especially if it’s easier to show than to tell. However, taking screenshots with the Print Screen key isn’t very efficient. In this quick tip, I’ll show you how to use OneNote’s Screen Clipping function to take a portion of another window – or your desktop – and place it as an image in OneNote.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Quick Tip: OneNote: Audio Recording

Quick Tip: Microsoft OneNote: Audio Recording

When taking notes while listening to someone, whether you’re sitting in a lecture, watching a webinar, or even talking on the phone, it can sometimes be difficult to make sure you catch everything. Maybe you aren’t able to ask a question or only caught half of a sentence. If you’re taking notes in OneNote, you’re in luck. In this quick tip, I’ll demonstrate the audio recording and indexing capacity of OneNote, so it can help you find the exact spot to complete your notes.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Quick Tip: OneNote: Copy from Kindle

Quick Tip: Microsoft OneNote: Copy from Kindle

If you’re an avid user of e-readers, such as the Amazon Kindle, you may have highlighted important passages. However, these are stored online, and you may not always have access to them; and because they’re stored from newest to oldest, the highlights of books you’ve read a long time ago will take quite a while to find. In this quick tip, I’ll show you how you can use OneNote to store the all of the highlights from all of your books.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Quick Tip: Excel: Freeze Panes

Quick Tip: Microsoft Excel: Freeze Panes

Spreadsheets that are dozens of columns wide and hundreds of rows long can be difficult to read. You have to scroll all the way back up to the top to remember what the header said, and then hopefully keep it in mind by the time you get back to the item in question. Thankfully, there’s a way to let the important rows and columns (such as headers) stay in view while you browse your data. I’ll show you how to freeze certain cells in a spreadsheet in this quick tip, so no matter how much data you have, you always know what you’re looking at.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Quick Tip: Excel: Referring to Other Sheets

Quick Tip: Microsoft Excel: Referring to Other Sheets

Sometimes the data you need is in the same Excel book, but not the same spreadsheet you’re working on. Adding the data all over again in this sheet can be redundant, especially if there are frequent changes and calculations. In this quick tip, I’ll show you how you can get cells from one sheet to another and get the results you need where you are.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Quick Tip: Excel: Formatting Headings

Quick Tip: Microsoft Excel: Formatting Headings

Headings are a great way to help your audience understand what date is in your spreadsheet. But sometimes those headings have two, or three, or ten sub-headings. The longer those headings get, the harder it is to get them to look pretty or be legible. I’ll show you in this quick tip how you can format headings in your table, from merging multiple cells together to standing text on its side and more.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Quick Tip: Excel: Counting Values

Quick Tip: Microsoft Excel: Counting Values

Every once in a while, data needs to be reviewed after it has been entered. Maybe you need to figure out how many cells have a value in them – or how many are empty. In this quick tip, I’ll show you an easy way to tally up the number of entries in your table by counting values.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Auto-Fill-Formulas

Quick Tip: Microsoft Excel: Auto Fill Formulas with Dollar Signs

This quick tip will allow you to set down your calculator. Not only can Excel calculate formulas with your data, you can use Auto Fill to repeat those formulas across the spreadsheet, even if you’re working with currency. I’ll show you how you can Auto Fill formulas with dollar signs in Microsoft Excel, and let it do the heavy lifting for you.

See more quick tips here: Quick Tips for Microsoft Office Applications.

Excel-Auto-Fill

Quick Tip: Microsoft Excel: Auto Fill

When you’re working with sequential numbers or dates in Excel, typing every single item in every cell for that column or row can be time-consuming. Auto Fill is Excel’s way of doing this for you. I’ll show you a lightning-fast way to fill in sequential (or same) values across multiple cells with Auto Fill in this quick tip.

See more quick tips here: Quick Tips for Microsoft Office Applications.