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.