About This Course
Excel course for Finance, Commerce, Management & Engineering Students
Self-Paced Recorded Course (6 Months access only!)
Why should you learn this course?
- Excel is the essential skill for all the finance, HR, Management students.
- Excel is necessary step to understand data and first steppingstone to become a business analyst and data scientist.
- This course will give you practical experience on different datasets including Finance and HR data.
- Learn any time and anywhere.
- Learn using industry relevant examples.
Each module has practice along files and assignments which will help sharpen your skills. The examples and scenarios used in the course are in line with the live-work scenarios.
At the end of the course, you will be comfortable working with process of turning raw data into amazing dashboards !
Learning Objectives
A course that makes you eligible for many jobs in finance & management.
This course is started step for future business analysts and data scientist as it gives the understanding of the data.
Self-paced recorded course
Gives practical knowledge of MS Excel
Gives practical knowledge on using Finance and HR data
Target Audience
- For Finance, Commerce, Management & Engineering Students
- Qualifications: BBA, BBM, MBA (Finance, Marketing, HR), BCom, MCom, B.Tech, BCA, MCA
Curriculum
36 Lessons40h
Module 1 – Excel Fundamentals
* Getting to know the application and its interface.
* Here, we try to understand the features of excel, available options in each of the menu tabs.
* Entering data and how excel understands the user inputs along with basic data formatting and shortcuts.
1 Interface and options7:30
2 Open, Save and Shortcuts9:43
3 Text, Numeric and Date format logic6:11
4 Date formatting2:16
5 Module 1 Assignment 1 Introduction1:17
Module 1 – Assignment 1
Module 2 – Modifying Excel Worksheet
* Work with worksheets, introducing the sheet additions, deleting and how to edit multiple sheets in one go!
* Work with cells and its formatting. Different ways to use the cells when text is involved vs Numeric.
* Get know the most amazing feature! Conditional Formatting. Highlight and draw attention to the Cells, Rows and Columns based on conditions.
Module 3 – Filters and Sorting
* Quick analysis! Knowing how to apply filters, multiple columns and sorting
Module 4 – Basic Excel Functions
* Understand the most important feature, Cell Referencing. This enables us to navigate formulas with ease.
* Work with the basic formulas under the categories: Numeric, Text, Logical, Date and Lookups.
* Understand how to write Formulas in different sheets and sheet references.
Module 5 – Dashboard Creation
* Lets apply what we have learnt so far and also learn further data manipulation to seek insights.
* Understand the data, frequent challenges and how to shape the data to generate charts and Pivot Tables.
* Build the Dashboard Views and work with Slicers.
₹15,000.00
Material Includes
- All recorded sessions and videos are included.
