MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 10 lectures (4h 13m) | Size: 1.77 GB
Complete Excel Course for the beginners
What you’ll learn
Create and manage data in a spreadsheet
Work with important functions like pivot, vlookup & conditional formatting
Create insights and presentation with the use of data
Integrate MS-Excel features with other office apps
No prior experience needed. The course is for absolute beginners
Internet and an audio/visual devIce is more than enough. (preferably Laptop)
Whether you’re a student, a job-hunter or a newly joined corporate employee, this course will be wide open and useful for everyone. Keeping in mind to encourage simplicity, we’ve followed a chronology of the chapters. We’ll cover all the important tools and features of Excel that you’ll need in your institution. Every session will be supported by the same demonstrated excel sheet for your practice. I’m fairly sure if you keep up with the recommendations, you’ll have all the required methods at your disposal by the end of the course.
As this course is designed for beginners, we’ll start from scratch. This will include basic commands, arithmetic and functions, arrangements & syncs and many more. By the end of 3 sessions, you’ll surely be able to navigate and work with the data. Of course! not without the required practice from your side.
As we pass the basics, We’ll play with live data, calculations, impressive dashboards and presentations, that you never knew is possible with Excel. Excel hosts a wide range of applications, so we may not touch base upon everything but the most used functions for the standard use.
After you learn, how to set and use the worksheet, we’ll summarize with a huge data set, followed by the live tasks. As you’ll receive the editable worksheets for each session, you’ll need to step up and make sure assignments are completed on time.
Excel is a primary requirement in any organisation at any level. Understanding its build and features saves a billion years of time. Okay! jokes apart, this course will help you in understanding the most used features like vlookups, pivot and conditional formatting without breaking a sweat. You’ll also learn a few tricks that I’ve gained over an experience of 8 years of using Excel. Cutting the long story short, it has everything you need to know before you join your first organization or for your business.
All the videos are supported by their corresponding spreadsheets and they’ll be provided to you for your practice. All the best!!
Who this course is for
The course is for the beginners who want to learn MS Excel from the scratch. The course is put together in a very simple and slow paced technique so that it can be learnt in the best way possible.