- From openclassrooms.com
Perfect Your Excel Skills
- Self-paced
- Free Access
- Fee-based Certificate
- 4 Sequences
- Intermediate Level
Course details
Syllabus
Part 1 - Get the Most out of This Course
1. Get the Most out of This Course
Part 2 - Create an Excel Table
1. Define the Components of a Professional Dashboard
2. Format Your Data
3. Create a Table
4. Tailor Your Table to Your Needs
5. Enhance Your Table
Quiz : Create an Excel Table
Part 3 - Complete Your Dashboard
1. Prepare Your Dashboard Model
2. Protect Your Dashboard
3. Enter Advanced Formulas
4. Tailor Nested Formulas to Your Needs
5. Make Your Dashboard Easier to Read
Quiz : Complete Your Dashboard
Part 4 - Manipulate Your Dashboard Data
1. Use Analysis Tools to Achieve Your Goals
2. Consolidate Large Quantities of Data
3. Work With Large Quantities of Data
4. Automate Tasks Using VBA Macros
Quiz : Manipulate Your Dashboard Data
Prerequisite
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.
Instructors
Mike Weston
I wear many hats, including Advisor, Mentor, NED, Keynote Speaker and Author. I am the founder of SMTW Advisory
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.
Editor
OpenClassrooms (formerly Le site du Zéro or SdZ) is a website that offers courses about computer science and entrepreneurship. Online courses can be made both by site staff, professors of universities or colleges partner as by its members.
Today, courses are available in several formats: MOOC (Massive Open Online Course), web text, e-book, book and video. The company delivers certifications for certain courses, including one recognized by the state in partnership with IESA multimedia.
Platform
OpenClassrooms (formerly Le site du Zéro or SdZ) is a website that offers courses about computer science and entrepreneurship. Online courses can be made both by site staff, professors of universities or colleges partner as by its members.
Today, courses are available in several formats: MOOC (Massive Open Online Course), web text, e-book, book and video. The company delivers certifications for certain courses, including one recognized by the state in partnership with IESA multimedia.