Introduction to Analytics: MS Excel Capsule Course

By Sajal Agarwal - Data Scientist , Tata Consultancy Services
23-Nov-2019 - 01-Dec-2019 View Schedule
Age Group: 20 years - 35 years
Weekends Only

About this course

Did you know? 16% of the world’s population uses MS Excel!
In this introductory course to Excel, participants will explore the foundations while getting comfortable with this widely used software. Getting information on the critical elements and nifty shortcuts used widely while gaining knowledge through solving real-world problems.


After successful completion of this capsule, participants can expect to have a strong base to work efficiently in an existing worksheet while being able to create a dashboard from scratch. Participants would be able to manifest data at one place from various cells, sheets or from another workbook.

Who is this for

  • For students finishing graduate/post-graduate courses. This course will accelerate your career, no matter whether you wish to get a job or start your own company!
  • For young professionals, working for 2-3 years, seeking to better analyze their own workings/organize their data sets to get meaningful information in order to improve their performance.
  • For professionals looking to add to their analytics knowledge by understanding shortcuts/tips about MS Excel.

Introduction to Analytics: MS Excel Capsule Course

By Sajal Agarwal - Data Scientist , Tata Consultancy Services
23-Nov-2019 - 01-Dec-2019 View Schedule
Age Group: 20 years - 35 years
Weekends Only

What all will you learn?

23-Nov-2019 03:00 PM - 06:00 PM
  • Create a basic worksheet by entering text, values, and formulas.
  • Change the appearance of worksheet data by using a variety of formatting techniques.
  • Create formulas like VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET and by using some of Excel's built-in functions.
    • Mathematical
    • Logical


  • Create formulas Cont.
    • Text
    • String
    • Statistical
  • Handling & Analysis of Data with Pivot Tables
  • Filter and sort Excel data
  • Plan, create and modify normal charts & dynamic Charts
  • Prepare a document for printing by using a variety of printing options

Participants will create a dashboard of their own At the end of every session participants will need to solve some problems to have hands on practice with each function and methods to apply in daily use.

Introduction to Analytics: MS Excel Capsule Course

By Sajal Agarwal - Data Scientist , Tata Consultancy Services
23-Nov-2019 - 01-Dec-2019 View Schedule
Age Group: 20 years - 35 years
Weekends Only

Faculty

SAJAL AGARWAL

SAJAL AGARWAL

Data Scientist , Tata Consultancy Services

Introduction to Analytics: MS Excel Capsule Course

By Sajal Agarwal - Data Scientist , Tata Consultancy Services
23-Nov-2019 - 01-Dec-2019 View Schedule
Age Group: 20 years - 35 years
Weekends Only

FAQs

  • For students finishing graduate/post-graduate courses. This course will accelerate your career, no matter whether you wish to get a job or start your own company!
  • For young professionals, working for 2-3 years, seeking to better analyze their own workings/organize their data sets to get meaningful information in order to improve their performance.
  • For professionals looking to add to their analytics knowledge by understanding shortcuts/tips about Ms. Excel.

Participants will be able to analyze data through excel, make dashboards, dynamic charts, use of pivot tables and continued practice will able to crack aptitude tests designed for both MNCs.

Yes, we have curated a resource library with some reading & practice material with which you can refer back to from time to time

  • Comfortable with Windows 7 (or later windows), or OSX Platform: Windows, OSX Software: - Microsoft Excel 2013, Microsoft Excel 2010 (Windows), Microsoft Excel 2011 (MAC)
  • Participants are required to bring their laptops for the sessions.

Introduction to Analytics: MS Excel Capsule Course

By Sajal Agarwal - Data Scientist , Tata Consultancy Services
23-Nov-2019 - 01-Dec-2019 View Schedule
Age Group: 20 years - 35 years
Weekends Only

Fee Structure

S. No. Particulars Amount
1 Academic Fees Rs. 2000/-
2 Other Expenses (Joining Kit, Portal and Certification) Rs. 2000/-
Total Payable Rs. 4000/-

Reach out to us

Ready to find your next thing?

For You

Interested in one of our capsules?

Start Learning

For Organisations

Looking to host Mynt experiences?

Let's Talk