Get all HR Updates on your mail Id
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
Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct
Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time
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.
Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen
And, Or, If, Iferror, Not, Nested If
VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link
Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display
Collaboration & Security Like Share Your Workbook On Share Drive With Quality
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
How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart.
|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|
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: