Traning

Repetitive tasks can be partially or even fully automated by, for example, using intelligent Excel formulas or macros. This ensures that you have more time for other activities and minimizes the chance of errors. For analytical work with BigData, a lot can be achieved with the help of Microsoft Access or Phyton. We often receive feedback from students that following one of our training courses makes them feel more confident at work. Moreover, there are many students who, after following one or more of our training courses, become specialists at work and add a lot of value by making and presenting analyzes or, for example, by developing a dashboard with KPIs.

The training sessions last 1 day and can take place both online and at a physical location.

Specific information about each training can be found below.

Microsoft Excel Basic  

This 1-day training is suitable for novice users of Excel who would like to master the basic functionalities of Excel. The training is given in groups both online and on location. 

The training consists of the following parts 

  • User Interface Excel 
  • Create, open, and insert workbooks 
  • Fill in data 
  • Copying and pasting of data (transpose, formatting, formulas etc.) 
  • Using operators such as addition, subtraction, multiplication and division 
  • Entering formulas 
  • Autosum function 
  • References in formulas 
  • Inserting and Deleting Rows and Columns 
  • Formatting cells, cell properties for text and numbers (date, currency and number) 
  • Create and format charts and change chart type 

Prerequisites: No specific Excel prerequisites required. 

Microsoft Excel Advanced

This 1-day training is suitable for novice users of Excel who would like to master the basic functionalities of Excel. The training is given in groups both online and on location. 

The training consists of the following parts 

  • User Interface Excel 
  • Create, open, and insert workbooks 
  • Fill in data 
  • Copying and pasting of data (transpose, formatting, formulas etc.) 
  • Using operators such as addition, subtraction, multiplication and division 
  • Entering formulas 
  • Autosum function 
  • References in formulas 
  • Inserting and Deleting Rows and Columns 
  • Formatting cells, cell properties for text and numbers (date, currency and number) 
  • Create and format charts and change chart type 

Prerequisites: No specific Excel prerequisites required. 

Microsoft Excel Macro’s & VBA

This 1-day training is suitable for novice users of Excel who would like to master the basic functionalities of Excel. The training is given in groups both online and on location. 

The training consists of the following parts 

  • User Interface Excel 
  • Create, open, and insert workbooks 
  • Fill in data 
  • Copying and pasting of data (transpose, formatting, formulas etc.) 
  • Using operators such as addition, subtraction, multiplication and division 
  • Entering formulas 
  • Autosum function 
  • References in formulas 
  • Inserting and Deleting Rows and Columns 
  • Formatting cells, cell properties for text and numbers (date, currency and number) 
  • Create and format charts and change chart type 

Prerequisites: No specific Excel prerequisites required. 

Excel Macro’s & VBA Advanced   

This 1-day training is suitable for novice users of Excel who would like to master the basic functionalities of Excel. The training is given in groups both online and on location. 

The training consists of the following parts 

  • User Interface Excel 
  • Create, open, and insert workbooks 
  • Fill in data 
  • Copying and pasting of data (transpose, formatting, formulas etc.) 
  • Using operators such as addition, subtraction, multiplication and division 
  • Entering formulas 
  • Autosum function 
  • References in formulas 
  • Inserting and Deleting Rows and Columns 
  • Formatting cells, cell properties for text and numbers (date, currency and number) 
  • Create and format charts and change chart type 

Prerequisites: No specific Excel prerequisites required. 

Phyton Fundamentals   

This 1-day training is suitable for novice users of Excel who would like to master the basic functionalities of Excel. The training is given in groups both online and on location. 

The training consists of the following parts 

  • User Interface Excel 
  • Create, open, and insert workbooks 
  • Fill in data 
  • Copying and pasting of data (transpose, formatting, formulas etc.) 
  • Using operators such as addition, subtraction, multiplication and division 
  • Entering formulas 
  • Autosum function 
  • References in formulas 
  • Inserting and Deleting Rows and Columns 
  • Formatting cells, cell properties for text and numbers (date, currency and number) 
  • Create and format charts and change chart type 

Prerequisites: No specific Excel prerequisites required. 

Microsoft Acces Basic   

This 1-day training is suitable for novice users of Excel who would like to master the basic functionalities of Excel. The training is given in groups both online and on location. 

The training consists of the following parts 

  • User Interface Excel 
  • Create, open, and insert workbooks 
  • Fill in data 
  • Copying and pasting of data (transpose, formatting, formulas etc.) 
  • Using operators such as addition, subtraction, multiplication and division 
  • Entering formulas 
  • Autosum function 
  • References in formulas 
  • Inserting and Deleting Rows and Columns 
  • Formatting cells, cell properties for text and numbers (date, currency and number) 
  • Create and format charts and change chart type 

Prerequisites: No specific Excel prerequisites required.