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.
The Microsoft Access course covers:
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.
