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 1 Basic + Level 2 Intermediate + Level 3 Advanced
Price : $ 49.95
 
Buy Now
 
Save on this 3-in-1 course package! Level 1 Basic plus Level 2 Intermediate plus Level 3 Advanced 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.

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

    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.