Under the Ministry of Electronics & Information Technology (MeitY), E&ICT Academy, IIT Kanpur brings you various courses in Emerging Technologies, Computer Sciences, Entrepreneurship, Business and many more. This course is curated and delivered by Industry Experts equipped with a wealth of experience and an in-depth understanding of the subject matter.
Overview:
Excel course provides fundamental concepts of excel through real world case studies and examples and gives insights into how to apply data and analytics principles in your business.
Prerequisites:
- This Introduction to Excel course has been designed for all levels, regardless of prior knowledge of analytics, statistics, or any formulas. Familiarity with mathematics is helpful for this course.
Key Learning Outcomes:
When you complete this Introduction to Data Analytics course, you will be able to accomplish the following:
- Understand how to solve analytical problems in real-world scenarios
- Define effective objectives for analytics projects
- Work with different types of data
- Understand the importance of data visualization to drive more effective business decisions and ROI
- Understand charts, graphs, and tools used for analytics and use them to gain valuable insights
- Create an analytics adoption framework Identify upcoming trends in data analytics
Target Audience:
This course is ideal for anyone who wishes to learn the fundamentals of data analytics and pursue a career in this growing field. The course also caters to CXO-level and middle management professionals who want to improve their ability to derive business value and ROI from analytics.
Test & Evaluation
- During the program, the participants will have to take all assignments given to them for better learning.
- At the end of the program, a final assessment will be conducted
Certification
- All successful participants will be provided with a certificate of completion.
- Students who do not complete the course / leave it midway will not be awarded any certificate.
Duration: 50 hours
Delivery Mode: Online Live Instructor led learning
Disclaimer : E&ICT Academy, IIT Kanpur reserves the right to modify or cancel any courses listed on the portal. E&ICT Academy, IIT Kanpur also reserves the right to change the mode of delivery (Online, Offline, Hybrid, Self paced) without notice. However, the student will be given the option to claim 100% refund in case of any of the above modifications.
Curriculum
Module 01 – Data Analytics Overview
- Introduction
- Data Analytics: Importance
- Digital Analytics: Impact on Accounting
- Data Analytics Overview
- Types of Data Analytics
- Descriptive Analytics
- Diagnostic Analytics
- Predictive Analytics
- Prescriptive Analytics
- Data Analytics Benefits: Decision-making
- Data Analytics Benefits: Cost Reduction
- Data Analytics: Other Benefits
- Key Takeaways
Module 02 – Business Analytics with Excel
Functions and Formulas
- Formulas with Multiple Operators
- Inserting and Editing a Function
- Auto Calculate and Manual Calculation
- Defining Names
- Using and Managing Defined Names
- Displaying and Tracing Formulas
- Understanding Formula Errors
- User Defined and Compatibility Functions
- Financial Functions
- Date & Time Functions
- Math & Trig Functions
- Statistical Functions
- Lookup & Reference Functions
- Text Functions
- Logical Functions
- Information Functions
Working with Data Ranges
- Sorting by One Column
- Sorting by Colors or Icons
- Sorting by Multiple Columns
- Sorting by a Custom List
- Filtering Data
- Creating a Custom AutoFilter
- Using an Advanced Filter
Working with PivotTables
- Creating a PivotTable
- Specifying PivotTable Data
- Changing a PivotTable’s Calculation
- Filtering and Sorting a PivotTable
- Working with PivotTable Layout
- Grouping PivotTable Items
- Updating a PivotTable
- Formatting a PivotTable
- Creating a PivotChart
- Using Slicers
- Sharing Slicers Between PivotTables
Analyzing and Organizing Data
- Creating Scenarios
- Creating a Scenario Report
- Working with Data Tables
- Using Goal Seek
- Using Solver
- Using Text to Columns
- Grouping and Outlining Data
- Using Subtotals
- Consolidating Data by Position or Category
- Consolidating Data Using Formulas
Working with the Web and External Data
- Inserting a Hyperlink
- Importing Data from an Access Database or Text File
- Importing Data from the Web and Other Sources
- Working with Existing Data Connections
Customizing Excel
- Customizing the Ribbon
- Customizing the Quick Access Toolbar
- Using and Customizing AutoCorrect
- Changing Excel’s Default Options
- Creating a Custom AutoFill List
- Creating a Custom Number Format
Working on Live Data and Dashboards
- Creating dashboards on company specific data
- Working on Live data
- Dashboards with the help of Developer Ribbon.
- Working with critical & Complex formulas
Module 03 – Tableau
- Understand how Tableau Desktop fits within the Tableau family of products
- Combine data sources for use by Tableau
- Connect to a variety of sources including flat files and databases
- Understand data types and roles
- Use key operations in Tableau – filtering, sorting, grouping and creating sets
- Work with extracts (file formats used by Tableau)
- Build and format data visualizations
- Work with maps and location-based data
- Working with bins
Module 04 – PowerBi
- Introduction to PowerBi and Connecting data, Built-in Aggregations, Calculated Columns and Measures
- Creating conditional columns, merging queries
- Pivoting and Unpivoting, Appending queries
- Mathematical Operations
- Dashboard & Story
FAQs
1. Why should I join Winter Training Program 2024-25 from E&ICT Academy, IIT Kanpur?
E&ICT Academy, IIT Kanpur are designed to equip with latest techniques and concepts of the Industry. Throughout these courses, you will engage in hands-on sessions and projects. The practical experience will enable you to tackle to real world challenges effectively. Upon successful completion you will be awarded an Industry recognised certificate from E&ICT Academy, IIT Kanpur.
2. Who can do this Training program / Eligibility for the program?
Any student who is an Undergraduate, Graduate or Postgraduate which includes all B.Tech / MCA/M.Sc IT/B.Sc IT/BCA/PGDCA/MBA/BBA/PGDM and IT aspirants. Faculty members teaching at Undergraduate, Graduate and Postgraduate or at school levels. Working professionals who wish to improve/upgrade their skills
3. What is the last date for enrollment?
The enrollment process is on a “FIRST COME, FIRST SERVE” basis. Only 150 Seats are available at each and every course, Once seats are filled then particular batch admission will be closed
4. Is there a hostel facility available for Winter Training Program 2024-2025?
Hostel facility is NOT available for Winter Training Program 2024-2025 at IIT Kanpur Campus.
5. What is criteria of the certificate?
In order to get a certificate a minimum of 80% attendance is mandatory failing which the student will not be eligible for any certificate. The student who is absent during the examination or fails in the exam shall not be allowed for re- examination under any circumstances. Student who will be absent during assessment will be provided course attended certificate provided his/her attendance is 80%.
6. Can I switch from one course to another course ?
Usually we do not support change of courses. But if it is necessary then a student can request by dropping an email at eict@iitk.ac.in with payment invoice.
7. Can I switch from one batch to another batch?
Batch switching is dependent on the availability of the seats .To switch batches a student can request by dropping an email at eict@iitk.ac.in .
8. What is the Fee Refund Policy?
Usually, we do not provide refunds once the enrollment process has been completed. However, if a participant is unable to join the course due to unavoidable circumstances, they may apply for a refund. The request for a refund should be made 48 hours before the start date of the course/program, whether it is conducted live online or offline. To initiate the refund process, please send an email to eict@iitk.ac.in. We will then acknowledge your refund application via email.
Please note that students who do not join, attend, or inform us of their absence from classes will not be eligible for any refunds under any circumstances. The refunded amount will be returned to the same account from which the payment was made. The processing time for refund applications is approximately 2 to 3 weeks from the date of acceptance by our team.
The refund amount will be transferred to the account through which the original payment was made and only through electronic transfer.
Enquiry
For any query call us at +91 7992088885 or fill the form below
