This is an advanced course in the use of Excel and is intended to provide you with a working knowledge of Excel. It is one of the most effective data processing tools and almost all large and small companies use Excel in their day-to-day operations. Getting in-depth functional knowledge of Excel can significantly improve efficiency. You can be seen as a highly trained business data analyst in the company. It will open up a lot of doors for you.
You can use this program for the benefit of your company by uncovering valuable details contained in raw data. This course helps you to use the maximum power of Excel. You can learn about mean and median, variance and standard deviation, central limit theorem, forecasting results, various distribution forms, Bayesian analysis, classification matrix, etc.
1 Week
Live online lecture sessions by subject experts.
Microsoft Excel is one of the most widely used tools for data analysis and data visualization. The ease of use and cost are two very important reasons why most data analysts choose to use Excel for data analysis. However using Excel for data analysis requires consistency of thinking, expertise in data analysis, and good decision-making power.
With more and more companies trying to analyze the data for the long-term goals of the organization, there is an increasing demand for data analysts in the industry. If you add data analysis skills to your resume, it will open career opportunities for you.
1
Register
2
Join the Telegram group
3
Attend daily sessions
4
Give assignments / quizes
5
Fill the feedback form
1
Live online lecture sessions by subject experts.
2
Online lab and training sessions.
3
Course portal and access to course material, tutorials and practice notes, exercises.
4
Continuous evaluation and feedback on participant's progress during the course.
5
Follow-up sessions and discussion forums on research problems and internships.
6
Question answers and discussion in both online and offline mode.
Day 1: Overview of Basic and Advanced Excel
Day 2: Advanced sorting and filtering operations and data import from an external source
Day 3: Working with Formula and Functions
Day 4: Working with Data Visualization
Day 5: Pivot Tables and Power Queries
Working files:
Any Institute (Student/Faculty) | Rs. 500/- |
---|---|
Industry Participants | Rs. 1000/- |
Others Indian Participants | Rs. 1000/- |
Foreign Participants | Rs. 4000/- |