Skip to main content

Excel Hub

Search This Blog

HOME

Posted by U G

Get link
Facebook
X
Pinterest
Email
Other Apps

Excel Basics

All about number formatting in excel

How to customise your quick access toolbar...?

Editing cell contents in excel

Types of commands on the Ribbon

Ribbon tabs in excel

What you need to know in excel screen ?

Workbooks and Worksheets in excel

8 Best Uses of Excel software

Excel shortcuts to speed up your work.

Shared workbooks feature in excel

Quick access to worksheets

10 Shortcut Keys in excel to speedup your work.

Excel Formula

IF with AND formula for multiple logical tests.

IF FUNCTION AND NESTED IF FORMULAS IN EXCEL

View or Print all formulas in a Sheet

Find the Duplicate entries in the list using Countif formula

Left, Right and Len functions in excel

VLOOKUP Function in excel

SUMIFS Functions in Excel

SUMIF Functions in Excel

Excel SUM Formula

Using the $ sign in excel formula to fix the cell reference

Hide error value in excel formula cells.

Excel Utility

GST invoice format in excel

Income tax refund status, Assessment status, Assessee Profile Management in Excel

MIS reporting format of performance for small business.

Simple project management dashboard in excel

FD calculator for monthly interest recognision

Accounts receivable ageing report in excel

Central Excise Invoice in excel - Excel Utility

PAN application form in excel with Database facility.

Invoice preperation utility in Excel

ITR 1 (Sahaj) in excel for AY 2015-16 with auto fill function for printing

Excise Invoice Preparation utility in excel

Income tax assessee profiles and assessment status in excel

Password Manager for incometaxindiaefiling.gov.in user details.

ITR 1 in excel for AY 2014-15 with auto fill function.

Process Payroll in Excel

How to make auto fill forms in excel using linked pictures

Currency count for salary disbursement with special requirement

Billing and debtors management utility for CA's

Excel Tricks

Excel vba pdf : Macro to create bulk pdf in Excel.

Suspicious Email from hacked account to collect the Gmail login details.

Break Link to remove the linked file sources

Large file size due to names with error in excel

Open a particular workbook automatically when excel opened.

Insert table from excel to Gmail or Blogger

Change the comma separator from lakhs to million

Get link
Facebook
X
Pinterest
Email
Other Apps

Popular Posts

Currency count for salary disbursement with special requirement

When the cash salary is to be disbursed to many employees, the currency of different denominations are required to make the payment. Some times currency notes of few denominations may not be available. Before making the payment the payer should be ready with the cash of required denominations. The excel sheet is prepared to calculate the currency notes of different denominations required for paying the amount. The logic is developed considering that there is a shortage of currency notes of Rs. 10. The amounts payable to each employee should be updated in Column "C" and the amount should be rounded off to nearest rupee. When the amount is updated it will show the number of currencies with different denominations required to pay the amount. If any currency with particular denomination is not available the currency value in the top can be deleted and the worksheet will not consider that particular denomination for calculation. The total is also verified with

Income tax assessee profiles and assessment status in excel

In this excel utility Income tax profiles of the assessee's and the assessment status of 3 years can be maintained. Key features: · Assessee's profile details like Name, Address, Mobile No., E-Mail can be stored. · Details for last 3 assessment year can be maintained ( AY 2014-15, AY 2013-14, AY 2012-13) · Link the related file and open by one click. · Open the websites with auto fill of assesse details To create a profile, you have to enter the PAN in the list sheet and double click on the selected PAN to open the profile of the selected PAN. Assessee Profile Details: In assessee profile, you can update Password to Income tax website, date of birth, Name, Address, Mobile No., E-Mail Id. ITR V password and Form 26AS password will be generated automatically in the profile. Three Assessment Year's Details: In this utility you can store three years (ie. AY 2014-15, AY 2013-14, AY 2012-13) assessment details. To nav

Using the $ sign in excel formula to fix the cell reference

If you copy and paste a cell containing formula or drag the cell, the formula reference will also change and move accordingly. For example, if you want to calculate the amount of sales to each customer based on the number of units sold when the sales price is fixed, and the sales price is updated in one cell (B3), you can fix the cell reference of sales price (B3) by putting $ sign like ($B$3) and copy or drag the formula. You can also put the $ sign in formula cell reference by using function key F4. Further, you can also fix only column or only row by using single $ sign like ($B3) or (B$3). In the same example, if you want to estimate the profit margin at different percentages, you can fix the amount column “C” by using ($C6) and fix the percentage row no 5 by using (E$5) and drag the formula to calculate for all customers and for all percentages. This feather is very much helpful in this type of calcul

Powered by Blogger