Trainee Trader

In trading as in any other profession it is important to have the right tool for the right job. In our daily life as a trader we work with a large range of data that requires analysis. If you have done any kind of statistical or financial analysis I am sure you will be familiar with Microsoft Excel, however if you are just starting out Microsoft Excel may be less familiar to you.

Microsoft Excel is a powerful spreadsheet based application. The main window is comprised of rows and columns laid out in a grid format. This allows for easy entry and analysis of data. The version I use and would recommend is Microsoft Excel 2007. There are many new features in Excel 2007 these include: larger workbook capacity, completely overhauled user interface, simpler pivot table creation, easier third party data access and a stream lined workflow. The image below shows a screen shot of Excel 2007 in action.

As you can see Microsoft Excel 2007 has a remarkably different user interface to earlier versions of Excel and if you are used to working with previous versions of Excel it will take you a little while to adapt to the new way of doing things.

Microsoft Excel allows you to create your own formulas and apply them to data. Excel also has many built in functions that allow for manipulation of data and the ability to record macros to streamline processes. Before I go through the interface of Excel 2007 there are two key things that you need to do.

1. Install Add ins. (more…)

Popularity: 32% [?]