# Make Informed Decisions On The Go With Excel Mobile 2010

In our previous post entitled “Mobility in Office 2010” we briefly described the office applications available on your phone that would keep you productive on the go. In this post we will deep dive into Excel Mobile 2010, which supports over 100 of the formula functions available in Microsoft Excel 2010. In addition, its support for creating and displaying all of the common chart types brings the visual experience on the phone closer to that on the desktop. In this post, we will see how Excel Mobile 2010 can be used to perform what-if analysis on the phone to solve business or money related personal problems. We will also have a sneak peek into new gesture support in Office Mobile 2010 for touch devices.

### Performing a What-If Analysis

#### What discount should I negotiate for?

Imagine you are a procurement manager with a car sales company. While you are on your way to office you receive a phone call informing you of the availability of a sample of the new car model which is hitting the show rooms next month. You plan to check out the car model before reaching the office and also to negotiate with the distributor on the discount to meet your profit target numbers. Assuming your discount percent is a function of quantity, you want to find out the optimum quantity of cars to purchase and the discount that you should obtain from the distributor so you meet your target profit numbers.

When you open the Excel spreadsheet your company uses to analyze costs on your phone, it looks something like shown below -- with space laid out to fill in the details like manufacturer’s name, car model, cost price, discount, selling price, quantity etc.

When you double tap the content you’re interested in, the sheet zooms in to a readable view (shown below) where you can easily edit your content (and you can adjust the zoom level further from View Menu | Zoom).

As soon as you fill in the discount and quantity details the profit gets calculated from the formula embedded in the sheet in the tabular format as shown below.

If your target profit percentage was a minimum of 10% then by simply looking at the table you would now know that you need to purchase somewhere between 180 to 210 cars and look for a discount not less than 6%. You can now simply change the quantity to see the numbers changing and optimize your figures accordingly. You could also create a chart out of the data shown in the table above to visually see the impact of changes you make on profit%.

#### What else…

This scenario was specific to business users but it shows that Excel Mobile 2010 can be used to solve many day-to-day problems ranging from keeping a personal budget, comparing auto lease options, maintaining your travel expenditures, to just using it as a smart calculator.