Daily use tips for excel. Solution to frequently faced excel problems in simple manner.
Owner: smiley123z
Listed in: Technology
Language: English
Tags: Excel, Excel Macros, Excel Formulas, Excel Tips
Site Statistics
Unique Visitors Today:
43
Page Views Today:
54
Unique Visitors this Week:
174
Page Views this Week:
254
Unique Visitors this Month:
667
Page Views this Month:
1,087
Total Unique Visitors:
1,420,952
Total Page Views:
2,183,726
Total Hits Out:
654
Latest Blog Posts for Excel Tips
- Excel Addins : Spell Currency Excel AddinI 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 VBAThe 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 AgeToday 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 ExcelToday 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 Excelon Apr 10, 2010 in Add Spin Buttons ActiveX Controls Making EMI CalculatorIn 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 RibbonIn 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 Functionon Apr 2, 2010 in PMT Function in Excel Making EMI CalculatorIn 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 Calculatoron Mar 21, 2010 in EMI CalculatorMy 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 Excelon Mar 17, 2010 in subtotal in excel subtotal excel subtotal function excel excel subtotals subtotals in excelMost 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 FormatYou 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...
Loading Comments...
Comments
{ds_PageTotalItemCount} commentcomments
{pvComments::date}
{pvComments::comment}