Finacial-Edu: Your Financial Knowledge Source
 
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 Level 3 Advanced + VBA Level 1
Price : $ 39.95
 
Buy Now
 
Save on this 2-in-1 course package! Excel Level 3 Advanced plus VBA Level 1 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 20 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

    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.