Genre: eLearning | Language: English + .VTT | Duration: 3 hours | Size: 1.57 GB
What you'll learn
Solid understanding of Microsoft Excel
Knowledge of all the essential Excel formulas
Become proficient in data tools like Sorting, Filtering, Data validations and Data importing
Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match
Harness full potential of Excel by creating Pivot tables with slicers
Make great presentations using the Conditional and Table formatting options
Visually enchant viewers using Bar charts, Scatter Plots, Histograms, Waterfall charts etc.
Increase your efficiency by learning how to create and use important Excel shortcuts
Become competent in using advanced Analytics techniques in Excel such as Regression, Goal seek and Solver
Learn Automation techniques by using Macros
Explore fun and exciting use cases of Excel in our bonus videos
Requirements
You will need a PC with any version of Excel installed in it
Description
Welcome to the Microsoft Excel Masterclass course.
The course is created on the basis of three pillars of learning:
Know (Study)
Do (Practice)
Review (Self feedback)
Know
We have created a set of concise and comprehensive videos to teach you all the Excel related skills you will need in your professional career.
Do
With each lecture, we have provide a practice sheet to complement the learning in the lecture video. These sheets are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.
Review
Check if you have learnt the concepts by comparing your solutions provided by us. Ask questions in the discussion board if you face any difficulty.
Apart from this, explore fun and exciting use cases of Excel in our bonus videos.
The Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of Excel in today's corporate world.
Who this course is for:
Working Professionals beginning their Data journey
Anyone curious to master excel from beginner to Advanced in short span of time
Students about to join their first corporate job
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.