Complete Excel VBA Course COMPLETE EXCEL & VBA COURSE These lessons have been written by OzGrid Business Applications who develop Excel spreadsheets on a professional basis. Each lesson is drawn from 'real world' experience and not made up class room scenarios. There are 50 lessons each between 5 and 10 Word Document pages long and 25 Workbook examples. There is also an online Microsoft Pivot Table tutorial.
EXCEL LEVELS 1 2 AND 3 OUTLINE
The Fundamentals of Excel Cut Copy Insert Delete Paste Spec ....MORE
These lessons have been written by OzGrid Business Applications who develop Excel spreadsheets on a professional basis. All information within these lessons are drawn from 'real world' experience and not fictitious class room scenarios. There are five Workbook examples with the 20 lessons. Each lessson is between 5 and 10 Word Document pages long. There are also 10 Excel Workbook Examples.
Lesson 10 has Time Saving Microsoft Excel Solutio ....MORE
Build an Automated Spread Trading System in Excel This online course shows you step-by-step how to build and utilize an automated spread trading model using Microsoft Excel. The System captures the price difference between security pairs of any type -- indexes stocks futures options LEAPs etc. Spread returns are typically non-correlated with other investment and trading strategies making the model an excellent addition to an overall asset management strategy. The System uses three proven technical indicators--exponential moving averages ....MORE
Build an Automated Sector Fund System in Excel This online course walks you step-by-step through building a long term sector fund rotation model using Microsoft Excel. Microsoft's Visual Basic (VBA) language is used in conjunction with Excel's user interface formulas and calculation capabilities to deliver a powerful and flexible investment tool. The System is based on the classic market economist's Sector Rotation Model providing several crucial improvements that eliminate the guesswork in timing fund switches. The automated model incor ....MORE
Build an Automated Stock Trading System in Excel This online course shows you step-by-step how to build a sophisticated automated stock trading model using Microsoft Excel. Microsoft's Visual Basic (VBA) language is used in conjunction with Excel's user interface formulas and calculation capabilities to deliver a powerful and flexible trading tool. The Model includes five proven technical indicators (ADX moving average crossovers stochastics Bollinger bands and DMI). You are guided in a detailed fashion through creating worksheets files ....MORE
Excel 2007 2010 and Microsoft Analysis Services cubes< li> < ul>then this is for you.
You love the slice dice pivot and drill of PivotTables but you are frustrated that you can't insert rows or columns and put stuff exactly where you want. You want to build reports that are dynamically linked to but separated from your data the way it sh ....MORE
