Sunday, April 15, 2012

Where Is Microsoft Excel Used?

Whether you work at an accounting firm, a marketing company, an auto dealership, a school attendance office, a manufacturing plant's human resources department, or an office connected with city, county, state or federal government, chances are, you'll be called upon to use and learn Excel.

Just about every workplace has a ask for Excel, the computing world's most generally used software agenda for comparative data analysis. Excel has been ready in various incarnations for more than a decade. Each subsequent publish takes the agenda to new territory.

Computer Mouse Features

Popularly known as the best spreadsheet agenda on the market, Excel is powerful, easy to use, and remarkably efficient. Excel is highly interactive. Its spreadsheet cells are arranged in a variety of rows and columns, each of which can hold a number, a text string, or a method that performs a function, such as calculation. It's easy to copy and move cells as well as modify formulas. The spreadsheet is displayed on the computer screen in a scrollable window that allows the document to be as deep or as wide as required.

Where Is Microsoft Excel Used?

Working for a major newspaper in Northern California, I was one of several reporters complicated in the each year evaluation of our county's economy. The job complicated collecting data that would be punched into Excel spreadsheets that ultimately ranked facts agreeing to the category of statistics being reviewed.

The beauty of Excel, from the standpoint of newspaper research projects, is that you can use formulas to recalculate results by changing any of the cells they use. With this model, you can use the same spreadsheet data to accomplish various results by simply defining and changing formulas as desired. It is this feature that makes Excel so useful in so many dissimilar arenas.

With a click of the mouse, we reporters were able to get answers to a wide variety of questions. Which employers had the most whole of workers? Which ones had the highest whole of gross each year receipts? Which ones appeared to be growing and which ones had declining sales? What was the volume of real estate loans and had there been a decline or increase from the old year?

We looked at local and national retail, services, financial institutions, government entities, agriculture, the wine industry, tourism and hospitality, manufacturing, residential and market real estate, everything imaginable.

Excel allowed us to observe ratios, percentages, and anything else we wanted to scrutinize. Finally, we were able to use Excel to collate the results to data from old years.

Since reporters tend to be old English majors, most of those who worked on this each year task were more familiar with Microsoft Word than any other software program. Therefore, most were required to feel Excel training. For some, studying Excel was easier than for others. A few relied on guides such as Microsoft Excel Bible. Some reporters underwent an Excel tutorial while others learned by doing.

Not only were the Excel spreadsheets crucial to the research, the format of each was published in the newspaper. Here is where some further Excel functions came into play. Editors were able to make the spreadsheets more visually spicy by using colors and shading, borders and lines, and other features that made the spreadsheets easy for readers to decipher.

Wearing an additional one of my several hats in the newsroom, I often wrote articles about the local job market. I found proficiency in Excel was a requirement for a wide variety of employment positions and that area recruiting firms offered their clients opportunities to take free or low-cost Excel tutorials in establishment for the workplace. Most employers expect job candidates to already know the software that the work will need and don't want to have to train new hires.

Don't kid yourself. If you're seeking any kind of office work, you'll need to know not only Microsoft Word but also Excel.

Excel and Microsoft are trademarks of Microsoft Corporation, registered in the U.S. And other countries.

Where Is Microsoft Excel Used?

New Computer - Old Email, or How to Back up and exchange Your Email

If you have a brand new computer, or are reasoning about buying one in the near future, one of the things that you will need to reconsider is how to change your emails from the old theory to the new system.

At least once a week in my job as a help desk analyst, I am helping a buyer set up Outlook Express or Outlook (there are other email clients that are used, but these two are the most popular) on their new computer. Once we are terminated with the setup and they open it up to the Inbox the ask is asked "where are my old emails?" The uncomplicated answer; "on your old computer". Then of policy the follow up ask is; "how do I get them to the new computer?"

Computer Mouse Features

Easy or Hard

New Computer - Old Email, or How to Back up and exchange Your Email

The easiest way to do this is to back them up to an external hard drive or a compact disc before you make the switch to the new computer and then copy them over to the new computer in the exact same directory. The harder way is in the case of a crashed computer or the inability to access the files normally. I cover a bit of that in other article called 'Got Backups?' which you can find at my website.

Outlook Express

With Outlook Express your emails/email folders are stored on your hard drive in a directory that is buried way down deep in the Operating System. Instead of me giving you the full path to get there, it's easiest if you have Outlook Express open, click on Tools then Options.

Copy/Paste

Once you are here, click on the Maintenance tab and then click on the Store portfolio button. This will pop other window with the location of your emails. Using your mouse, highlight the path and then right click and copy it.

You will then click on the Start button, then click Run, and then right click in the Open box and Paste the path. Click Ok.

This will open other window with your email files. Unless you have added other folders to your Outlook Express, the default folders will be here with a .dbx postponement (Folders, Inbox, Sent Items, Deleted Items, and Drafts).

Backup

If you are going to write these files to a Cd, you can burn them at this time by using your favorite burning software (providing that you have a Cd burner installed in your computer).

To copy them to an external hard drive, you must now associate that expedient to your computer, originate a portfolio on that drive (I usually call it Email Backups), copy the files from the old computer then paste the files into the Email Backups folder.

Import

Once you have the files copied to the Cd or external drive, then you will go to the new installation of Outlook Express and import the messages. It would be nice if you could just copy them to the new Oe and be done, but Microsoft doesn't like you to do it that way.

Open up Oe and then click on File, Import, Messages. This will open a new window called Outlook Express Import. Select Microsoft Outlook Express 6 then click Next. Click in the circle that says 'Import mail from an Oe6 store directory'. Click Ok. Then click 'Browse' and navigate to and elect the directory you have saved them to. Click Ok. The next window will give you a list of all of the email folders you have previously saved. Keep 'All folders' superior and click Next.

This will begin the process of importing all of your 'old' emails into your 'new' Outlook Express. Once it has terminated you will have all of your old emails back! Cool, huh?

Outlook

The policy to save and then import your emails in Outlook is similar, but different.

To start with, Outlook uses a file postponement called pst, or Personal portfolio File. Don't ask me why it's called that. Call Bill Gates and ask him.

Export

You will start on the old computer and with Outlook open, click on File, then 'Import and Export'. This opens the Import and Export Wizard. Select 'Export to a file' then click Next. Select 'Personal portfolio File' here and then click Next. In the Export Personal Folders dialogue box you have your option of what you want to do. The easiest is to keep the default option of just the inbox, but if you want your sent items and all the other folders, Select the top item (Personal Folders) and then Select the 'Include subfolders' option and then click Next.

The next window will have a default location listed
(usually C:Documents and Settings'your computer name'Local SettingsApplication DataMicrosoftOutlookbackup.pst). I would suggest following the same policy as for Oe (see above). Then click 'Finish' and let it do it's thing.
Once you have your pst files backed up, move to the new computer and the import process will again be similar to Oe.

Connect your external hard drive to your computer or insert the Cd into the drive.

Import

Open Outlook, click on File, then Import and Export. In the Import and Export Wizard, this time Select 'Import from other schedule or file' then click Next. In the 'Import a File' window, scroll down and elect Personal portfolio File (.pst) and then click Next.

In the 'Import Personal Folders' window, click the Browse button and navigate out to the location of your backed up pst file, Select it and then click Next. Click 'Finish' and it will import all of your messages.

New Computer - Old Email, or How to Back up and exchange Your Email