Latest Blog Posts for Excel Tips

• Excel Addins : Spell Currency Excel Addin
  on Feb 13, 2012 in Excel Addins SpellCurr() Spell Currency
  I am sharing Excel Addin for converting Numbers to Words. I keep getting mails / comments where people are not able to install the VBA code shared in my earlier postExcel Functions : Convert Numbers to Words. This Addin will make it easier to use. Th...
• Excel Macros : Send Email with VBA
  on Jul 24, 2010 in Excel Macros Macros in Excel Send email with VBA
  The Code I am sharing with you today is capable of sending active sheet of your workbook through outlook mail to email ID specified by you. You will not get any warning messages and the email will be sent using outlook profile available on your machi...
• Excel Formula : Calculating Age
  on May 31, 2010 in calculating age Excel Formulas Working with date function
  Today I am sharing with a long formula for calculating age based in Date of Birth as input. =YEAR(DATE(YEAR(TODAY())-YEAR(A1),MONTH(TODAY())-MONTH(A1)+1,DAY(TODAY())-DAY(A1)+1))-1900&" Years "&IF(MONTH(DATE(YEAR(TODAY())-YEAR(A1),MONTH(TODAY())-MONTH...
• Create Range Name in Excel
  on Apr 18, 2010 in Defined Names Range Name Excel Working with Data Range
  Today I am sharing quickest way to create Range Name in Excel. Just 3 easy steps1. Select the cell(s) you want to name2. Type Range name in the name box3. Press EnterThe following is a list of syntax rules that you need to be aware of when you create...
• Add Spin Buttons Active X Excel
  on Apr 10, 2010 in Add Spin Buttons ActiveX Controls Making EMI Calculator
  In my previous posts I have shared EMI Calculator with you. This was mode using Excel PMT function and Spin Buttons ActiveX Controls in Excel. In this post I am sharing how to add spin buttons ActiveX controls to excel worksheet.Step 1 Have Developer...
• Show Developer Tab in Excel 2007 Ribbon
  on Apr 10, 2010 in Show Developer Tab Excel Macros Macros in Excel
  In case you are working with ActiveX Controls or Macros in Excel , you need to have Developers Tab visibile in your Excel 2007. When you start using Excel 2007, developers Tab is not visible , however you can set it visible with following stepsStep 1...
• Excel Formula : PMT Function
  on Apr 2, 2010 in PMT Function in Excel Making EMI Calculator
  In my previous post I shared EMI Calculator with you. In this post I am sharing how to make EMI Calculator. This has been done using PMT Function in excel to calculate EMI amount and Spin Buttons ActiveX Controls to fine tune the amounts.Using PMT Fu...
• EMI Calculator
  on Mar 21, 2010 in EMI Calculator
  My friend is taking a loan to buy a house and he asked me what will be my EMI. He knew following figures and was curious to know his EMILoan AmountAnnual Interest RateLoan Period - YearsI quickly calculated EMI using PMT function in excel. This trigg...
• Excel Formula : Subtotal Excel
  on Mar 17, 2010 in subtotal in excel subtotal excel subtotal function excel excel subtotals subtotals in excel
  Most of the time in our reporting we need to do subtotals followed by Grand total at the end of report. I have seen many people using SUM function for subtotals in between and then adding individual cells for calculating grand total at the end. There...
• Format Numbers : Excel Currency Format
  on Mar 8, 2010 in Excel Currency Format Excel Number Format Formating Numbers in Excel
  You can add currency symbol to your numbers in excel.Open Number Format dialog box using Format Cells option or just press Ctrl+11. Click Accounting2. Choose currency symbol from drop downIn case you do not get your currency symbol from drop down, ad...

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment