ADVANCE EXCEL
ADVANCE EXCEL
Course Description
Introduction to Excel
- Basic Understanding MenuandToolbar, Introduction to different category offunctions like Basics, Mathematical and Statistical, Dateand Time, Logical, Lookup and References, Text and Information.
Mathematical Functions
- Sum,Sumif, Sumifs, Count, Counta, Countblank, Countif, CountifS, Average, Averagea, Averageif, Averageifs, Subtotal
Date and 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, DataValidation, Group& Ungroup, Data split...
and many more.......
Course Syllabus
ADVANCE EXCEL
Duration: 3 Months
Advertisements
