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: 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: 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: 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: 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.

Excel-Insert-A-Table

Quick Tip: Microsoft Excel: Insert a Table

Working with large amounts of data can make it difficult to find what you need, especially if the data hasn’t been entered in order or you’re looking for something specific. When you want to sort and filter your data, creating a table is the way to go. In this quick tip, I’ll show you how you can quickly add a table in Excel to make managing your data easier.

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

Quick Tips (< 2 mins) for Microsoft Office Applications - Weekly

I get to sit next to my wife and work every day.  It’s an amazing experience, but occasionally we have a conversation that goes something like this:

Terri: “How did you do that?!?”

Rob: “Do what?”

Terri: “That.”

Rob: “I don’t know what you’re talking about.”

To stop our own personal version of Abbott and Castelo, I’ll stop there.  In the end, it turns out that I’ve learned some little tricks to using the Microsoft Office applications.  Whether it’s the Ctrl-Z combination to undo my last change, or Ctrl-A to copy everything, or something a bit more complicated, she wants to know how to do it.

Out of the blue, I got asked if I would do some tips for using Office applications for a community event.  When I accepted before thinking about it, I realized that they wanted 30 tips demonstrated in a 60-minute session.  In other words, I had to show people 30 tips in under 2 minutes apiece.  For that I knew I’d have to do videos.  The setup time to get sample data ready would just take too long.

So, I did that.  I recorded 30 tips that, on average, are less than 2 minutes each.  Each week on Tuesdays at 8AM EST (including today), I’ll be posting another tip.  There will be an introductory blog post and we’ll make the video available on YouTube.  Here’s the list of tips so you can look forward to them (as they go live we’ll come back and update this post with a link to them):

Microsoft Excel: Insert a Table

Quick Tip: Microsoft Excel: Auto Fill

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

Quick Tip: Microsoft Excel: Counting Values

Quick Tip: Microsoft Excel: Formatting Headings

Quick Tip: Microsoft Excel: Referring to Other Sheets

Quick Tip: Microsoft Excel: Freeze Panes

Quick Tip: Microsoft OneNote: Copy from Kindle

If you’ve got a tip that you don’t see here, that can be done in two minutes, let me know.  I’ll record it and add it to the list.