Admin 
Switching to excel 64 bit may be necessary since 64-bit window versions have more resources like memory and high processing power as compared to the 32bit. Therefore, in a case where you have large files or you are working on large data sets and your computer supports 64 bit on windows. Changing your excel to
In excel, you can lock and keep one cell constant. There are two types of cell references in excel namely the relative and absolute cell references. The Relative reference will change when the formula is copied to another cell. On the other hand, the absolute reference cell will remain constant no matter. Most excel users
Discount is the amount deducted from the regular price of a commodity. This is usually found by deducting the selling price from the regular or marked price of a commodity. Discount can also be expressed in percentage by taking the regular price multiplied by the rate of discount. Regular Price × Rate of Discount =
Compound interest is where interest is credited on a loan or deposit considering the initial principal and the cumulative interest from the time before. A good example is when you invest 700,000/= with a 10% annual interest rate compounded annually. When a year lapses from the initial principal, you get 70,000/= (700,000 x 0.10) as
We have two ways in which we can use to combine data in excel i.e using the merging cell option and the concatenate cell value. What is concatenate in excel? Concatenate is a process in excel that involves combining a few pieces of text or value that are in different cells. Concatenate focuses on combining
The pound is the name of several units of mass, ranging from 300 to 600 grams. Kilogram KG is the SI unit for mass. 1 lbs (pound) = 0.45359 kgs or 1Kg= 2.20462. Having known how kilograms and pounds relate, it is easy to convert from one unit to the other. Conversion using excel Conversion
A signature line in Excel resembles a typical signature placeholder that might appear in a printed document or file. An Excel document having a signature added to it, no edits are permitted to the document without invalidating that signature. This allows you and others to know that a document has been viewed and approved as
Sometimes we may have a lot of experience in using our computer, especially the excel app yet there are things yet that we have not learned. Simple as they may appear, they remain to be trouble and difficult when we reach a point where we need to use them Method 1 You can use this
With the increased arithmetic functions of excel, it's important to know how dates are stored since it appears in most excel tasks. Excel normally stores dates in form of numbers referred to as date -serial numbers to help during calculations. A date is usually given a numerical value starting from 1/1/1900 in excel. This is
Software errors are almost unavoidable. MS Excel is not an exception either since one is likely to encounter some errors during day to day use of this spreadsheet program. When they occur, errors must be debugged or corrected effectively. Some of the few general reasons that lead to errors include wrong syntax, incompatible inputs as