Blog Index

• Microsoft Excel Short cut Keys 
• Split Forename and Surname
• Time Calculation
• Brackets in formula
• Show all formula in Excel Sheet  
• SUM using names
• Short cut Key for Sum
• ABS function in Ms Excel
• Age Calculation
• How to join pieces of text into one item ?
• AND function in Ms Excel
• CHOOSE
• AVERAGE
• CHAR
• PowerPivot Free Add-on for Excel 2010
• VLOOKUP
• HLOOKUP
• COUNT
• COUNTIF
• DSUM
• Formula for counting Blank in Excel
• How to use if statements in Excel ?
• How to deal with Excel Formula Errors?
• Find number of combinations for fixed number of items