Certification in Advance Excel Training

I4best Offers Advance Excel Practical Training for UG/Graduate/PG/MBA/ BBA freshers/ pursuing/ working professionals.
Who Should Attend:
All ambitious, career-oriented Candidates, Executives , Students of MBA or BBA .
Duration : 1-3 Months with practical experience.
The curriculum covers the following modules:
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

Pivot Table and Charts:-

Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display

Data Collection Method With Data Quality:-

Collaboration & Security Like Share Your Workbook On Share Drive With Quality

Analysis:-

Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table

Advanced Chart Technique:-

How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart.

Advanced Dashboard.
Report Development
Live Project Session.
At the end of the training, the student will be given Training completion certificate, which will help him / her get an opportunity in the corporate world.
Course Structure
* Total course duration 1-3 Months
* Weekdays/Weekends options available
Add on Benefits
* Professional CV making
* Career Counselling (Individual assessment will be given to all the
candidates regarding the feedback about their mock interview and tips
to improve)
* IQ Tests
* Brain Teasers
* Personality Development
* 100% Job Placement Assistnce.
* Post training support provided regarding any HR issues.
* On the JOB TRAINING.
Placements
We provide placement assistance to our students. Our students in the past have been placed in good organizations.  We provide a number of chances to the student during and after the training.
For more details on the Course and the Batches please feel free to ask. We would be glad to assist you.

 

0

Year Of Experience

0

Trainees Enrolled

0

Batch Completed

Placement Track Record

Unlimited Interview

ISO 9001:2015 Certified Company