Become an intermediate or advanced Excel user and create your first interactive dashboard in less than 6 hours.
What you'll 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
Requirements
- No prerequisites, jump in even if you have never ever used Excel before.
- Expected to have basic working knowledge of how to use a computer.
Description
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
Who this course is for:
- Complete Beginners in Excel, those needing a refresher and those wanting to expand their skills to the advanced Excel user level.
- Anyone looking to to upskill in data analysis using Excel.
- Excel users who want to create INTERACTIVE DASHBOARDS in Excel, taking their Excel skills to the next level.
- Anyone looking to get a job promotion by demonstrating advanced Analysis skills in Excel.
