OneNote of Andriod is Here, Check out this article from Office.com

OneNote Mobile for Android is now available worldwide

byMichael C. Oldenburg

on February 07

For all of you who've been asking (and patiently waiting) for a version of OneNote for your Android phones, we have great news: OneNote Mobile for Android is now available! Download it from the Android Market app store today!
Mobile versions of OneNote are currently available on Windows Phone, iPhone, iPad, and now Android. No matter which platform you prefer, OneNote Mobile lets you easily capture and access all of your notes and ideas on the go.
If you're already using OneNote on your PC, the mobile versions of OneNote let you take your notes with you — from simple lists and to-dos to full-fledged notebooks which you can share with your friends, family, co-workers, or classmates. With a free Microsoft SkyDrive account, you can easily sync all of your OneNote notebooks so they're always up-to-date and accessible from your mobile device, your Web browser, or your computer. (Learn how to move your notebooks to the cloud.)

Feature summary

OneNote Mobile for Android includes the following features:

• Text formatting, images, and bulleted lists
  
• To-do lists with clickable checkboxes
  
• Quick photo capture with your phone's camera
  
• Quick access to recent notes
  
• Store and access multiple OneNote notebooks
  
• Sync to your free SkyDrive account for access anywhere
  
• Offline access to your notes
  
• Option to sync notebooks only over a Wi-Fi connection
  
• Support for external hyperlinks
  
• Table editing
  
  

Screenshot gallery

Here are a few examples of the OneNote Mobile for Android app in action:

Free vs. unlimited use

OneNote Mobile for Android is free to download and use for up to 500 notes. When you've reached this limit, you can upgrade the app for a one-time fee of US $4.99 for unlimited use.
If you choose not to upgrade to the unlimited version, you can still view, sync, and delete any of your existing notes even after you've reached the 500 notes limit. However, you will no longer be able to edit your notes or create new ones on your Android phone.
For unlimited use pricing outside of the United States, please visit the Android Market in your region (see below for a complete list of supported countries and markets).

Using the Paste Options Button

Why does formatting sometimes get messed up when you cut and paste text?
That thing--the Paste Options button--is your friend.
Using the Paste Options Button
Click the down-arrow on the Paste Options button and you'll see a menu with icons that lets you format copied text in different ways. The options you'll see depend on where you're cutting and pasting from and to, e.g., from within or between documents. Roll your mouse over the icons and you can see how your pasted text will look before you click.

These are the four most common options:
1. Keep Source Formatting: Keeps the formatting of the text you copied
2. Use Destination Styles: Matches the formatting where you pasted your text
3. Kept Text Only: Discards both the text formatting AND the non-text elements you copied, such as pictures or table, and then matches the formatting where you pasted the text
4. Merge Formatting: Keeps the formatting of the text you copied without changing the formatting of the destination document, e.g., if you cut and paste a sentence from another document that had a different font type or size

WebApps vs Google Docs

Auto fill handle

Recently, there has been a short cut in Microsoft Excel that very few have known in training. Many people have known that you can drag the black box on the bottom right of a cell and it will copy its contents, however, a simple double-clicking will actually do the dragging for you. It will follow the column that is to its left, so if there is a blank it will stop the auto fill.

How that helps some of you out!

iPads and mobile computing

For the next few weeks I am able to use an iPad for work. I have used them in the past, but as I get older and wiser, I am trying to really understand the purpose behind the little devices that are sweeping through the world.

I do know personally own an Apple product, so it is taking time to get used to the little quirks. What I do know is that it is very easy to use and has a purpose. The question will remain "do I really need this?". I hope to find the answer... With having a daughter that is slightly older than an iPad 2, i am left wondering if it would be a good fit for her as well.

I have had a smart phone for over 4 years and continue to love it, but as I write this post on the iPad I am growing more and more fond of the idea.

If you use an iPad send me an email with some of your favorite apps that I should download.

3 EASY things in Excel

These things will save you oodles of time when working with Excel.

One – Auto Fill

Use Autofill to fill a list in Excel. This is a fab shortcut when you want to create a series such as a number series or perhaps a date series.

Type the first number in your sequence

Place the cursor on the bottom right hand corner of the cell

Hold down your left mouse button and drag the cursor down the column or across the rows.

Excel will either – copy the value you typed in and offer you a smart tag button on the sheet, which will give you some options, or it will create a series directly.


Two – Add things up without creating a formula

When you need to add up a selection of your data you can use the status bar at the bottom of the screen to see what the total is.

Highlight the cells you wish to add up

Look at the status bar and you will see the result


Three – Format Painter

Use the Format Painter to copy a format from one place to another

Select the cell with the formatting you wish to copy

Click once on the Format Painter Icon

Click on the cell you wish to apply the formatting to.

To apply the formatting in more than one place simply double click on the format painter icon and then you can apply the formatting in lots of places. When you are finished, click the icon again to switch it of.

I hope you found these tips useful.

Five most popular posts on the Excel blog in 2011

I came across this on the Microsoft Office Blogs and thought that I would share. Most of learners that come through class are wondering some of these same items.

 

Five most popular posts on the Excel blog in 2011

byEmily Warn

on January 26

It's still January. There's still time to share the most popular posts on the Excel blog in 2011. Thanks for reading them!

1. Can't remember all those Excel keyboard shortcuts? Now you don't have to!
   There are a lot of keyword shortcuts in Excel. You can scroll through a long list of them on Office.com, or you can download Quick Reference Cards from our blog and pin them to your corkboard. There are cards for Keyboard shortcuts with the Ctrl keys, Keyboard shortcuts with Function keys, and Miscellaneous shortcuts.
2. Staying on budget might be easier than you think
   The end of January marks the beginning of procrastination for preparing your taxes. This Excel budget template could help.
3. A capital idea: Changing case in Excel (video) Unlike Word, Excel doesn't have a Change Case button for magically switching between uppercase, lowercase, and proper case. But you can use functions to covert text from one case to another, or even a macro. Watch these videos by MVP Bill Jelen to learn about the different techniques.
4. Excel table or PivotTable?
   In Excel there are tables and then there are PivotTables. This post explains what each does and when to use one or the other.
5. How to do percentages in Excel
   In sorting through the search terms people use to find information, we always find lots of variations on the word "percentages." This post walks you through how to calculate percentages in Excel. (And, it points you to videos that offer quick refreshers on the underlying math.)