This is a course which will impart you the knowledge that is essential for most of the service sector Jobs like consulting, banking and finance, accounting. This course will help you to manage and analyze the things more efficiently like your budget, grades, expenses.
After every session student will get an assignment based on the things which he/she has learnt in the session.
There is no prerequisite, you just need to know basic arithmetic operations like summation, multiplication.There will be no too much workload, just attend sessions and do you home work. And make sure you should submit them by the deadline.
Learning outcomes and student Eligibility
All are Eligible.
No data found
1. Introduction to Excel and
2.Basic mathematical expressions and function
3. If statements
1. Pivot Tables
2. Pivot Charts
1. Basic Formatting
2. Conditional Formatting
1. Use of VLookup
2. Use of IndexMatch
3. Using formula for Arrays
1. Use of Column Names
2. Function for String manipulations
3. Data cleaning
A project from Scratch which uses the things that we have learned in our last sessions