Working with macros in Excel

Friday
22 November 2019
Villermontstraat 9
Kontich
09:00 - 17:00
EN NL FR

Tailor-made training

You rather have a tailor-made training based on this course? Contact us and we will make it work.
 
 

Description

In this training, you'll get familiar with insert macros of Excel, like Solver, Goal Seek, the display management, scenario management, and a lot more. You'll also learn to record, to simplement and to connect simple macros to buttons or menus. 

Contents

Using insert macros in Excel to manage formulae and functions

  • Working with the scenario management to display results of functions according to the change of a few parameters
  • Using Goal Seek for comparissons with one unknown
  • Using the data table to display the results of comparissons with two variables 
  • Using Solver for comparissons with more unknowns and parametered criteria 

Automatizing the import of (external) data

  • Importing .csv or other text files with the text wizard
  • Taking out the doubles in a database
  • Converting assembled texts to separate collumns

Display and print automatizations 

  • Working with display management to save complex displays
  • Working with prints of reports (2003) to save and print complex reports

Recording and managing own macros

  • Recording and implementing own macros
  • When to use a macro with/without related references
  • Assigning a button or menu position (2003) to a macro
  • Making a macro available in one file, or in general in Excel
  • Viewing the VBA code of a macro and implementing simple extensions 

Target audience

Each advanced Excel user who wants to automatize parts of his Excel task. 

Prerequisites

Advanced users who already have sufficient experience with the normal functions in Excel.

Duration

1 day

Prix par participant

360 EUR

E-Learning

60 EUR
Tailor-made training
Iedere organisatie werkt op een andere manier en geen enkele werknemer is hetzelfde. Wij bieden al onze opleidingen ook op maat van jouw organisatie.
Continue reading