Perfect Your Excel Skills

3.5 /5

(2 Ratings)

Offered byOpenClassrooms

Perfect Your Excel Skills
at
OpenClassrooms
Overview

Duration	12 hours
Total fee	Free
Mode of learning	Online
Difficulty level	Intermediate
Official Website	Explore Free Course
Credential	Certificate

Perfect Your Excel Skills
at
OpenClassrooms
Highlights

Earn a certificate of completion from Open Classroom

Perfect Your Excel Skills
at
OpenClassrooms
Course details

Skills you will learn

Excel Macros Advanced Excel

What are the course deliverables?

Learning Outcomes
By the end of this course, you'll be able to:
create an Excel table.
complete a dashboard.
manipulate data in your dashboard.

More about this course

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

Perfect Your Excel Skills
at
OpenClassrooms
Curriculum

Part #1 - Get the Most out of This Course

Part #2 - Create an Excel Table

Part #3 - Complete Your Dashboard

Part #4 - Manipulate Your Dashboard Data

Perfect Your Excel Skills
at
OpenClassrooms
Faculty details

Mike Weston

Designation : I wear many hats, including Advisor, Mentor, NED, Keynote Speaker and Author. I am the founder of SMTW Advisory

Damien Coulbault

Designation : 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.

Perfect Your Excel Skills
at
OpenClassrooms
Entry Requirements

Eligibility criteria Up Arrow Icon

Some of the features presented in this course may differ depending on whether you use Windows or Mac. At times, the content that follows may therefore not be 100% aligned with what you see on screen in Excel. 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.

Conditional Offer Up Arrow Icon