Category:Office Software Programming

From EIK wiki

Aim of this course

The course deals with programming in software packages Microsoft Office. The features of the programming language Visual Basic for Application (VBA) in spreadsheets on the basis of Excel are studied thoroughly. The course has an applied trend.


Books

Estonian

English

What we do?

Introduction

Recording and executing macros

VBA language

Simple VBA programming

Variables in VBA

Pratice

Conditional branching in VBA

Looping through code

Loop http://www.excel-vba-easy.com/vba-programming-excel-vba-loop.html

Building procedures and functions

Building User Interfaces

Homework

Homework2

Homework3

Please do all of them!

Homework4

Homework 5

  • Download a file: Osp_hw5.xls
  • Write a macro that would put all the Advanced level courses to a new sheet, which is named "Courses for IT Pros", and all Essential level courses to a new sheet, which is named "Courses for Information Workers". (If in the cell "Level" (A4, A5, A6, ...) is the value "Essential", then copy the row to "Courses for Information Workers" sheet and if there is a value "Advanced" then to "Courses for IT Pros" sheet). Finally, the advanced level courses should be all on "Courses for IT Pros" sheet and a essential level courses in "Courses for Information Workers" sheet.

Pages in category "Office Software Programming"

This category contains only the following page.