Mastering Microsoft Office Excel
Cette formation pour "Mastering Microsoft Office Excel" est une formation complète destinée à toute personne souhaitant exploiter pleinement les fonctionnalités clés d’Excel, du niveau débutant à avancé. Grâce à une approche progressive et orientée pratique, c
Create your free account
How the course works
Each lesson is a structured text, illustrated with examples and diagrams, followed by a quiz that is automatically graded. You progress at your own pace, and your notes stay attached to the lesson in which you took them.
La formation "Mastering Microsoft Office Excel" is for anyone who wants to acquire or improve their skills in this essential spreadsheet software of office productivity. Whether you are a beginner, an intermediate user or a professional looking to sharpen their skills, this course will help you work faster, structure your data efficiently and gain independence in creating tools tailored to your professional needs.
Throughout the course, you will learn to master the core features and to use advanced tools to produce clear, reliable and easy-to-use documents. Through real-world examples and hands-on case studies, you will be able to apply Excel in a variety of contexts: management, finance, HR, logistics, etc.
Course objectives:
- Mastering the interface and the main features of Excel
- Create, edit and format professional spreadsheets
- Use essential formulas and functions (logical, statistical, conditional)
- Automate calculations to avoid manual errors
- Summarize and visualize data using charts and PivotTables
- Boost efficiency with analysis, sorting, filtering and conditional formatting tools
This course will help you turn Excel into a true decision-making tool and decision support in your daily work.
"Companies such as NVIDIA, Dell, Walmart need data analysts with advanced Excel skills" - Glassdoor.com
«Excel is the most in-demand software skill in Indeed job postings» - Hrdrive.com
Every major company uses it. So, if you want to acquire a new skill that all employers value, you should start here.
Here are the reasons why you should take this course and learn Excel:
- A solid understanding of Excel opens the door to a number of career opportunities
- The best Excel users are promoted very easily within large companies
- Excel skills stay with you for life .

If you have a disability and would like to take a training course with us, this email address is dedicated to you: contact@datagoz.com ; For any other situation, don't hesitate to contact us to assess how to ensure a learning experience.
Who should attend this course?
- Users, beginners, intermediate and advanced learners who want to master Excel.
- Data Analyst
- Excel user
The DATAGOZ team wishes you a great training experience!
Certificate of completion: at the end of this course, you will receive a DATAGOZ certificate of completion, issued in your name and verifiable online.
15 chapters, 89 lessons
- 4. Defining a workbook in Excelsubscribers
- 4. Create an empty workbook or one based on a templatesubscribers
- 4. Move or copy sheetssubscribers
- 4. Insert rows or columnssubscribers
- 4. Change the size of rows and columnssubscribers
- 4. Hide rows, columns or sheetssubscribers
- 4. Select ranges of cellssubscribers
- 4. Copy or move cell contentssubscribers
- 4. Validate datasubscribers
- 4. Quizsubscribers
- 10. Formatting cellssubscribers
- 10. Exploring the different number formatssubscribers
- 10. Applying conditional formattingsubscribers
- 10. Using automatic formattingsubscribers
- 10. Creating a custom number formatsubscribers
- 10. Creating calculation formulassubscribers
- 10. Naming cellssubscribers
- 10. Going further with the IF functionsubscribers
- 10. Quizsubscribers
- 12. Manage data listssubscribers
- 12. Filter your data automaticallysubscribers
- 12. Use advanced filterssubscribers
- 12. Create advanced filters with formulassubscribers
- 12. Search with advanced filterssubscribers
- 12. Sort a data listsubscribers
- 12. Calculate subtotals from a listsubscribers
- 12. Use the Slicer tool on a tablesubscribers
- 12. Set up panessubscribers
- 12. Quizsubscribers
- 13. Define the PivotTablesubscribers
- 13. Create a PivotTable from a data listsubscribers
- 13. Update external datasubscribers
- 13. Connect Excel to an external data sourcesubscribers
- 13. Create a PivotTable from an external sourcesubscribers
- 13. Refresh a PivotTablesubscribers
- 13. Create a PivotChartsubscribers
- 13. Using the Slicer on a PivotTablesubscribers
- 13. Quizsubscribers
Everything that comes with the lessons
How long, depending on your availability
What you get at the end
Once the course is completed, the certificate is issued in your name. Its code allows a recruiter to verify it in just a few seconds.
This is not a diploma or a professional certification; it is verifiable proof that you have followed and successfully completed this course.
Who writes this course
A clear, hands-on teaching approach, with concrete examples to help you learn effectively.
Before you start
Start this course today
2 free lessons, no credit card required. You'll see the level and tone before deciding.