Excel Functions and Pivot
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.
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:
