This Course Is Design For Some One Having Zero OR Some knowledge About Excel.
This course will give you Strong foundation in excel
This is MUST DO course before learning advance excel
What Student Will Learn:
CELL REFERENCING WITH BEST PRACTICE FOR CREATING STRONG FORMULA WRITING SKILLS.
FORMULAS 1: ARITHMETIC OPERATORS , SUM, AVERAGE, COUNT etc.
TEXT SERIES FORMULAS: CONCATENATE ,UPPER, LOWER, PROPER, LEFT, RIGHT, TRIM, EXACT etc.
DATE & TIME SERIES FORMULAS : TODAY,NOW,DAY,MONTH,YEAR,HOUR etc.
IMPORTANT TOOLS IN EXCEL: FILTER, SORT, FREEZE,REMOVE DUPLICATES, CONDITIONAL FORMATTING.
PIVOTE TABLE.
CHARTS.