Tag Archives: Excel Web App

how to use goal seek in excel

How to Use Goal Seek in Excel

Excel has proven itself to be very useful in various situations over and over again. The list of Excel’s benefits seems to be never-ending.

It even has a tool for answering questions and forecasting information. The Goal Seek function in Excel is a great tool for those asking “What if” type questions.

Use this guide to learn how to use goal seek in excel as well as how to put it into action.

Why Use Goal Seek?

why_use_goal_seek_

 

The Goal Seek feature in Excel is basically used to create formulasIt provides information on cause and effect situations.

It … Read the rest

Convert Coordinates for Your GPS with Excel

A few years ago I found myself just south of Paris, France one Sunday with a car and the inclination to do some sight-seeing. Since I was alone and don’t speak French my saving grace was Google Earth and a Tom Tom GPS navigation device.

Tom Tom allows GPS coordinates to be entered as a destination, but Google Earth lists those coordinates in a different format. In researching this article I found out that GPS coordinates can be presented in at least four different formats, making it difficult to understand the coordinates.

Google Maps view of the Eiffel

Read the rest

Excel 2011 for Mac – Installation, Preferences, and VBA

After reading all the great things about Microsoft Excel for Mac 2011 that were written before its release, I decided to purchase a copy. My primary goal was to have an Excel version on my MacBook Pro that allowed VBA macros, however the full Office software suite seemed to be a really great value.

I paid $174.99 USD for the Microsoft Office for Mac Home and Business 2011 – 1 Pack edition on amazon.com after pre-ordering and receiving a $25 discount from their price assurance guarantee.

Excel 2011 Software Installation

What you get with the Office 2011 Home and Business … Read the rest

Excel on the Web – Another Spreadsheet in the Cloud

I decided to test the new Microsoft Excel Web App and tell you about my experience in creating a simple spreadsheet, give you a look at the interface, and share my initial opinion.

The Excel Web App – Getting Started

In order to use the Microsoft Excel Web App a Windows Live account is required. It’s relatively easy to sign up for an account and you get 25 GB of storage on a Sky Drive. You also get access to the rest of the Office Web Apps: Word, PowerPoint and OneNote.

Excel Web App vs Google Docs Spreadsheet

The … Read the rest