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.
- Install Add ins.
- Enable the developer toolbar.
Install Add-Ins
It is easiest to install add ins at the time you install Microsoft Excel, this can be done quite simply by selecting a custom install and then selecting the desired add-ins as shown below:

After the add-ins are installed they will then need to be enabled. This can be achieved by clicking on the Office button -> Excel Options -> Add-Ins -> Manage Add-Ins then click the Go button. This will open a window were you can select an Add-In to enable.
Enabling the Developer Toolbar
In order to record/run macros and write Visual Basic for spreadsheets you need to ensure the developer toolbar is enabled, which is not the case by default. To enable the developer toolbar simply click on the Office button -> Excel Options -> click checkbox “Show developer tab in the ribbon”.
The ribbon and Office Button
In Excel 2007 the ribbon and the Office button are the most notable graphic changes in Excel 2007. The office button is the circle in the top left hand corner of the screen and stores all non document tasks in the one spot, these include Open, Close, Print, Prepare Send and Exit Excel.
The Ribbon is a replacement for the menu bar it extends across the whole top area of the window. New users will quickly learn how to carry out tasks using the ribbon however users migrating from previous versions of Excel may find themselves frustrated looking around for commands. The ribbon is Broken up into a number of tabs these tabs are highlighted below:
Home Tab
Under this tab most of the editing and formatting is carried out.
Insert Tab
Under this tab inserting different elements into your spreadsheets is carried out.
Page Layout Tab
Under this tab page layout elements can be modified to establish the look and feel of the spreadsheets.
Formulas Tab
Under the formulas tab you can apply built-in or user defined formulas to your spreadsheet as well as controlling the naming of cells and data integrity.
Data Tab
The data tab allows for the importing/exporting of data from multiple data sources as well as sorting and filtering and data validation.
Review Tab
The review tab allows for reviewing the spreadsheets spelling, translation and workbook sharing.
View Tab
The view tab allows you to customize the way the document is viewed on screen.
Developer Tab
The developer Tab allows for Macro recording and code editing.
This has been a quick introduction to Excel 2007, in further posts I will be going through how to best use this application for trading purposes and covering some more advanced topics.

Share This