Google ExcelAutomate.com: April 2014

GOAL SEEK in Excel

What is GoalSeek in Micorosoft Excel?????

Goal Seek is used when you know what answer you want, but don't know the exact figure to input 
for that answer. 
You want to work 35 hours per week and gain at the end of the month a salary of 5'500 $'s. How 

much per hour are you going to ask?

1 Prepare your table. 
2 Cell B4 contains this formula: =B2*B3 
3 Cell B3 contains the salary per hour, 0 SFr for 
now. The Goal Seek tool will modify this value 
to find the solution. 
4 Under the Data tab, in the Data Tools group, click What-If 
Analysis -> Goal Seek. A dialog box appears. 
5 In the Set Cell zone, indicate the cell containing your goal 
(B4). 
6 In the To Value zone, type the value you want to meet in the 
Goal cell: 5500. 
7 In the By changing cell zone, indicate the cell to be modified: 
B3. 
8 Click OK. Excel shows a dialog box. If the Current value is equal 
to the Target value, the result is found. 
9 To earn 5'500 $. You need to ask 37.41 $. per hour. 


































LET’S PRACTICE 
Objectives: 
 Using Goal Seek 
 Using a new function. The function FV( ) is useful to calculate an investment. The syntax 
is: =FV(rate;nper;pmt) 



You want to save 200'000 $. To pay the studies of your children in 18 years. The annual interest 
rate is 5%. How much do you need to pay per year? 
1 Prepare your table. 
2 The cell B7 contains a formula to calculate your 
future amount. At the end of the payments, this cell 
should contain 200'000 $. 
=FV(B3;B4;B5) 
3 The cell B5 contains the annual payment, i.e. 0 $. 
The Goal Seek will modify this value. 
4 Cells B3 and B4 contain constants. 
5 Launch the Goal Seek tool. 
6 If the target value is equal to the current value, the result is correct. You must put each 
month 7'109.24 in your bank account to have 200'000 in 18 
years. 
Cash you pay out, such as deposits to savings, is represented by 
negative numbers. 



If you have any questions on gaol seek post it in comment section.....


Happy goalseeking!!!!!! 







Microsoft Office on iPad

Webies we know the powerful use of Microsoft office and its tools like word, excel, etc.

Is there any way to use the office application in iPad. So this article is for those who are looking for that answer.

Here you go!!!!
Microsoft in iPad is runaway hit, The three apps in the mobile productivity suite are sitting solidly at the very top ranks of Apple’s App Store.

Make Room For Office

All of the apps are sizable, running between 215 and 259 megabytes just to install. Together, they’ll take up nearly a gigabyte. If you have an older iPad or one with smaller capacity, or you store a lot of music and movies on it, this may be a concern. The apps rapidly expand in usage, too: In just a few hours of testing, Microsoft Word had expanded to take 500 megabytes on my iPad.
All of the files you work on and store locally will require their own space. So make sure you have at least a few gigabytes free. If you don’t have enough space, delete unused apps or consider reducing the amount of media you store on the device. (This may require syncing your iPhone with a cable and using iTunes.)

Next, Find The Apps

When Microsoft first launched iPad versions of Word, Excel, and PowerPoint, they were hard to find in the App Store, buried under Office substitutes like CloudOn and office-themed games. But now, when you search for “Microsoft Office” in the App Store, the three apps show up as you'd expect. Apple’s also currently lending Microsoft a hand by featuring them on the App Store, making them even easier to find.
Still, you may be better off by searching for “Word”, “PowerPoint,” and “Excel.” (There’s no all-in-one office suite like you have on desktop devices, or like Microsoft’s Office Mobile app which offers simple reading and editing of text documents, presentations, and spreadsheets.)
If you’re still having trouble, you can follow these links:
(There's also a version of Outlook for the iPad called “OWA for iPad”; it appears to be Outlook Web Access with a simple software wrapper to turn it into an iPad app. It doesn't have the same kind of native look and feel that the new Office apps have, so we'll leave it out of this discussion.)

How To View Documents For Free

This is most of what can be done with an open document in the free version of Word for iPad.This is most of what can be done with an open document in the free version of Word for iPad.
The free version of Microsoft's Office apps only let you view documents. The first problem you’ll run into: How do you get those documents on your iPad?
There are two main options: email attachments, and Microsoft’s OneDrive service, an alternative to Dropbox or Google Drive that offers some free online storage.
  • If you have an Office document in your email, press and hold down on the attachment in Mail. You’ll get a dialog box that offers Microsoft Word, Excel, or PowerPoint as an option for reading the document. The app will store the file locally.
  • If you use Hotmail or Outlook.com for email, or play with Xbox Live, you already have a Microsoft account you can use to sign up for OneDrive. Otherwise, you'll need to create a new Microsoft account. Either way, you’ll get 7 gigabytes of free storage. If you move documents into your OneDrive on your desktop, you'll also have access to them within Office iPad apps.
Once you've gotten the file into the app, you can view it for free. 
Saving an uploaded Word document with the free version of Word for iPad.Saving an uploaded Word document with the free version of Word for iPad.
What you can't do unless you pay up: edit or share those documents.

Taking A Look Inside Word For iPad

Here’s more of what you can do without a paid subscription:
  • The Open menu is the workhorse. This is where you can add more OneDrive accounts or SharePoint Sites, if your workplace uses that software.
  • The Recent menu shows what documents have been accessed in the past. 
  • Once a document is open, the Home, Insert, Layout, Review, View and Picture menus are live, but all of the tools below them are grayed out. The only exceptions are under the Review and Home menus. Under the Review menu, you can press Show Markup for comments, insertions and deletions, formatting, revisions. Under the Home tab, the Show/Hide Paragraph button is live so you can see paragraph breaks.
  • Additionally, there are a few icons across the top of the screen above the ribbon. They include a familiar back button, a File icon that when pressed shows document properties, and a Help and Support section. AutoSave doesn't work, because you can't make changes to a document. Other options under the File menu are grayed out, too.
  • On the top right side, there is a search icon and a share icon, but only the search function is enabled. Sharing files via email or as a link is not enabled on the free version. 

What You Get When You Pay

To really get the benefit of Office for iPad, you need a subscription to Office 365. For home users, this costs $99.99 a year or $9.99 a month, which covers installing Office software on up to five PCs and five tablets. For business users, there’s a variety of pricing plans—but if your employer’s paying for it, you’re probably not too worried about those details. One immediate bonus: Your OneDrive storage gets bumped up by 20 gigabytes.
An Office 365 subscription unlocks most of the features you’d expect from the desktop versions of Microsoft Office.
  • Since we’re working in the cloud here, AutoSave is the order of the day. You can turn it off under the File menu in the upper left. For OneDrive documents, saving there is done automatically unless AutoSave is toggled off. When we are done with editing, we can go press the Back button in the upper left, and if AutoSave hasn’t captured the most recent changes, a dialog will appear indicating that it’s saving changes to OneDrive.
Using the toggle without a mouse is smoothly enabled here via touch on the iPad.Using the toggle without a mouse is smoothly enabled here via touch on the iPad.
  • You can now share documents too, with the Share menu at the top right. Choices under this menu are Email as Link, Email as Attachment and Copy Link. Email as Attachment doesn’t give the option of sending the document in view-only mode, but Email as Link does. Copy Link saves a shareable link the clipboard, for posting on social networks, sharing via instant messenger, or other uses.
One big option you won't find: printing. Unlike Google, which offers cloud-based printing services for Google Docs, Microsoft doesn’t have this feature yet. It's coming soon, the company says.

Digging Into Excel And PowerPoint

The other Office apps for iPad have similar file-management functions. But they have special features designed for editing spreadsheets and presentations on a tablet. Again, you'll need a paid subscription to Office 365 to enjoy these—otherwise the apps are view-only.
With a paid subscription, Excel for iPad has a special numeric keypad that includes formula buttons.
This fancy numeric keypad is only available on the iPad, and it’s actually quite necessary do to the limited screen size.
This fancy numeric keypad is only available on the iPad, and it’s actually quite necessary do to the limited screen size.
Creating new spreadsheets with the iPad is definitely easier with the numeric pad, and the formula button aids speedy calculations. Some features seem easier on the iPad version than on the desktop, like changing currency formats. One complaint: There's no way to scroll down beyond swiping, and that makes navigating large spreadsheets a bit unwieldy. There’s another possible fix for Microsoft in the near future.
The free PowerPoint version is likewise limited, but it's perfect if you just want to use your iPad to power a presentation. An icon on the upper right allows you to present. To use AirPlay, Apple’s built-in feature for sharing screens, you have to use Apple’s system menu that’s accessed by swiping up from the bottom of the screen. One improvement Microsoft could make: AirPlay support built directly into the app.
The paid version includes editing features and one really handy bonus: a laser-pointer effect that appears when you press and hold the screen for a long time.
This laser pointer is a nice touch (no pun intended) to PowerPoint for iPad.This laser pointer is a nice touch (no pun intended) to PowerPoint for iPad.

How To Upgrade To The Paid Version

There are two main ways to get an Office 365 subscription:
  • Inside the app as an in-app purchase, in which case you’ll use your iTunes login to buy a $99.99 annual subscription.
  • Online on office.microsoft.com, which allows you to choose the monthly $9.99 option or the $99.99 annual one.
Microsoft may prefer that you use the second option, since Apple gets a 30% cut of the purchase when you use iTunes to buy it. But buying your subscription online instead of inside the app is confusing, because the website prompts you to download Microsoft’s Office apps through the desktop version of iTunes. Since you've already downloaded the apps, skip this confusing step.
Microsoft’s website and its apps don't clearly explain this to you, but all you have to do to activate the paid features is log in with the Microsoft account you used to purchase your subscription, and the app will enable all the paid features. (If you have an Office 365 subscription through work, log in with the associated account your employer gave you.)
Once we logged in, the app recognized that we were now Office 365 subscribers. With our now fully capable Office apps in hand, we could begin sharing and editing documents across devices, in real time. That’s what makes Office for iPad most useful.
Is it worth the price? That's a question only you can answer, but we suspect it comes down to how much you use Office documents in your work and life already—and whether your workplace is already paying for it.


Cortana!!!!!! better than Apple Siri????

Friends again a tech news!!!!!!!!!!!!!!!


"Yay, it's Nick! How can I help?"

Thanks for asking, Cortana. And thanks for making the Windows phone software better, Microsoft.
With the new Cortana virtual assistant, Windows catches up with Apple's iOS and Google's Android in a major way. Microsoft takes some of the best parts of Apple's and Google's virtual assistants and adds a few useful tools of its own. The result is Cortana, named after an artificial intelligence character in Microsoft's "Halo" video games.
The new Windows system, Windows Phone 8.1, has several other new features, which I'll review separately later this week.
The update, including Cortana, will come with new phones starting next month, while existing phones will be able to download it for free in the coming months. On Monday, Microsoft made a preview version available to software developers. I was able to test that version over the past week.
Apple's Siri virtual assistant on iPhones and iPads has a feisty personality. She has good comebacks for such questions as, "What is the meaning of life?" She's also helpful with directions, restaurant recommendations and appointment reminders. Google Now on Android phones is boring by comparison, but better at anticipating your needs and giving you information before you even ask.
Cortana combines Siri's personality with Google Now's knack for anticipation.
Cortana also incorporates a feature for blocking calls, texts and notifications during times of your choosing, while letting you set exceptions for specific people or emergencies - defined as someone trying to call again within three minutes. That feature is separate on iPhones (though you can turn on Do Not Disturb, as it's called, via Siri or directly from its "Control Centre") and Samsung's Android phones. Cortana will also identify the name of songs heard in a retail store or bar, while you need separate apps such as SoundHound or Shazam on other phones (though the iPhone and iPad versions of Shazam can listen continuously in the background; that isn't yet in the Android version.)
Other differences include:
• Cortana asks rather than assumes
When you first use Cortana, she guides you through a brief questionnaire to gauge your interests. You can tap an icon on the top right to pull down a notebook and change your preferences.
Cortana also offers to scan your email for flights and other events to remind you about. Unlike Google Now, Cortana asks whether you'd like that flight tracked. Google Now does that automatically, and erroneously picks up itineraries that your travel companions send you. Also, Google Now works only with Gmail, while Cortana works with all major services except Yahoo, which Microsoft says it couldn't track because of Yahoo's terms of service.
Although Cortana avoids mistakes by asking, she requires slightly more work on your part. After asking Cortana about the latest Mets game, I had to tap a link to get future updates automatically. I didn't have to do anything with Google Now. But Google Now also assumes that just because I search for a company once, I want its stock quote every day.

Cortana shows you game scores - but might forget what you asked.
Cortana shows you game scores - but might forget what you asked. Photograph: AP

• Cortana lets you ask follow-up questions
After asking Cortana for Mexican restaurants, I asked for ones that are open and got my list narrowed. I then asked for the ones that are good. Cortana responded with the Mexican restaurants that are both open and have at least four stars on Yelp.
Siri and Google Now tend to treat each request as new (though asking Siri "Which are the good ones?" will re-sort them by rating rather than distance), though both will let you make reservations through OpenTable. Cortana tells you only that a place takes reservations.
• Cortana offers more ways to set reminders
Like Siri and Google Now, Cortana lets you set reminders based on the time or location. When you arrive at work, for instance, she can remind you to mail a package.
Unlike the others, Cortana also lets you set people-based reminders. Let's say your friend Mary just had a baby. You can ask Cortana to remind you to mention that the next time you call, text or email Mary.
Some of the interactions got frustrating until I manually added my work and home addresses to Cortana's notebook.
Me: "Remind me to turn off the stove when I get home."
Cortana: "All right, where should I remind you?"
Me: "Home."
Cortana: "OK, what should I remind you about?"
Me: "Turn off the stove."
Cortana: "When would you like to be reminded?"
Me: "When I get home."
Cortana: "Sure, remind you when you get to home. Is this the one you want?"
The suggestion wasn't for my home but "Home Restaurant."
Microsoft says Cortana will figure out where you work and live over time.

Beta, could be better

Cortana is still in a "beta" test mode, so these kinks are to be expected. It's fine for basic queries, though sometimes you have to ask a few times. In requesting directions, I sometimes got a simple web search for my destination address. But repeating the address then got me actual step-by-step directions.
I asked all three virtual assistants on Friday whether I needed an umbrella. Siri and Google Now both told me I didn't, based on the fact that it wasn't raining. Cortana answered, "I'm not entirely certain." All three then presented a forecast.
By Sunday, Cortana seemed to have figured out I didn't need an umbrella. But I asked the same question 10 minutes later and got web results for "Do I need an umbrella?"
Both Siri and Google gave me movie times when I asked, "When is 'Frozen' showing?" Clicking on a time took me to a ticketing service. Cortana simply conducted a web search.
Cortana warns me of conflicts when adding a calendar event, but the warning comes after the fact as a "by the way." Siri warns me ahead of time, while Google Now offers no warning at all.
Ask Cortana to "tell me a joke," and she tries to text "a joke" to my cellphone, or "Me" in the address book. Cortana also won't compose email. Siri and Google Now do both email and texts.
These are all small points that I'm sure Microsoft will address over time. The company plans to keep Cortana in beta and limited to the US until the second half of the year, when the assistant will also debut in the UK and China.
Perhaps by then, Microsoft will offer a male voice, as Apple now does with Siri. In the meantime, enjoy interacting with Cortana. You can ask her to sing a song.
Overall, Cortana's improvements over Siri and Google Now aren't enough to compel a switch from an iPhone or Android phone – but Cortana does address an omission in Windows Phone for those already thinking of getting one.

Reference - Guardian