Since 1998, Formerly ATC of CMC Academy
Data Analysis using Excel Training Duration 36 Hrs.
This program is specially designed for those who willing to work as a Data Analyst. Data Analysis is one of the most in-demand jobs for 2022 around the globe. India is the second prominent hub of jobs for data scientists. Working professionals who wish to enhance their IT skill may also join this course. After completion candidate can work efficiently as a Data Analyst.
Course highlights
  • Overview of Data Analysis
  • Data Analysis vs Business Intelligence
  • Different Analytical Method
  • Process of Data Analysis
  • Sorting Techniques
  • Sort Function
  • Data Form
  • Outlining Data
  • Filter Function
  • Concept of Conditional Formatting
  • Shading Alternate Rows
  • Compare Two List
  • Conflicting Rules
  • Area Chart
  • Data Series
  • Format Axis
  • Error Bar
  • Trendline
  • Pareto
  • Multi Pivot Table
  • Frequency Distribution
  • Calculated Item
  • Getpivotdata
  • Complex problem with Solver
  • Overview of Analysis Tool Pak
  • Anova (F-Test & T-Test)
  • Correlation
  • Regression
  • Histograms
  • Power Query Operation
  • Merge Table in Query
  • Power Query Functions
  • Table Joining with Power Pivot
  • What If Analysis
  • Dynamic Dashboard Analysis

Final Project
Download Curriculum
Exit Profile : Data Analyst
Placement assistance will be provided to all successful candidates
Training Objective
Data Analysis using Excel certification course is designed by experienced professionals to match the current industry requirements and demands. You will learn the importance of Data Analysis in real time environment and will be able to enhance business growth.
Enquiry: (Classroom / Online Training)
8337066108 | 9123080133 | 9830070014
9433258217 | (033) 24617112

Gariahat Kolkata-700029 India

Hi ! Send your detail for more information

Find us on google

Powered By, Phoenix Enterprise. All Rights Reserved.