Create and Share Documents Easily Using OneDrive

Easily create and share documents with others using Microsoft OneDrive. OneDrive starts out with  7GB of free online storage for use. Once you have the free account you can upload documents and pictures. Then share the documents you want with others.

Create an Office Document

  • Word
  • Excel
  • PowerPoint
  • OneNote
  • Excel Survey
  • Plain Text Document

create an office document onedrive

Upload a document or picture.

upload a document or picture to onedrive

Create a folder. Folders come in 3 types.

  • Private
  • Shared (Edit or View Only permissions)
  • Public

Below are the steps to create a shared folder.

  1. Click Create–>Folder–>Name Folder
  2. Select the check box next to the folder
  3. Click Share
  4. Add Email(s)
  5. Confirm Edit or View Only permissions as you send email link

create onedrive folder

 

 

checkbox for onedrive folder

email onedrive folder

view edit onedrive folder

The first stop is to visit www.onedrive.com to sign up for an account if you don’t already have one.

 

 

Posted in OneDrive | Tagged | Leave a comment

Display and Delete Duplicates in Excel [Video]

In Excel 2007, 2010 and 2013 you can easily show duplicate values using Conditional Formatting. Also you can delete duplicate values.

This video I will teach you how to display and delete duplicates in Excel.

Posted in Excel | Tagged | 2 Comments

Windows 8.1 Tablet Training PowerPoint Presentation

Posted in PowerPoint, SkyDrive, Training Files | Tagged , | Leave a comment

Tabs in Word [Video]

Posted in Word | Tagged | Leave a comment

Use the Pens Tab in Word to Quickly “Pen” Your Signature

The Pens tab can be added to the Word 2010/2013 Ribbon. This will allow you to easily “pen” your signature to a Word document.Pens Tab in Word

Below is an example of a signature line you might want to add your signature to.

Example of Sign a Document in Word

The fist step in adding the Pens tab is to right click the ribbon and select “Customize the Ribbon” Then from the “Choose commands from” drop down choose the Tool Tabs. Click the Pens tab below the ink tool then click add.

Customize the Ribbon in Word

Once you click OK you will have the pens tab to work with. Click the pen style you like and your cursor pointer turns into a drawing tool. To get the normal selection arrow back, click the “Select Objects” command.

Final Example of Signed Word Document

Posted in Word | Tagged | 2 Comments

Try Goal Seek in Excel to Find Out What You Need to Get an “A” in Class

This post will bring back some school memories and test anxieties perhaps. Say you have taken 5 of 6 tests and you currently have 91.32 average. In order to earn an “A” you need a minimum 90 grade average. And it is the night before you go take the final test 6. Goal seek to the rescue!

goal seek scenario

Find the goal seek command from the Data tab.

goal seek data tab

After you click the What-If-Analysis, you will find goal seek among the choices.

The three choices for goal seek include:

  • Set Cell:
  • To Value:
  • By Changing cell:

Set Cell is always going to be formula cell. In my example I have it set cell D7. This is my average formula of the 6 test grades.

To Value is what you want. In my example I have it set to equal 90.

By Changing Cell is what cell you want to change. In my example I have it set to cell D6 which represents the test 6 input grade.

Set cell to value using goal seek Excel

Click ok, watch the cells dance and examine the solution results.

Goal seek found solution

So it turns out after all that goal seek found out you need a 83.4 score to earn a 90 for the average. You got this one!

Posted in Excel | Tagged | 1 Comment

My Wife’s Cooking Segment Airs on the Rachael Ray Show this Friday!

Just wanted to pass along to my readers that my wife will be appearing as a guest on the Rachael Ray show this Friday (2/28)!

Rachael Ray, Nick Lachey

I’m so excited for her and I hope that you can make arrangements to watch. Erin started her blog, www.5dollardinners.com back in August 2008 and she has turned her blog into a successful business with authoring cookbooks, speaking engagements, and helping others reach their online business potential at blogging conferences. And did I mention she is an awesome mom to 4 boys!

Watch a portion of the segment.

Posted in My Wife's $5 Dinner Series Cookbooks | Leave a comment