HUN

ENG



MS Excel automation by Visual Basic macros



How to automate our repetitive tasks with our tables to only 1 button-click? How can we do assignments which last even 1-2 hours within only 1-2 minutes? How to create our own new Excel formulas? How to extend the normal "skills" of Excel to a higher level?


Main topics:


Creating macros (absolute & relative) by recording

Creating macros by Visual Basic Editor

Total automation of our repetitive tasks (typing formulas, filtering, inserting/deleting columns-rows-worksheets etc.)

Automatically creating reports

Speeding up the navigation among different tables and charts

Extracting data from other worksheets or other files

Breaking apart Excel tables to separate files, merging together multiple Excel files

Automatic creation of folders and files

Creating our own new formulas (which do not exist in Excel)

Creating dialogue windows, communication with the user

Protecting the worksheets

Logging the activity of users

Calling sub-macros

Handling errors, own error messages

Running macros automatically, driven by events



Other parametres:

Timing: 2 days
No. of participants: 8-12
Laptops/PC-s required (1 or 2 participants per computer)
Languages available: Hungarian, English







As a manager, would you like to improve your colleagues' work efficiency to a Professional level?

The most efficient MS Excel, Outlook & PowerPoint tips in 1 time management training, with task & project management template files!






Automate your HR database easily!

  • It can be uploaded and implemented in a few weeks
  • Easy-to-use, requires only a brief user training
  • Faster data entry at "All-in-one" surfaces
  • Exportable reports, statistics by only 1 click
  • Short lead time to further develop


  • EASY E-HR®
    HR automation software



    © 2011
    HR TRAINING SOLUTIONS