

Duration : 3 Months

Study Type : Full Time

Classes : Offline & Online

100% Placement Assistance

Job Oriented Training

Step by step training

Daily Assignments
Data Analytics Course Training In Bangalore:
Introduction to Data Analytics
Data Analytics Overview
Importance of Data Analytics
Types of Data Analytics
Descriptive Analytics
Diagnostic Analytics
Predictive Analytics
Prescriptive Analytics
Benefits of Data Analytics
Data Visualization for Decision Making
Data Types, Measure Of central tendency,
Measures of Dispersion Excel:
Basics to Advanced Excel
tutorial Text to Columns
Concatenate
The Concatenate Function
The Right Function with Concatenation
Absolute Cell References
Data Validation
Time and Date Calculations
Conditional Formatting
Exploring Styles and Clearing
Formatting Using Conditional
Formatting to Hide Cells
Using the IF Function
Changing the “Value if false”
Condition to Text Pivot Tables
Creating a Pivot Table
Specifying PivotTable Data
Changing a PivotTables
Calculation Filtering and
Sorting a PivotTable Creating
a PivotChart Grouping Items
Updating a PivotTable
Formatting a PivotTable Using
Slicers Charts
Creating a Simple Chart
Charting Non-Adjacent Cells
Creating a Chart Using the Chart
Wizard Modifying Charts
Moving an Embedded Chart
Sizing an Embedded Chart
Changing the Chart Type
Chart Types
Changing the Way Data is Displayed
Moving the Legend
Formatting Charts
Adding Chart Items
Formatting All Text
Formatting and Aligning Numbers
Formatting the Plot Area
Formatting Data Markers Pie Charts
Creating a Pie Chart
Moving the Pie Chart to its Own Sheet
Adding Data Labels
Exploding a Slice of a Pie Chart & more…

