Excel 2016
€231.66
Tax included
This Excel 2016 e-learning course helps you master the essential features of the spreadsheet software to efficiently analyze, organize, and use your data. In 30 hours, you will learn how to enter data, create formulas, use common and advanced functions, build charts, apply conditional formatting, and create pivot tables. Through progressive and practical modules, this course helps you become more independent and produce professional spreadsheets.
👉 Audience: beginners, employees, students, and anyone using Excel
👉 Duration: 30 hours
👉 Objective: master the essential functions of Excel 2016
👉 Designed for: anyone who wants to use data effectively with Excel
Description
📊 Master Excel 2016 to Analyze and Use Your Data
This Excel 2016 e-learning course helps you master the essential features of spreadsheet software to create clear tables, automate calculations, analyze data, and present results professionally. The learning path is progressive, covering beginner, intermediate, and advanced concepts, and includes practical exercises and resources.
📌 What You Will Learn:
| Topic | Content |
|---|---|
| Getting Started | Excel interface, creating and saving a workbook, templates |
| Data Entry & Formats | Numbers, dates, times, currency values, and best practices for data entry |
| Formulas & Functions | Formulas, relative/absolute references, common and advanced functions |
| Analysis & Reporting | Charts, pivot tables, sorting/filtering, subtotals |
🧭 Getting Started and Organizing a Workbook
You begin with the basics for working efficiently: opening, saving, navigation, selecting cells, and organizing worksheets.
- Start and exit Excel, discover the Excel window
- Open, save, and create a workbook, including from a template
- Move quickly, select a cell or a range
- Manage rows and columns: insert, delete, hide, resize
- Manage worksheets: rename, move, duplicate, group
✍️ Enter Data and Create Calculations
You will learn how to enter clean data and automate calculations with formulas and functions.
| Skill | What You Will Master |
|---|---|
| Formulas | Creating formulas, basic operations, fill handle, relative references |
| References | The difference between relative and absolute references |
| Common Functions | COUNT(), AVERAGE(), SUM(), and setting up calculation formulas |
🎨 Formatting and Conditional Formatting
The course shows you how to make your spreadsheets clear and professional, then automatically highlight important information with conditional formatting.
- Cell formatting: borders, colors, merging, alignment
- Copy formatting
- Conditional formatting: top 10, data bars, icons
- Create a checkerboard pattern and clear conditional formatting
📈 Charts, Series, and Data Visualization
You will learn how to turn your data into clear charts and customize their appearance.
- Create, edit, and format a chart
- Add elements such as title, legend, and labels
- Manage data series: add/remove, edit, trendlines
- Print a chart
🧩 Pivot Tables
A dedicated module teaches you how to create and use pivot tables to quickly analyze large volumes of data.
| Action | Result |
|---|---|
| Create a pivot table | Summarize and cross-analyze data |
| Edit and update | Adapt the analysis and refresh results |
| Pivot chart | Visualize the analysis with a chart |
🔎 Sorting, Filters, Subtotals, and Data Validation
You will learn how to structure and secure your spreadsheets: sort, filter, create subtotals, and control data entry.
- Sorting and filtering, including advanced filtering
- Subtotals and list management
- Data validation
- Protecting a sheet, cells, and a workbook
🧠 Analysis and Simulations (Goal Seek, Solver, Scenarios)
This section helps you go further by performing analyses and simulations to support decision-making.
- Goal Seek
- What-if analysis
- Solver
- Scenarios
🔁 Import / Export, Data Exchange, and Macros
You will discover how to import and export data, exchange content with other tools, and automate certain actions with macros.
- Import data
- Export an Excel table or chart to Word
- Record a macro
- Change the shortcut and view/edit a macro
❓ 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 get 12 months of access, allowing you to complete the modules at your own pace.
A certificate of completion is issued once the course has been completed.
Yes, the course is accessible on computer, tablet, and smartphone via all modern browsers.
You can choose between two payment options to access the course:
- One-time payment: you pay the full amount at the time of purchase and get immediate access valid for 12 months.
- 12 monthly payments: you pay for your course in 12 monthly installments. At the end of the 12 months, your subscription switches to automatic monthly renewal, which you can cancel freely if you do not wish to extend access.
In both cases, you get immediate access to the full course.
The Premium version offers personalized support to help you progress faster and answer all your questions. This option includes:
- Live chat with a tutor available during business hours to answer your technical and educational questions.
- Email support outside business hours and on non-working days: your tutor will reply as soon as they are available.
- Personalized guidance if you have difficulty understanding a topic, need additional explanations, or get stuck in a module.
The Premium version is ideal if you want to learn with human support, be guided step by step, and receive quick and reliable answers.
Product Details
FL-EX16-OMT
Specific References
Reviews
No customer reviews for the moment.