Get updates on Eligibility, Admission, Placements Fees Structure
Quick Facts
| Medium Of Instructions | Mode Of Learning | Mode Of Delivery |
|---|---|---|
| English, Hindi | Self Study | Video and Text Based |
Course Overview
Crash Course in Advanced Excel Techniques (M) certification course provides certification to the candidates at the end of the course if the students manage to pass the online quiz exam with a minimum of 60 percent. The candidate gets to access the course for 6 weeks or till the time students pass the online exam. The course can be accessed from anywhere by the students because of its online nature. The Crash Course in Advanced Excel Techniques (M) certification is a self-paced course and thus there are no sorts of deadlines in the course. Students can view lectures as per their own schedules. The basic requirement to attend the course is to have a good internet connection and a laptop or computer, or a smartphone.
Students will learn about topics such as MS excel sheets, workbooks, charts, pivot tables, and other types of tables, etc. Participants need to spend at least 7 hours per week to complete the Crash Course in Advanced Excel Techniques (M) certification syllabus. This course also contains source code files to gain hands-on practice for the students. The content of the course is updated on the regular basis according to current industry demands. The Crash Course in Advanced Excel Techniques (M) online course is a professional level course and thus working professionals can also apply for this course. The course also includes sample project ideas for the candidates.
The Highlights
- Online course
- Self-paced program
- Professional level course
- 6 weeks duration of the program
- 7 hours per week is required to complete the course
- Professional level course
- Sharable and verified certification available
Programme Offerings
- Modules
- Video sessions
- online quiz
- Sample project ideas
Courses and Certificate Fees
| Certificate Availability | Certificate Providing Authority |
|---|---|
| yes | IIT Kanpur |
- Students can access the whole course for 6 weeks by paying an amount of Rs. 4,237 plus GST as Crash Course in Advanced Excel Techniques (M) fees.
Crash Course in Advanced Excel Techniques (M) fees details
Heads | Amount in INR |
Course fee | Rs. 4,237 plus GST |
Eligibility Criteria
Education
Candidates must have a basic knowledge of Microsoft Excel in order to apply for this program.
Certification Qualifying Details
Participants need to go through the whole syllabus and then appear for the online MCQ exam and pass the same with the minimum percentage mentioned on the official website to achieve the certification for Crash Course in Advanced Excel Techniques (M) training.
What you will learn
After completing the whole curriculum of the course, candidates will gain plenty of information about-
- Candidates will be able to learn the basic as well as advanced techniques that are used in Excel worksheets and workbooks.
- Candidates will acquire knowledge about creating basic formulas to do the calculation in the Crash Course in Advanced Excel Techniques (M) certification course.
- Participants will acquire knowledge about cell content, how to create, modify, and edit the cell content in excel sheets.
- Aspirants may acquire information on using excel charts, pivot tables, and conditional formatting, etc.
- Candidates will get to know about the usage of macros in order to automate repetitive tasks.
- Candidates will be taught about different functions of excel such as if function, and/or function, etc. throughout the Crash Course in Advanced Excel Techniques (M) online course
- Participants will also learn about the different chart elements in this course.
- Students will get valuable insights on how to perform personal data organization.
- Students will get hands-on experience using code files provided in this course.
- Students will have an increased understanding of the tools used to make the elements of excel sheets.
- Candidates will learn about how to enter data in excel sheets efficiently.
- Candidates will acquire knowledge on advanced formulas, lists, and styles in the Crash Course in Advanced Excel Techniques (M) program.
Who it is for
The Crash Course in Advanced Excel Techniques (M) program is best suited for the following individuals-
- Candidates who wish to develop their skills in MS excel.
- Candidates who wish to pursue this course professionally.
Admission Details
Students are expected to keep in mind the following points if they wish to apply for this course-
Step1- Applicants must visit the official link of the course https://ict.iitk.ac.in/product/crash-course-in-advanced-excel-techniques-in-hindi/
Step2- After clicking on the above link, participants will land on the official website of the course.
Step3- Candidates need to click on the enrol and pay option given in the blue section of the page.
Step4- Candidates need to fill in the required information and then click on the proceed to checkout option given on the bottom right corner of the page.
Step5- Pay the quoted amount using a suitable option.
Step6- Congrats, you can now access the verified course.
The Syllabus
- In this lecture, we will learn about the Microsoft Excel 2016 Interface in detail.
- We will also learn to create a new file in this lecture, save the file, open the saved file and print it.
- In this lecture, we will learn about basic formulas like "SUM", "AUTOSUM", "AVERAGE", "MIN", "MAX" and "ROUND".
- In this lecture, we are going to learn in detail about functions such as "PMT", "FV", "COUNTIF", "SUMIF" and "AVERAGEIF".
- In this lecture, we will learn about data basics.
- With this, we will also learn about different number formats and flash fill.
- In this lecture, we will learn how to create a table, format them, sort and filter the data range, and add and delete rows and columns.
- In this lecture, we will learn how to create excel pivot -tables. We will also talk about this and how it works.
- In this lecture, we will learn to work on multiple workbooks.
- We will also learn how to transfer information from one worksheet to another worksheet or transfer from one workbook to another.
- In this lecture, we will learn about Charts and Graphs.
- With this, we will also learn how many types of these are and how they insert in their worksheet.
- In this lecture, we will learn about worksheet basics. Here you have been told what the rows are, what are the columns and what the cells are.
- With this, you will also learn about sheet tabs.
Evaluation process
Candidates need to appear in an online MCQ exam and achieve at least 60 percent grades to get the certificate for the course.
IIT Kanpur Frequently Asked Questions (FAQ's)
The course is available for the whole year. There is no deadline to apply for this course as it is a self-paced course.
No, the video sessions cannot be downloaded but are available on the website throughout the year.
Candidates can retake the course as many times as he or she wants. Candidates will be eligible for the certification each time they successfully complete the course.
Candidates will not be eligible to get the certificate if they do not complete the whole Crash Course in Advanced Excel Techniques (M) certification syllabus in time.
The certificate contains the name of the candidate, acknowledgment, and the logo of the institution that speaks for the authenticity of the certificates.
Candidates need to qualify for the online MCQ exam with a minimum of 60 percent.
The final online exam will contain a set of multiple-choice questions. Students also need to work on a project based on the course.
Candidates can access the course for 6 weeks or until they finish the final online quiz.
Candidates are expected to spend at least 7 hours a week to complete the course.
Articles
Download Careers360 App's
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile
250M+
Students
30,000+
Colleges
500+
Exams
1500+
E-Books
12000+
Cetifications
