Industry acceptable Data Analytics certification for all learner’s training which help fresher/Experienced to up-skill at corporate.
Industry Expert Sr. Lead Analyst / Technical Analyst With 10+ Years provide workshop session @ SLA/OTC
After completion of 70% of Data Analytics training our dedicated placement team arrange interview till placement.
Data Analytics Practical Training help to gain exposure like corporate level with technical test series
Real time projects & best case study makes OTC workshop very unique and lively for learners.
For Learner’s, Our admin team fresh batch schedule/re-scheduling classes/arrange doubt classes.
Data Analytics Certification
Our Trainer:- 10+ Years of industry experience as a Data Analyst Manager in MNC, Education:- B.Tech/MCA
Course Duration: 110 – 120 (Hours) with Highly Skilled Corporate Trainers
(Data Analytics Certification Training) for 6 Modules-Weekdays/Weekend
Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.
Mathematical Functions:- Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
Date & Time Function:- Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.
Statistical Function & Other Functions:- Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
Logical Functions:- And, Or, If, Iferror, Not, Nested If
Lookup & Reference Functions:- VLookup, HLookup, XLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link