Yogeshguptaonline - yogeshguptaonline.com - Yogesh Gupta's Excel Tips
General Information:
Latest News:
Excel Addins : Spell Currency Excel Addin 14 Feb 2012 | 07:21 am
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 post Excel Functions : Convert Numbers...
Excel Macros : Send Email with VBA 25 Jul 2010 | 05:54 am
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 ...
Excel Formula : Calculating Age 1 Jun 2010 | 03:46 am
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(MON...
Create Range Name in Excel 18 Apr 2010 | 09:00 pm
Today I am sharing quickest way to create Range Name in Excel. Just 3 easy steps 1. Select the cell(s) you want to name 2. Type Range name in the name box 3. Press Enter The following is a list of s...
Add Spin Buttons Active X Excel 10 Apr 2010 | 09:51 pm
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...
Show Developer Tab in Excel 2007 Ribbon 10 Apr 2010 | 07:58 pm
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...
Excel Formula : PMT Function 3 Apr 2010 | 12:19 am
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 Acti...
EMI Calculator 22 Mar 2010 | 02:41 pm
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 EMI Loan Amount Annual Interest Rate Loan Period - Years I quickl...
Excel Formula : Subtotal Excel 17 Mar 2010 | 11:39 pm
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 c...
Format Numbers : Excel Currency Format 9 Mar 2010 | 05:38 am
You can add currency symbol to your numbers in excel. Open Number Format dialog box using Format Cells option or just press Ctrl+1 1. Click Accounting 2. Choose currency symbol from drop down In ca...
