The keyboard plays a vital role in the excel spreadsheet execution. Most people do not know that all the operations in excel can be managed by using a keyboard even without involving the mouse. Shortcuts 1. Row and column select; when you want to have quick access to highlight or select the column and
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
1. Excel formula for percentage change Normally in mathematics, the percentage change is usually given by; %Change = (change/initial value) *100. The change is usually a difference between the two values in context. Change =new value-old value. We can also accomplish this task quickly and easily in excel. So supposing we need to find the
We can print a worksheet in excel just like we can do for word documents. 1. Previewing before print: It is always advisable to preview an excel document before the actual printing of the document. This helps one correct error and make changes where necessary. To preview a document in excel: Procedure: 1. Open a
The IF function is one of the most commonly used in Excel. The function can test a single condition as well as perform multiple complex logic tests. We can thus control the execution of Excel tasks using the IF function. This is important since it enables us to perform actions depending on whether they meet
A hyperlink enables users to navigate to a related webpage or file. In simple terms, this a "linked shortcut" that directs to a specified webpage or file location when clicked. Hyperlinks are usually highlighted in blue color and are a quick way of connecting to related information or program. Another use of hyperlinks includes the
Microsoft Excel is a powerful Microsoft application that business owners are utilizing today. This application combines simplicity with efficiency to increase business productivity. With so many tasks that you can perform using this application, there's room for you to learn new skills each day. The main reason why many people choose this feature of conditional
Formatting makes our documents look appealing to our eyes. The power of conditional formatting is far-reaching. Excel has not been left behind since we can use a specific formula to format our worksheets to our own liking. In this case, the formula should apply a given colour to alternate rows. This will enable an easy
The process of amortization involves paying back a loan for a given period of time until the loan is fully paid. For a long time, amortization calculation used to be done using a pen, paper and calculator but things are now changing. We can calculate loan amortization in Excel using formulas. Some of the basics
The AVERAGEIF function is one of the most useful functions since it enables Excel users to perform averages only on cells that meet the specified criteria. This function accepts a minimum of two parameters. However, you can choose to add the third parameter if you like. The compulsory parameters include Range and criteria. The range