Excel 2021
€328.19
Tax included
This Excel 2021 e-learning course allows you to master the essential and advanced features of spreadsheets in order to organize, analyze, and automate your professional data. In 30 hours, you will learn how to create tables, use formulas and functions, build charts, apply conditional formatting, use pivot tables, and automate certain tasks. Thanks to progressive and practical modules, this training helps you improve your productivity and the reliability of your analyses.
👉 Target audience: beginners to intermediate users
👉 Duration: 30 hours
👉 Objective: master data analysis and processing with Excel
👉 Intended for: anyone who wants to use Excel effectively
Description
📊 Master Microsoft Excel 2021
This Excel 2021 training enables you to gain full mastery of spreadsheets in order to efficiently organize, analyze, and leverage professional data. The course covers both essential and advanced Excel features, from data entry to advanced analysis and automation of calculations.
📌 Learning objectives
| Skill | Expected outcome |
|---|---|
| Data organization | Create and structure efficient tables |
| Automated calculations | Use Excel formulas and functions |
| Data analysis | Create charts and pivot tables |
| Automation | Optimize work using advanced tools and macros |
🧭 Getting started and data entry
You will discover the Excel environment and learn how to create, save, and organize your workbooks and worksheets.
- Discovering the Excel interface
- Entering and editing data
- Managing rows and columns
- Data formats: numbers, dates, times
- Selecting and navigating within sheets
➗ Excel formulas and functions
The training helps you master automatic calculations and the most commonly used functions in a professional context.
| Feature | Acquired skill |
|---|---|
| Formulas | Create automated calculations |
| Statistical functions | SUM(), AVERAGE(), COUNT() |
| Advanced functions | IF(), SUMIF(), VLOOKUP() |
🎨 Formatting and conditional formatting
You will learn how to make your tables readable and automatically highlight important information.
- Cell formatting
- Borders and styles
- Conditional formatting
- Data bars and icons
- Creating structured tables
📈 Charts and data visualization
Excel allows you to transform your data into clear charts to facilitate analysis and presentation of results.
- Creating charts
- Customizing charts
- Modifying data series
- Formatting and printing
🧩 Pivot tables
Pivot tables allow you to quickly summarize large amounts of data and obtain reliable analyses.
- Creating a pivot table
- Modifying and updating
- Pivot charts
- Quick data analysis
🔎 Analysis, automation, and macros
The training also covers advanced tools for simulations and task automation.
- Goal seek and scenarios
- What-if analysis
- Data consolidation
- Importing and exporting data
- Creating and editing macros
❓ Frequently Asked Questions
You immediately receive an email containing all the necessary information to access your training space. You can start learning right away.
You benefit from 12 months of access, allowing you to complete the modules at your own pace.
A certificate of completion is issued once the course is completed.
Yes, the training is accessible on computer, tablet, and smartphone via all modern browsers.
You can choose between two payment options to access the training:
- One-time payment: you pay the full amount at purchase and get immediate access valid for 12 months.
- 12 monthly payments: you pay in 12 monthly installments. After the 12 months, your subscription automatically renews monthly, which you can cancel at any time.
In both cases, you get immediate access to the full training.
The Premium version offers personalized support to help you progress faster and answer all your questions. This option includes:
- A chat with a tutor available during business hours to answer your technical and learning questions.
- Email support outside business hours: your tutor will reply as soon as possible.
- Personalized support in case of difficulty understanding, need for additional explanations, or being stuck in a module.
The Premium version is ideal if you want to learn with human support, be guided step by step, and receive fast and reliable answers.
Product Details
FL-EX21-OMT
Specific References
Reviews
No customer reviews for the moment.