DATA ANALYTICS - Data Analytics with Excel
ITALIAN LANGUAGE
ASYNCHRONOUS COURSE DURATION: 16 HOURS
SYNCHRONOUS COURSE DURATION: 18 HOURS
MODE: online or in person
OBJECTIVES
Provide a solid foundation for unlocking Excel's data analytics potential, enabling you to derive meaningful insights and make data-driven decisions. From the basics to the most advanced techniques.
RECIPIENTS
All those who carry out or intend to carry out the activity of Data Analyst. Bachelor's degree in STEM fields preferred.
SUBJECTS
Fundamentals of Data Analytics with Excel
- Principles of descriptive statistics
- Different types of variables: categorical, quantitative, qualitative
- Excel Principles: Mathematical Operations, Strings, and Dates
- Use Excel to describe the data: position indices, dispersion, shape.
Advanced Data Analytics techniques with Excel
- Create different types of charts with Excel
- Theory and practice of pivot tables
- Understanding the normal distribution
- Introduction to probability
- Using Power Query
Statistical inference with Excel
- Confidence intervals
- Linear regression and predictions
- Hypothesis testing
- Database operations
CONTENTS AND TEACHING BY PROFESSION AI
