Data Analyst Training Program

Program Details

Are you passionate about diving into the world of data analytics? At EpicMinds IT, we offer a comprehensive Data Analytics Training Program that is designed to equip you with the skills and knowledge needed to excel in the field of data analysis.

Program Highlights:

• Work on Live Projects
• Structured Curriculum
• 100% Placement Assistance

Module 1: Introduction to Excel and Spreadsheet History
1.1 Introduction to Excel
1.2 Evolution and History of Spreadsheets
Module 2: Data Filtering and Sorting
2.1 Auto Filter
2.2 Advance Filters
2.3 Sorting Techniques

Module 3: Basic Functions and Formulas
3.1 SubTotal, Count, CountA, Max, Min, Average
3.2 Important Excel Formulas

Module 4: Advanced Filtering Techniques

4.1 Lighting Filter

4.2 Filter Rows/Data based on Cell Color, Cell Icon, and Font Color

Module 5: Automation in Excel

5.1 Introduction to Automation

5.2 Programming Languages used to automate Excel

5.3 Running VBA Code in Excel

Module 6: Data Manipulation and Transformation

6.1 Flash Fill

6.2 Split Data

6.3 Conditional Based Sum and Count

Module 7: Introduction to Power BI

7.1 Power BI Platforms

7.2 How to Use Power Query

7.3 How to Use Power Pivot

7.4 Applying Slicer in Power BI

Module 8: Pivot Tables and Reports

8.1 Creating Pivot Tables

8.2 Applying Filters on Pivot Reports

Module 9: Excel Formula Mastery

9.1 IF Function

9.2 SumProduct

9.3 Match Function

9.4 Index Function

Module 10: Cell Referencing Techniques

10.1 Absolute, Relative, and Mixed Reference

10.2 Table Structured Reference

Module 11: Advanced Excel Features

11.1 Array Formulas

11.2 Other Advanced Excel Features

Program Format:

• Duration: 3 Months
• Mode: Offline/Online

Placement:

Top performers in each batch will be directly hired into EpicMinds IT.

Candidates will receive job assistance, including resume building, mock interviews, and exposure to live projects.

Fees:

₹ 25,000+ Tax