Du er her: Søg IT kursus /
Excel 2007-2010 Basic VBA Programming (conducted in English), 4D Konsulenterne
Excel 2007-2010 Basic VBA Programming (conducted in English)
|
Kursusinfo
|
|
|||||||||||||
Excel 2007-2010 Basic VBA Programming (conducted in English)
Kursusmål
You will become familiar with the basic programming principles in the Visual Basic for Applications programming language, including the scope for managing the spreadsheet process by applying your own programme routines. This course is also relevant for you, if you are working with Excel as a part of Office 365.
Deltagere
The course is for experienced Excel users wishing to gain some basic knowledge and scope provided by the Visual Basic for Applications programming language, which will enable you to design programme modules for automation and specialisation of Excel.
Kursusmateriale
The course optimises your benefits by alternating between theory, in-depth questions and practical exercises. These exercises will be supported by the carefully refined course material designed by 4D Konsulenterne A/S especially for this course. To maintain and develop your Excel competence, we recommend that you use the course materials supplied as an efficient reference source after the course. And if you encounter further challenges, you are always welcome to contact our instructors to discuss more detailed questions, etc.
Kursus indhold
Recording Macros
In this module is shown basic recording of macros. What to be aware about before recording and when recording is a big benefit.
- Relative/Absolute Recording
- Where are Macros Saved?
Introduction to Ribbon, Toolbars and Icons
In this module you will learn to create shortcuts for easy access of your macros.
- Creating Macro Shortcuts
The Visual Basic Editor
In this module you will learn to create subs and make settings for the VBA editor. And you will learn some tricks when entering code using intelligence for the different objects.
- Creating Procedures
- Views
- Options
- Using the Help Function
Variables and Data Types
In this module you will learn about dimensioning variables using different data types. Where can the different variables be accessed from and what is the lifetime of a variable.
- Declaring Variables
- Local Variables
- Module Variables
- Global Variables
- Constants
- Object Variables
- Converting Variables
- Naming Conventions
Simple Dialogues
In this module you will learn about the most common dialogues for communication with the user. I could be from a simple message to the user to receiving an input.
- The MsgBox Command
- The InputBox Function
- MsgBox Functions
Control Structures
In this module you will learn about conditional structures, which is a comparison of values, which result in one or another direction of the code. Which lines of code should run now? Often are the lines of code to be executed are the same again and again, and for this you would use a loop structure. A loop structure could run through a lot of rows, cells, or sheets.
- Statements (If-Then-Else and Select Case)
- Loops (Do-Loop, Do-While and For-Next)
Splitting Codes Into Sub-Routines
In this module we illustrate the ability to reuse code. This can be done by placing the code in a Sub, as this can be called multiple times. In order to make these calls more versatile you can pass arguments to the Sub and these arguments can be used for calculations or getting the Sub to respond to the input.
- Calling a Sub from Another Sub-Routine
- Calling a Sub from Another Sub-routine With Arguments
Formulas
In this module, you can try out a lot of the most commonly used controls on a Userform. You’ll be told the main purpose for Userforms and how to use events on controls- and Userform.
- Designing Your Own Dialogues with Labels, Text Boxes, Combo Boxes, Check Boxes, etc.
- Scope of Application
- Using events
The Most Essential Excel Objects
In this module, you’ll get your hands on the most commonly used objects, which Excel offers. The individual objects that you have to learn to code up against, have a lot of methods and properties, which are the challenge to control.
- Application
- Workbook , ActiveWorkbook , ThisWorkbook
- Worksheet, ActiveSheet
- Range
- Select
- Address
- Offset
- Cells, Rows, Columns
Events for the Excel File
In this module we put focus on the automatic events which occur, when you for example open or close a work book, activate a worksheet or click on or change a value for a cell.
- Workbook_Open
- Workbook_Deactivate
- Workbook_Activate
- Worksheet_Activate
Functions
In this module you will learn how to create your own functions. Excel offers a lot of functions, but you can relatively easily create your own and apply them in your worksheet or in the VBA environment.
- Declaring Functions
- Applying Functions in the Excel Spreadsheet
Arrays
In this module you are introduced to a multidimensional variable also called an Array. It will be explained why you might want to use this structure of a variable.
- Declaring Arrays
- Applying Arrays
Simple Error Management
In this module you get explained what you put up with code that potentially can crash. You do not want to the end user of your macros to end inside the Visual Basic environment with a mysterious error message. This you will be able to manage.
- The Error Object
Spar helt op til 40% med et:
4D Klippekort:http://www.4d.dk/Priser/Klippekort/Pages/klippekort.aspx
Vi har mange Excel kompetencer - se alle vores::
Excel ydelser:http://www.4d.dk/Produkter/Office/Excel
Er I flere - skræddersy kurset med eksempler fra jeres hverdag:
Læs mere om firmakurser:http://www.4d.dk/kursus/kursustyper/Pages/kursus_typer.aspx
Målgruppe
Excel 2007-2010 Advanced (conducted in English)
Excel 2007-2010 Experienced (conducted in English)
Pris
4D Konsulenterne
Microsoft kurser og certificeringer
4D Konsulenterne er eksperter i IT kurser og Microsoft certificeringer. Mere end 7000 tilfredse kursister om året, nyder godt af vores gennemarbejdede kursusmaterialer og højt kvalificerede undervisere. Både 2008 og 2009 er 4D kåret af Microsoft som Årets Learning Partner. Noget vi er meget stolte af.
Som Danmarks største udbyder af Office kurser, finder du altid mange dato at vælge imellem.
Teknisk træning - som Microsoft Gold Partner leverer vi MCP kurser, specielle Certificeringsforløb og Microsoft Partner uddannelse.
Vores instruktører er blandt Danmarks højest certificerede og løser også konsulentopgaver.
Se opdateret kursuskatalog nedenfor, hvor du finder kursusdatoer og kan læse mere om indholdet på kurserne.
Du er altid velkommen til at kontakte os for at få mere at vide om kursustyper, metoder, priser og få sparring på uddannelse, der dækker præcist dit - eller jeres firmas - behov.
Køb flere kurser - Klippekort
Har du brug for en rabatordning, der tilbyder maksimal fleksibilitet, er et klippekort fra 4D Konsulenterne en god løsning. Klippekortet kan bruges af alle medarbejdere i virksomheden.
» Få mere information – helt uforpligtende!
Udfyld en interesseforespørgsel nederst på denne side.
Vis alle uddannelser afholdt hos
4D Konsulenterne
Forespørgsel efter information
Kontaktinformation til 4D Konsulenterne
Telefon: +45 3314 7144 
Bestil information
For at bestille information om Excel 2007-2010 Basic VBA Programming (conducted in English), venligst indtast følgende oplysninger:
Giv din anmeldelse
