PoÄŤĂ­taÄŤová škola GOPAS  

Gopas CZ 
Gopas SK 
   
     Site map · Advanced search 
Offer of courses » Programming » Microsoft Office programming » Microsoft Excel – Application Development
Offer of courses » Programming » Microsoft Visual Studio 6.0 » Microsoft Excel – Application Development


   print

MSEX4 - Microsoft Excel – Application Development

Course participants will learn about writing macros to automate and facilitate work in Microsoft Excel. Course participants are required to know about programming in Microsoft Visual Basic (viz. recommended prior courses).

Who the course is for

The course is intended for experienced spreadsheet users skilled in the fundamentals of Visual Basic who want to learn how to write macros and programmes to automate processes in Microsoft Excel.

What we teach you

Course participants learn how to work with MS Excel’s object model, how to use fundamental objects like Workbook, Worksheet and Range. During the course, participants will be shown and will try out many useful macros to facilitate work in MS Excel.

Required skills

Knowledge of working in Microsoft Excel and fundamentals of programming in Visual Basic.

Teaching methods

Expert instruction with practical examples, computer practice

Teaching materials

Expert instruction with practical examples, computer practice

Course syllabus

Introduction to macros

  • Fundamental concepts
  • Recording and programming macros
  • Examples
  • Running macros with keyboard shortcuts, buttons and command menus

Fundamental concepts of Visual Basic for Applications

  • Variables and data types
  • Control commands
  • Functions and procedures
  • Handling errors in macros

Excel object model

  • Basic characteristics of objects
  • Properties, methods and events
  • Object browser
  • Collections

Range object

  • Working with cells
  • Values and formulas

Worksheet object

  • Working with sheets

Workbook object

    Application object

    • Basic features
    • How to change how Excel behaves

    Dialog boxes

    • Designing dialog boxes
    • Programmatic handling
    • Controls

    Implementing new objects using VBA (class module)

    Modifying the Excel work environment

    Programmatic creation of toolbars and working with toolbars

    Creating practically useful macros

    Recommended prior courses

    PRG - Programming and Algorithmization Basics
    MOC 1303 - Mastering Microsoft Visual Basic 6 Fundamentals
    MSEX1 - Microsoft Excel 2003 – Basic Course
    MSEX2 - Microsoft Excel 2003 – In Practice
    MSEX3 - Microsoft Excel 2003 – Advanced Methods and Functions

    Recommended subsequent courses

    MSAC2a - Microsoft Access – Application Development
    MSWD4 - Microsoft Word – Application Development
    MOC 1013 - Mastering Microsoft Visual Basic 6 Development
    GOC301 - Introduction to Microsoft Visual Basic .NET Programming
    GOC330 - Developing Microsoft ASP.NET Web Applications I
    REGEXP - Regular Expressions

    Catalog price of course and handbook

    Locality Course price ex VAT Price of handbook ex VAT Number IT points
     Praha   14000 Kč  --   40 items
     Brno   13200 Kč  --   40 items

    Course dates

    Course date Course length Locality Price ex VAT Handbook ex VAT  Speaker language  
     19.10.2010   4   GOPAS Praha   14000 Kč included in course price Course Guaranteed course date
     10.01.2011   4   GOPAS Praha   14000 Kč included in course price Course Guaranteed course date
     14.03.2011   4   GOPAS Brno   13200 Kč included in course price Course
     28.09.2010   4   GOPAS Bratislava   480 EUR included in course price Course Guaranteed course date

    If none of the offered dates suits you, please contact our customer service department on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).