Tous les cours
Bureautique
Perfect Your Excel Skills
Create a Microsoft Excel dashboard: create a table, get to grips with advanced features and automate data processing using VBA macros.Moyenne
12 heures
Ce cours en libre accès vous intéresse ?
Now you've got to grips with the fundamentals of Excel, do you want to create powerful dashboards to manage your business? Do you want to prepare for your TOSA Excel advanced level certification?
Then you've come to the right place!
In this course, you'll find out how to create an Excel table using raw data. You'll learn how to properly prepare data to ensure that Excel can use it. You'll use Excel's extremely powerful built-in formulas and tools to let your data do the talking. Finally, you'll find out how to use VBA macros to resolve complex problems and automate tasks!
Do you want to perfect your Excel skills? If so, join me on this course!
Objectifs pédagogiques
- Create an Excel Table
- Create an Excel Dashboard
- Manipulate Data in a Dashboard
Prérequis
Prerequisites
To do this course, you'll need to have a basic knowledge of Excel. You can acquire these skills by completing the Master the Fundamentals of Excel course.
Required tool: Excel 2019.
Table des matières
- Partie 1
Get the Most out of This Course
- Partie 2
Create an Excel Table
- Partie 3
Complete Your Dashboard
- Partie 4
Manipulate Your Dashboard Data
Contributeurs
Professeurs
Damien Coulbault
Après 20 ans de grandes entreprises, je suis maintenant entrepreneur, et Excel est mon ami ! Je créé des outils sur mesure pour les PME/PMI.
