Learn Microsoft Excel: Beginner to Advanced

Complete Excel Course for the beginners

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.

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.

Course Content

  • Introduction –> 3 lectures • 1hr 24min.
  • Let’s Dig a lil’ deeper –> 7 lectures • 2hr 49min.

Auto Draft

Requirements

  • 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!!

 

Get Tutorial