Learn More Excel

ADVANCED MS EXCEL TOPICS CONTENTS

• INTRODUCTION OF MICROSOFT EXCEL

• EXPLORING THE EXCEL INTERFACE

• MICROSOFT EXCEL SHORTCUTS KEYS

• BASIC FORMULAS & FUNCTIONS

   1. Date and Time Functions in Microsoft Excel

• TODAY (For current Date)

• NOW (For current Date and Time)

• DATE (Convert Date Month and year in date format)

• TIME (Convert Hours Minutes and Seconds in time format) 

• DAY (Return day of the month)

• WEEKDAY (Return a number from 1 to 7 in week)       

• DAYS360 (Return number of days between tow dates)

• MONTH (Return month number from January to December)

• YEAR (Return year from given date)

    2. String/Text Functions in Microsoft Excel

• RIGHT (Return right characters) 

• LEFT (Return left characters)

• MID (Return middle characters)

• LEN (Return number of characters)

• UPPER (Converts letter in uppercase)

• LOWER (Converts letter in lowercase)

• TRIM (Remove extra spaces)

• PROPER (Capitalise first word in letters)

• FIXED (Round number)

• CONCATENATE (Combine tow or more cell)

   3. Mathematical Functions in Microsoft Excel

• SUM (Add all number)

• AVERAGE (Return average)

• ABS (Return absolute value)

• SQRT (Return square root)

• SUMIF (Sum with special condition)

• SUMIFS (Sum with two or more condition)

   4. Statistical Functions in Microsoft Excel

• COUNT (Count cell that contain number)

• COUNTA (Count not empty cell)

• COUNTBLANK (Count empty cell)

• CORREL (Return correlation coefficient)

• LARGE (Return largest number vale)

• SMALL (Return smallest number vale)

• COUNTIF (Count with special condition)

• COUNTIFS (Count with two or more condition)

   5. Lookup and Reference Functions In Microsoft Excel

• VLOOKUP (Vertical lookup)

• HLOOKUP (Horizontal lookup)

• INDEX (Return value in specified cell)

• MATCH (Return position of specified cell)

• INDEX MATCH function Together

   6. Logical Functions In Microsoft Excel

• IF

• Nested IF

• IF with AND

• IF with OR

• IF with NOT