With this Online Course, you can realize your ambition of becoming a Data Analytics Professional. You will receive instructor-led trainings on how to use MS Excel for capturing, preparing, analyzing and presenting data.

Join the next batch of students, become a Pro in data analytics. This will position you as a candidate for high-paying career and business opportunities.

Course Duration: 3 Months

REGISTER NOW

COURSE MODULES

• Descriptive & Inferential Statistics
• Fundamentals of Microsoft Excel
• Analyzing Data using Advanced Microsoft Excel

Microsoft Excel is a powerful application software for spreadsheet analysis, data analytics and some other purposes.

This is a transformational online course on Data Analytics using Microsoft Excel. The course is designed to help you:

• Understand the concept of data analytics and the phases of a data analytics process
• Understand the rudiments descriptive statistics: measures of centrality, variability and position
  
• Understand various statistical sampling methods
  
• Understand the nature, user interface, and general structure of the MS Excel software
• Understand how to effectively navigate the Excel environment and carryout lots of frequently needed operations
• Learn how to effectively capture and organize data
• Learn how to summarize data at micro level using Microsoft Excel Pivot Tables
  
• Understand how to summarize and presenting data at macro level using various charts and graphs
• Learn how to use Excel to work with various business functions in Excel – What if analysis, solver, etc.
• Understand how to analyze complex data (from SQL database and other data sources) using Microsoft Excel Power Pivot
  
• Understand data cleaning and how to clean datasets using MS Excel
• Learn what hypothesis is and understand how to formulate hypothesis
• Understand the difference between parametric and non-parametric stats models
• Understand forecasting and how to implement same in Excel
• Understand various statistical models and how to implement them with MS Excel – t-test, regression analysis, etc.
• Learn how to interpret and communicate the result of analysis to appropriate stakeholders
  
• Receive career counselling

On successful completion of this course the student will be awarded a certificate.

REGISTER NOW

This is not just a Microsoft Excel tutorial. It is a transformational course on Data Analytics (using Excel) which has the potential to add value to you professionally and financially.