Microsoft Excel - Introduction to data analysis

The aim of the training is to equip participants with the professional Excel skills needed for their work, with a focus on functions, statements, large and complex data tables.

The training will be practical, using practical examples from the business and finance fields to demonstrate the skills required for the users' work, such as formatting and analysing more complex spreadsheets, applying common functions (logical, mathematical, statistical, text, date, lookup) and formulas, creating and formatting charts.

The course is designed for users with a basic knowledge of Excel who will be responsible for the day-to-day use of Excel spreadsheet.

Analysis Toolpak

• Descriptive statistical function package

Functions for data analysis

• Data analysis functions describing a set (MIN, MAX, KICSI, LARGE, SIZE, MODE, COVERAGE, etc.)
• Logic functions (IF, TRUE, AND, etc.)
• Averaging and conditional averaging functions (AVERAGING, AVERAGING, AVERAGING MORE, etc.)
• Piece counting functions with or without condition (DARAB, DARABTELI, DARABHATHER, etc.)
• Counting - search functions (IF, FALSE, SUM, SUM, SUMMORE, etc.)

Display (Pivot Table)

• Formatting, sorting, basic operations
• Visual statements

Charts

• Chart types and their use
• Creating and formatting charts
• Multi-axis charts

Data analysis (alternative data analysis techniques)

• Data analysis with conditional formatting: data bars, icons, colour scale in cells
• Data validation in cells, warning messages, error messages
• Creating drop-down lists, using hyperlinks