97480 87356/ 97487 71580     Whatsapp 97480 87356      i4besthr@gmail.com      Locate Us     paytm 90389 00006

Basic & Advanced Computer Practical Training Course

Module 1 - Basic Computer with Microsoft Office

Module 1.1 - Computer Fundamental

Module 1.2 - Microsoft Word

Module 1.3 - Microsoft Excel

Module 1.4 - Microsoft PowerPoint

Module 1.5 - Microsoft Outlook

Module 2 – Advance Microsoft Excel

Introduction to Advanced Excel:-


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.

Course Time & Duration Details

Course Modules Duration (Hours) Duration (Weekend)(Saturday- Sunday) Duration (Weekdays)(Tuesday - Friday)
Module 1 & 2
45 - 50 Hours 2.5 - 3 Months 1 - 1.5 Months
Module 1
25 - 30 Hours 1.5 - 2 Months 1 Month

Success Stories

We believe in providing Quality Service to our CLIENTS.

Get all HR Updates on your mail Id

Enquiry Form



Payment Options

Please Make All Payments in form of Demand Drafts: In favor of “i4best” Payable at Kolkata or The Cheque has to be raised in the Name of i4best.


Bank Transfer or CASH Deposits in:


Mode of Payment:- Cheque / DD / NEFT Terms & Conditions apply*
We solicit your presence/Nominations.

For Booking seats - Email: i4besthr@gmail.com
Contact Nos. : 9748771580/97480 87356/9748771580