Microsoft Excel

Fiducia Solutions provides best excel and advance excel Training institute in Noida.Fiducia solutions provide training by a corporate trainer with 8 + Years of experience.

Our corporate trainer provides real-time Excel and advances in excel training. Fiducia solutions provide totally practical training by a corporate trainer. Fiducia Solutions provides 100 % placement support after completion of Training.

1. Basic Excel

• History of Excel, Basic Menu and Toolbar, Introduction to differents category of functions like , Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information. Advance filter, Auto filter, Slicer, and Data validation and protect unprotect sheet and Excel options.

2. Mathematical & Trig Functions

• Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Subtotal, Aggregate, Rand, Randbetween, Sumproduct, Percentage Calculation

3.Date & Time Functions

• Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time, Datedif,

4. 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.