USING FUNCTION METHOD OF CALCULATION

Functions in Excel are the in-built method of calculation, which can be invoked anytime the user wants to make use of it. e.g SUM for addition, MAX for maximum and IF – for conditional statement known as logical function.   STATISTICAL FUNCTIONS SUM...

Read More

CALCULATIONS IN MICROSOFT EXCEL

Calculation is the process of computing formulas and then displaying the result as values in the cells that contain the formulas.   It is very easy to perform Arithmetic & Logical operations or calculations in Microsoft Excel. In Microsoft...

Read More

COMPONENTS OF MICROSOFT EXCEL

TITLE BAR: This is a bar at the top of an application or document that indicates its Name. MENU BAR:This is a list commands displayed below the title bar of an application which when click draws down a pull down menu. STANDARD TOOLBAR: A...

Read More

INTRODUCTION TO ELECTRONIC SPREADSHEET

Electronic Spreadsheet is a financial management system use in calculating and analyzing numerical data. It is a windows application program or software that provides users with a powerful spreadsheet features and environment. It is referred to as...

Read More

Excel MIN and MAX Functions

Find the lowest and highest values with the MIN and MAX functions. Use with the IF function, to create MIN IF and MAX IF formulas. MIN Function To find the lowest value in a range of cells, use the MIN function. For example, this formula will find...

Read More

VLOOKUP Examples And Videos

How to use a VLOOKUP formula to get data from an Excel list. Troubleshoot VLOOKUP when things go wrong. Step-by-step videos and free workbooks with VLOOKUP examples. VLOOKUP Video Watch the steps for creating a VLOOKUP formula in the Product Price...

Read More