- DCA (1)
- ADCA (3)
- Graphic Design (2)
- Programming & Web Development (2)
- Skill Development (0)
- TALLY (2)
- CCC (1)
- DIGITAL MARKETING (1)
- BASIC COMPUTER (1)
- ADVANCE EXCEL (1)
- TYPING (1)
- Advance Excel with Tally Prime GST (1)
- Ms. Excel (1)
- Adobe Photoshop (1)
- Diploma In Financial Accounting (1)
- Diploma in Information Technology (1)
DIGITAL COMPUTER INSTITUTE
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
