Job-ready Excel skills : Beginner to Advanced (Dashboards)
Become an intermediate or advanced Excel user and create your first interactive dashboard in less than 6 hours.
4.61 (22 reviews)
74
students
5.5 hours
content
Jan 2022
last update
$39.99
regular price
What you will learn
Essential Excel skills taking them from Ground “Zero to Hero” (from Basic to Advanced skills in Excel)
Skills focused on Job-readiness.
Formatting tables, conditional formulas (eg. Sumif), sorting
Introduction to Pivot tables and pivot charts
Advanced functions : VLookup, Index & Match
Transformations : Split Column, Concatenate & Filter, text manipulation, date transformations
Other Data Cleaning : Removal of duplicate rows
Combining multiple worksheets
Recording a macro
More Pivot tables
Interactive Dashboard creation
Screenshots
Related Topics
3187346
udemy ID
5/31/2020
course created date
7/16/2020
course indexed date
Bot
course submited by