Excel from Zero to Dashboard
by Nvuala Carvalho
About this course
In this course, you will learn everything from the fundamentals of Excel to creating interactive dashboards, developing essential skills to organize data, automate calculations, analyze information, and present results professionally. Across 19 lessons divided into 5 modules, you will explore data formatting, essential formulas and functions, table management, lookup functions such as VLOOKUP, HLOOKUP, XLOOKUP, and INDEX + MATCH, as well as creating charts, pivot tables, and visual reports. You will learn to work with data, use text, logical, conditional, date and time functions, organize tables efficiently, search and cross-reference information with advanced functions, create and customize charts, build pivot tables and interactive reports, and develop a mini dashboard as the final project of the course. This course is ideal for students, professionals, entrepreneurs, and anyone looking to improve their digital skills, increase productivity, and use Excel with greater confidence in academic or professional settings. In the final project, you will apply the acquired knowledge to build a mini dashboard, consolidating key data analysis and visualization tools. Start from zero, progress step by step, and develop practical skills to use Excel more efficiently and professionally!
About teacher
Nvuala Carvalho
Data Analyst, Master Data Specialist & Management Control Analyst
Data Analyst, Master Data Technician & Management Control, Trainer, with a solid background in web development and data analysis, I bring a solution-focused approach that integrates responsive design and data analysis to enhance user experience and business efficiency.