Quick Tip: Microsoft Outlook: Search

Robert Bogue June 13, 2017 No Comments

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: Microsoft OneNote: Screen Clippings

Robert Bogue June 6, 2017 No Comments

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: Microsoft OneNote: Audio Recording

Robert Bogue May 30, 2017 No Comments

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: Microsoft OneNote: Copy from Kindle

Robert Bogue May 23, 2017 No Comments

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: Microsoft Excel: Freeze Panes

Robert Bogue May 16, 2017 No Comments

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: Microsoft Excel: Referring to Other Sheets

Robert Bogue May 9, 2017 No Comments

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: Microsoft Excel: Formatting Headings

Robert Bogue May 2, 2017 No Comments

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: Microsoft Excel: Counting Values

Robert Bogue April 25, 2017 No Comments

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.

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

Robert Bogue April 18, 2017 No Comments

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.

Quick Tip: Microsoft Excel: Auto Fill

Robert Bogue April 11, 2017 No Comments

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.