Excel 2019
€270.27
Tax included
This Excel 2019 e-learning course allows you to master the essential features of spreadsheets in order to efficiently organize, calculate, and analyze your data. In 30 hours, you will learn how to create tables, use common and advanced formulas and functions, build charts, apply conditional formatting, and work with pivot tables. Thanks to progressive and practical modules, this program helps you automate your calculations, improve the reliability of your analyses, and boost your productivity in a professional context.
👉 Target audience: beginners, employees, students
👉 Duration: 30 hours
👉 Objective: master data analysis and processing with Excel
👉 Intended for: anyone who wants to use Excel efficiently
Description
📊 Master Excel 2019 to analyze and leverage your data
This Excel 2019 training course enables you to gain full mastery of spreadsheets in order to efficiently organize, analyze, and leverage your professional data. The program covers essential and advanced features needed to automate calculations, create reliable analyses, and improve daily productivity.
📌 Learning objectives
| Skill | Expected outcome |
|---|---|
| Data organization | Create and structure efficient tables |
| Automated calculations | Use common and advanced formulas and functions |
| Data analysis | Create charts and pivot tables |
| Automation | Optimize workflows using advanced tools and macros |
🧭 Getting started and data management
You will discover the Excel environment and learn how to create, save, and organize your workbooks and worksheets.
- Introduction to the Excel interface
- Creating and managing workbooks
- Entering and editing data
- Managing rows and columns
- Data formats: numbers, dates, times
➗ Excel formulas and functions
This training helps you master automated calculations and the most commonly used functions in a professional environment.
| Feature | Skill acquired |
|---|---|
| Formulas | Create automated calculations |
| Statistical functions | COUNT(), AVERAGE(), SUM() |
| Advanced functions | IF(), SUMIF(), logical functions |
🎨 Formatting and conditional formatting
You will learn how to make your tables more readable and automatically highlight important information.
- Cell formatting
- Merging and alignment
- Borders and colors
- Conditional formatting
- Data bars and icons
📈 Charts and data visualization
Excel allows you to transform your data into clear and understandable charts to facilitate analysis.
- Creating charts
- Editing and customizing charts
- Adding graphical elements
- Printing charts
🧩 Pivot tables
Pivot tables allow you to quickly summarize large volumes of data and obtain reliable analyses.
- Creating a pivot table
- Updating and modifying
- Pivot charts
- Quick data analysis
🔎 Analysis, simulations and automation
The course also covers advanced tools for performing simulations and automating certain tasks.
- Goal seek
- What-if analysis
- Scenarios
- Macros and automation
❓ Frequently Asked Questions
You will immediately receive an email containing all the information needed to access your training space. You can start learning right away.
You have access for 12 months, allowing you to complete the modules at your own pace.
A certificate of completion is provided once you finish the course.
Yes, the course is accessible on computer, tablet, and smartphone via all modern browsers.
You can choose between two payment options:
- One-time payment: pay the full amount at purchase and get immediate access for 12 months.
- 12 monthly installments: pay in 12 monthly payments. After the 12 months, your subscription renews automatically on a monthly basis, which you can cancel at any time.
In both cases, you get immediate access to the full course.
The Premium version offers personalized support to help you progress faster and get answers to all your questions. This option includes:
- A chat with a tutor available during business hours for technical and learning support
- Email support outside working hours
- Personalized assistance if you encounter difficulties or need additional explanations
This option is ideal if you want guided learning with fast and reliable support.
Product Details
FL-EX19-OMT
Specific References
Reviews
No customer reviews for the moment.