Finacial-Edu: Your Financial Knowledge Source RESIDENTIAL REAL ESTATE EXCEL MODEL
 
Business
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
Software
Investing & Trading Software
Spreadsheets
- more
Tools & Models
Calculators
Forms & Templates
Graphing & Charting Tools
Risk & Portfolio Models
Trading Models
- more
 
 
Excel plus VBA Complete Course Collection
Price : $ 59.95
 
Buy Now
Click here to view Screenshot image
 
Save on this all-in-one course package! Excel Levels 1,2 and 3 PLUS VBA Levels 1 and 2 all in 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 50 lessons, each between 5 and 10 Word Document pages long, and 10 Workbook examples.

Course Outlines:

Excel Level 1 Basic is for students and professionals new to Microsoft ExcelŽ. Level 1 focuses on core Excel skills you will need to perform everyday functions in finance, marketing, analysis, and administration. The course covers:

  • The Fundamentals of Excel
  • Cut, Copy, Insert, Delete, Paste Special
  • Custom Formatting
  • Undo, Redo
  • Excel Formulas - Basic
  • Useful functions and Paste Function
  • Calc
  • Comments
  • Drawing toolbar
  • Edit, Replace, Delete, Clear
  • Essential Printing
  • Data Sorting, Hiding
  • AutoFormats
  • Protection
  • Basic Charts
  • Basic Formatting
  • If Function

    Excel Level 2 Intermediate is for students and professionals with 1-3 years of Microsoft ExcelŽ experience. Level 2 advances your core Excel skills, dramatically enabling you to perform advanced analysis, formulas, data capture, charts, graphs, and presentations necessary for today's complex business and academic environment. The course covers:

  • Worksheet Formulas
  • Specific Worksheet Formulas
  • Extract Data and Decision Making
  • Data Validation and External References
  • Advanced Filters and AutoFilters
  • Range Names
  • Charts
  • Under-Utilised Features
  • Protection
  • Shared Workbooks and Merging Shared Workbooks
  • Track Changes
  • Custom Views
  • Report Manager
  • Hyperlinks
  • Outlining

    Excel Level 3 Advanced 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
  • 3 LICENSE OPTIONS (SPECIFY IN THE ORDER FORM):
    - 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!
  •      
         
       
       
    RESIDENTIAL REAL ESTATE EXCEL MODEL
    RESIDENTIAL REAL ESTATE EXCEL MODEL
          -learn more  
     
     
    Excel Real Estate Model
     
    Home | Guides + Courses | Tools + Models | Articles Library | Site map
    Copyright 2000-2013 Financial-edu.com. All rights reserved.