FrontpageTrainingsExcel Functions and Pivot

Excel Functions and Pivot

star_fullstar_fullstar_fullstar_fullstar_fullstar_half

After the training you will be able to import text data to Excel from different sources. In addition, you will know how to format the data to a form that can be easily used for Pivot-tables. You will also learn the functions that are central for Pivot-tables, for example, creating tables, different formats of data, calculating in the tables and filtering data.


Location
Helsinki

Training formats
Classroom
Remote

Duration
1 day

Price
495 €

Target Group

We have planned this advanced training for those who make Pivot-reports from imported data in Excel.

Prerequisites

Basic skills in working with Microsoft Excel. The course is an advanced course.

Content of Excel Functions and Pivot Course

Importing data into Excel

  • text files
  • dividing data into into columns
  • different data types

Excel formulas

  • using functions in formulas
  • cell references
  • functions for combining data, for example VLOOKUP
  • splitting and combining data with functions, for example, MID, CONCANETA, LEFT, RIGHT, TRIM
  • logical functions IF; OR, IFERROR

Excel lists and tables

  • converting a list to a table
  • table feature
  • subtotals
  • filtering

Pivot-tables

  • creating a Pivot-table
  • formatting
  • grouping data
  • calculations in a Pivot-table
  • creating a Pivot from several tables
  • slicers and timelines
  • settings for slicers

Schedule

Koulutuspäivä alkaa klo 9 ja päättyy noin klo 16.00–16.30. Aamiainen on tarjolla klo 8.15–9.00.

You might be interested in these courses:

Blogs related to the subject: