MSG1
MANAGING AND USING DATA IN EXCEL

Objectives :

Learn management of Excel data tables and use coacmmon statistical functions to exploit and value data.

Level of trainees :

All sectors technicians or engineers.

Duration and location :

  • Duration : 14 hours over 2 days
  • Location : Soladis training center in Paris or Lyon (to consult the calendar, click on “Sign up”) or directly in your office (minimum of 4 people)

Training fee :

  • In Soladis office : 990€ tax-free per trainee
  • Other : Contact us for an offer adapted to your company.
Catherine

Pedagogical Manager: Catherine TUDAL

“This training is particularly suitable for people wishing to improve in data management in Excel and in the valorization of information. It is intended for non-statisticians who will appreciate the numerous practical exercises covered during the 2 days.”

Training Schedule

FIRST STEPS IN DATA TABLE EXPLORATION WITH EXCEL

  • Building data table: good practices in database building for an optimal use
  • Efficient browsing of a data table (use of filters, sorts, shortcuts)
  • Implementation of tools to avoid input errors (drop-down lists, validation of input values)
  • Implementation of tools facilitating the reading of the database (conditional data formatting, data grouping)
  • Creation of new variables: application of Excel formulas (sum, product, IF statement,  cell concatenation, extraction of character string, etc.)
  • Automatic return of value from another table (SEARCH function)

UNIVARIATE DESCRIPTIVE ANALYSES

  • Descriptive statistics (mean, minimum, maximum, sum, variance, standard deviation, …)
  • Use of pivot tables
  • Formula extension by freezing cells
  • Graphs: choosing the suitable graph

BIVARIATE DESCRIPTIVE ANALYSIS

  • PivotTables
  • Bivariate descriptive statistics (correlation coefficient)
  • Graphics: how to choose the appropriate graphic

APPLICATIONS

  • Data management through case studies with Excel
institute.soladis-blanc

Soladis - France (headquarter)
6-8 rue Bellecombe
69006 LYON - FRANCE
Tél: +33(0)4.72.83.86.70

Soladis GmbH - Switzerland
Lange Gasse 15
CH-4052 Basel
Phone: +41(0)58.258.15.80

Soladis Inc. - USA
185 Alewife Brook Pkwy, Unit 210
Cambridge, MA 02138-1100
Phone: +1(347).417.4008

Legal Notice

Data Protection Policy

Cookies Notice

Sitemap

    CONTACT US

    SEARCH

    Suscribe to our newsletter