Insert online video into a Word 2013 document

Now you can add a video in a Word document using Word 2013. First click the Insert tab then choose Online Video.

Search for the video online.

I had to go looking for the Cincinnati Reds!

After selecting a video and clicking insert, the video will appear near the insertion point.

By the way, I found a video from 1987 with Johnny Bench, Marty Brennaman, and Joe Nuxhall.

The video will play in the Word 2013 doc. If the document is saved as a PDF it will be a hyperlink to the video site for the readers.

Visio Keyboard Shortcuts

Download my Visio keyboard shortcuts.

Visio Keyboard Shortcuts for the PDF format.

Visio Keyboard Shortcuts for the .DOCX format.

How to create an Excel survey with SkyDrive

Using your SkyDrive account, you can create a free survey that anyone can fill out online. After people fill out your form and click the submit button the data automatically populates to your Excel spreadsheet. Data lovers-this sounds cool doesn’t it! Well this is a new feature that I had to demo. Let me show you how it works. First you need to log on to your SkyDrive account. SkyDrive is operated by Microsoft and comes along with 7GB of free online storage. You can take my survey by clicking Steve’s survey if you want to see it before I explain how to create it.

Click Create–>Excel Survey

Name the survey

From the Home tab click Survey–>New Survey

Enter a title for your survey

Click “Enter your first question here” and fill out your question with the correct response type

Data types can be the following choices:

• Text
• Paragraph Text
• Number
• Date
• Time
• Yes/No
• Choice

An example of one of my questions below

After review click “Share Survey”

Click “Create” to get a link

Email the link, tweet it, blog it, post it on a webpage to your audience. Links can be short or long. Copy and paste the link anywhere you want.

Example of filling out the survey in Firefox browser

The question and answer structure

Would you like to take my survey? If so you could click on the long link:

https://skydrive.live.com/redir?page=survey&resid=30B662933B979F63!4340&authkey=!AAX5JvOK78HFUJc

Or if it suits you click the short link:

http://sdrv.ms/11WAvRq

Open and edit a PDF in Word 2013

Open a PDF in Word and make changes! Simply awesome. All you have to do is File–>Open and browse to find your PDF doc. Word 2013 attempts to place the text and graphics in place but there may be some formatting layout adoptions that don’t work out so well. But anyway, it is worth the time it takes to make a try. Once opened be sure to double check each page for layout changes.  After edits save the file as a .docx or .pdf or both.

Below is a screen shot of 3 of my recent PDFs that I have had opened in Word.

If you are excited about this new feature please hit the FaceBook share button or leave a comment. I think this is going to help a lot of people out in businesses across the world. Not kidding

 

Income and Expense Monthly Budget Excel Workbook

Download my Income and Expense Monthly Budget Workbook. I’ve made some changes to my monthly budget. This template now includes tracking income at a monthly level. Also the summary tab has a year to date running totals so you can see the difference in income/expenses for the year.

Click Income and Expense Monthly Budget for the .xlsx format.

 

 

Audit Excel formulas by tracing cell precedents

You can visualize with blue tracing arrows where you are getting your answers from in Excel. From the Formulas tab–>Formula Auditing group–>click Trace Precedents.

Arrows will point to the cells that the formula is using.

Posting my personal and business goals to OneNote Web App on SkyDrive

Teaming up OneNote and SkyDrive is an awesome way to communicate my goals to myself. As Zig Ziglar said, how can you hit a target you don’t have. I created a list at the beginning of the year on my OneNote SkyDrive account. I can easily view my list from my Windows phone anytime I want to. One of my personal family goals is to read books to my boys as they go to bed. The other day after I finished reading The Adventures of Tom Sawyer to my boys, I went on my phone and typed the book entry into my OneNote list.  That edit was recorded automatically and it synced with my OneNote SkyDrive account so that whenever  I log in on my desktop I see the updates. OneNote is a great place to write down your goals and put your ideas down on digital paper.

If you are a OneNote user, please add a comment telling us how you use it.