Industry acceptable certification for all training which help fresher/Experienced to up-skill at corporate.
Industry Expert Sr. Business Analyst with power BI With 10+ Years provide workshop session @ SLA
After completion of 70% training our dedicated placement team arrange interview till placement.
Practical Training help to gain exposure like corporate level with technical test series
Real time projects & best case study makes SLA workshop very unique and lively for learners.
For Learner’s, Our admin team fresh batch schedule/re-scheduling classes/arrange doubt classes.
Web / Desktop Base.
Instructor-Led Classroom Sessions.
Presentations/Demonstration/Practicals of concepts.
Handouts/Assignments/Real-time Exposure to work on Clients.
NOTE: Classes are also Available on Module Basis
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, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
Complete SQL in a Class
Fundamentals of SQL
How Relationships Work in SQL
Explaining SQL Strings
Numbers and SQL
SQL Functions and Clause
What are Subselects and Views in SQL
Maintaining SQL Server Database
SQL Server Job Creation
Topics Covered as follows:
|Course Module||Course Duration|
|Adv Excel Analytics + MS Power BI + Base SAS + Access & SQL+R Programming||90 (Hours)|