Online training session: programming with XLSTAT, Feb. 2016 (French)

XLSTAT is a powerful and user-friendly statistical software that lets you analyze your data directly in Excel. This programming with XLSTAT training will allow you to take advantage of the XLSTAT functions within your VBA (Visual Basic for Applications) procedures. The training is followed by practical application exercises and tests to be submitted online for correction.

The session lasts one day, has a very competitive price and is online, so no need to step out of your office to attend!

This session is over

Programming with XLSTAT, 1 day training

The XLSTAT software coupled with the power of the MS Excel Visual Basic of Applications (VBA) language lets you automate numerous XLSTAT analyses. This training includes VBA programming basics and tips to call XLSTAT functions from VBA. The training is based on examples that will let you build a program that calls XLSTAT from VBA.

Prerequisites

Being a regular user of XLSTAT

Objectives

Being able to automate analyses and call XLSTAT functions from VBA.

Program

Excel and XLSTAT

  • A couple of hints and tips

VBA

  • Syntax
  • Objects
  • Debugging
  • Managing Excel workbook cells in VBA
  • Macros
  • Functions

XLSTAT and VBA

  • loadrun calls to call XLSTAT features
  • Reaching outputs
  • Automating calls
  • Toward the creation of an interface that makes use of XLSTAT features

Price

€290.00
per participant

Dates

Start at:

End at:

Language

French

Location


Trainers' profiles


Emmanuel Jakobowicz

Founder of Stat4decision

With more than 15 years of experience in data-oriented projects, Emmanuel Jakobowicz is passionate about data science and entrepreneurship. He founded Stat4decision to propose a new way of assisting people in exploring their data. He owns a PhD in applied statistics and computer science. He also is an engineer in mathematics specialized in machine learning. His work experience includes research and development at Electricité de France and software development at Addinsoft XLSTAT where he was a partner, CTO, Chief Scientist, consultant and trainer for large companies, research institutes and universities.

hand-stat