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
- Excel Survey
- Plain Text Document
Upload a document or picture.
Create a folder. Folders come in 3 types.
- Shared (Edit or View Only permissions)
Below are the steps to create a shared folder.
- Click Create–>Folder–>Name Folder
- Select the check box next to the folder
- Click Share
- Add Email(s)
- Confirm Edit or View Only permissions as you send email link
The first stop is to visit www.onedrive.com to sign up for an account if you don’t already have one.
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.
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.
Below is an example of a signature line you might want to add your signature to.
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.
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.
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!
Find the goal seek command from the 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.
Click ok, watch the cells dance and examine the solution results.
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 goal seek
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)!
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.