Microsoft Excel is a widely used spreadsheet program. Microsoft Excel is often used to analyse stock data, futures data and general economic data. Excel is used by professionals and amateurs alike and provides relatively low cost analysis software. The following articles will help you get the most out of Excel and be able to carry out basic analysis tasks.
Microsoft Excel Tutorials
- An Introduction to Microsoft Excel 2007.
- The basic’s data entry and navigation.
- Importing Market Data from Yahoo Finance.
- The basic’s of charting market data the line chart.
- The basics of charting market data the bar chart.
- The basics of charting market data the candlestick chart.
- Importing stock quotes with the SMF addin.
- TraderXL Pro Package – DownloaderXL
- TraderXL Pro Package – AnalyzerXL
- TraderXL Pro Package – BulkQuotesXL
- TraderXL Pro Package – RTQuotesXL
- TraderXL Pro Package – PortfolioXL
- TraderXL Pro Package – BacktestingXL
- TraderXL Pro Package – PredictorXL
Microsoft Excel Quick Tips
- How to name cells to simplify formulas.
- Excel quick-tips working with time series data.
- Excel quick-tips howto remove weekends from time-series data.
- Excel quick-tips howto enable the developer toolbar in Excel.
- Excel quick-tips howto absolute-cell references in formulas.
- Excel quick-tips howto make use of the today function.
- Excel quick-tips howto dynamically change column row width.
- Excel Quick Tips HOWTO Use Format Painter to format Cells
