Finacial-Edu: Your Financial Knowledge Source RESIDENTIAL REAL ESTATE EXCEL MODEL
Accounting & Finance
Asset Management
Investment Tools
Project Management
- more
Guides & Courses
Excel & VBA
Trading & Investing
- more
Investing & Trading
Futures & Options
IRA + 401k
Quotes & Data
Real Estate & REITS
Software & Tools
- more
Investing & Trading Software
- more
Tools & Models
Forms & Templates
Graphing & Charting Tools
Risk & Portfolio Models
Trading Models
- more
Excel Level 3 Advanced + VBA Level 1 + VBA Level 2
Price : $ 49.95
Buy Now
Save on this 3-in-1 course package! Excel Level 3 Advanced plus VBA Level 1 plus VBA Level 2 for one low price!

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 30 lessons, each between 5 and 10 Word Document pages long, and 10 Workbook examples.

Excel Level 3 is for students and professionals with strong Microsoft ExcelŽ knowledge. Level 3 truly makes you a master of Excel, and provides you with the powerful knowledge and skills you need to do complex modeling, data management, advanced formulas, pivot tables, and much more! The course covers:

  • Advanced Formulas
  • Advanced Filters
  • Text To Columns
  • Importing Text Files
  • Pivot Tables (with online tutorial)
  • Scenarios
  • Goal Seek
  • Data Tables and Consolidation
  • Excel on the Web
  • VBA Macros 1 and 2
  • 5 Downloadable Workbook examples

    Excel VBA Level 1 is for Microsoft ExcelŽ users who want to automate their repetitive spreadsheet and analysis tasks, increase productivity, and enhance their analysis capabilities. VBA Level 1 teaches you the basics of Excel VBA programming (macros), how the code and code modules function, code syntax, real-life examples, and much more! The course covers:

  • Fundamentals of Excel VBA
  • The Visual Basic Editor
  • Objects and Properties
  • Excel Objects
  • Object Hierarchy
  • Application, Workbook
  • Worksheet, Range, CommandBars, Variables and Constants
  • Data types
  • Variable Levels
  • Declaring Variables
  • Loops, Types of Loops, Loop Pitfalls
  • Effective Decision Making
  • If/And/Or
  • Select Case
  • Dates and Times
  • Workbook and Worksheet Events
  • Debugging and Error Handling, Prevention, Good Habits
  • Runtime Errors
  • Excel Worksheet Functions in VBA
  • Specific Examples
  • Excel's Built-In Features
  • User Defined Functions
  • Good vs Bad
  • Arguments
  • Calculation
  • Controls
  • ActiveX
  • Control Toolbox, Control Properties, Control Parent
  • 5 Downloadable Workbook examples

    Excel VBA Level 2 is for Excel users familiar with the basics of Excel VBA who want to build fully automated trading and analysis models with user forms, data import/export, automated controls, and other "software like" features. The course covers:

  • UserForms Introduction
  • Filling UserForm Controls
  • Putting Data into your Controls
  • When to put Data into our Control
  • Filling a ListBox and/or ComboBox using Loops
  • Multi-Page Control
  • Creating a wizard using the Multi-Page Control
  • Validating the User Inputs
  • Some Useful Methods and Functions
  • When to apply Validation
  • Control Events
  • Which Controls to use and When
  • Parsing Control Values back to a Spreadsheet
  • Parsing range values to the UserForm Controls
  • Option Buttons and Checkboxes in Detail
  • True or False
  • Creating Template Controls
  • Using the RefEdit Control
  • Finding the Active Control
  • Creating Controls at Runtime
  • 5 Downloadable Workbook examples

    What you Get

  • Instant download of your Excel training
  • FREE Excel question support for LIFE!
  • Ask all/any Excel/VBA questions free in OzGrid's 24/7 Excel Help Forum
  • All Lessons Applicable to Excel 97-Excel 2003 and Windows 95 and Above!
  • 30 Day Money Back Guarantee on All Excel/VBA Training
    - 1 User License allows installation of the course on 2 Computers
    - Unlimited license allows installation of the course on an unlimited number of Computers, and/or Networks.
    - Resellers License allows you do what ever you like with the lessons, re-brand and re-sell. No Restrictions At All!
          -learn more  
    Excel Real Estate Model
    Home | Guides + Courses | Tools + Models | Articles Library | Site map
    Copyright 2000-2013 All rights reserved.