When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
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.
This Course Includes
udemy
5 (22 reviews )
5h 27m 
english
Online - Self Paced
professional certificate
Udemy
About Job-ready Excel skills : Beginner to Advanced (Dashboards)
This course will help to prepare you to land your next job or promotion
. Whether completely new to Excel, in need of a refresher or just looking to skill up to an advanced Excel user, THIS COURSE IS FOR YOU. You will feel so confident on completion that you will be excited to show off your newly acquired skills. This follow-along demo style will enable you to both grasp concepts while you try them out yourself, saving you tons of time. You will learn to
create your first DASHBOARD
with lots of great tips & tricks along the way. Become da boss at Excel and feel GREAT !! The course is deliberately structured into three main sections : 1) The
BEGINNER
2) for those looking to
become INTERMEDIATE
Excel users and 3) those who want to
upskill to an ADVANCED
Excel user. Simply go to the section that matches your level and skill goal. We got you covered. We encourage students to not just watch the video but to actually work along with me. You will find that I go at a steady pace and I explain in detail so you understand and are not just going through the motions. The idea is to be able to immediately apply what you have learnt in this course on your job. IMMEDIATELY !! Or to crush that interview.
Actual Student Reviews:
“I found this lesson to be
very user-friendly & comprehensive
& I'll definitely be transferring the knowledge gained…” Monique Hamilton “So far it is
great
. Her
instructions are very easy to follow
.”Carol Levy “Without a doubt, the instruction is
clear and engaging
!” Alvin Schwapp
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 Show moreShow less.