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)
Udemy
platform
English
language
Microsoft
category
instructor
Job-ready Excel skills : Beginner to Advanced (Dashboards)
75
students
5.5 hours
content
Jan 2022
last update
$13.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

Course Gallery

Job-ready Excel skills : Beginner to Advanced (Dashboards) – Screenshot 1
Screenshot 1Job-ready Excel skills : Beginner to Advanced (Dashboards)
Job-ready Excel skills : Beginner to Advanced (Dashboards) – Screenshot 2
Screenshot 2Job-ready Excel skills : Beginner to Advanced (Dashboards)
Job-ready Excel skills : Beginner to Advanced (Dashboards) – Screenshot 3
Screenshot 3Job-ready Excel skills : Beginner to Advanced (Dashboards)
Job-ready Excel skills : Beginner to Advanced (Dashboards) – Screenshot 4
Screenshot 4Job-ready Excel skills : Beginner to Advanced (Dashboards)

Loading charts...

3187346
udemy ID
31/05/2020
course created date
16/07/2020
course indexed date
Bot
course submited by