MSMAK107 - Using Microsoft Office 2007 Macros
This course is assigned for Microsoft Office advanced users, who want to manage basic work with macros on user level.
Who the course is forThis course is assigned for Microsoft Office
advanced users.
What we teach youWe teach you, how to create macros on user level and
how to use Microsoft Office more effectively.
Required skillsMSWD3, MSEX3
Teaching methodsProfessional lecture with practical demonstrations and
examples.
Teaching materialsPublications according to an offer of publishing
companies.
Course syllabus
Macro and programming in MS Office
- Record vs. programming macro
Recording macro
- Relative vs. absolute record in Excel
- Exhibits macro
Possibilities starting macro
- Keyboard shortcut
- Button on sheet Excelu, in Word documents
- Button on toolbar
- Creating personal panel tool
- Interface panel tool to book
Adjustment recorded macro
- Introduce to environment editor VBA
- Basic terminology VBA
- Orientation in recorded code
- Removal redundant command, which originate record macro
- Embranchment (conditions)
Creation personal function in Excelu
Interaction with user
- Production declarative windows – MsgBox
- Production windows for set funds – InputBox
- Entry funds gained from user to the cell leaf, to the document
Possibilities treatment mistakes
- Finish macro in the event of runtime mistakes
- Supplying system bug news personal bug report
Sharing macro for more user
- Personal book makro (set PERSONALXLS resp. screen NORMALDOT)
- Component for automatic opening set at initiation Excelu
Problems (no)safeness macro
Recommended prior courses
MSEX307 - Microsoft Excel 2007 – Advanced Methods and Functions
MSWD307 - Microsoft Word 2007 – Advanced Techniques
Recommended subsequent courses
MOC 1303 - Mastering Microsoft Visual Basic 6 Fundamentals
PRG - Programming and Algorithmization Basics
Catalog price of course and handbook
| Praha |
7000 Kč
|
--
|
0 items
|
| Brno |
6200 Kč
|
--
|
0 items
|
Course dates
|
