Category Archives: Excel

What is Chart in Excel? How to use Chart in Excel

Charts Overview A chart is used to display your data in a visual or graphical format, making it much easier to understand large quantities of data and the relationship between different series of data. A chart can also show the big picture so that you can analyse your data and look for important trends. How to create a… Read More »

What is COUNT Function in Excel?

Using the COUNT Function in Excel. The Count Function can be used to count the cells in a range that contains numbers. To use the COUNT function, follow these step: 1.   Open the workbook you want to use COUNT the function on. 2.   Click an empty cell where you want the result to be displayed. 3.… Read More »

What is Average Feature in Excel?

Using the Average Feature in Excel. Average feature in excel is use to divides a list of numbers and divides by the number of numbers. To make it simpler, when you are working out the average exam score of students result, you add up all the total number of students result and divide the total with the number… Read More »

What is Max. and Min. Functions in Excel?

 Use the  Max. and Min. functions feature in Excel. You can use the Max. Function in excel to find and display the largest number in a selected range in a worksheet. Min. function is used to find and display the smallest number in a selected range of cell in a worksheet. These functions are specially used on a… Read More »

What are Excel Functions?

How to Use  the Functions feature Excel. Excel functions are specialized formulas that you can use to make calculations easier. Just as you use the Sum formula to calculate totals in cells range, so does other functions in excel such as Average, Min, Max andCount can also be used to make your calculation simpler. When using functions, it can… Read More »

How to Protect Your Excel Worksheet with a Password.

Protecting Your Excel Worksheet with a Password. In Microsoft Office Excel, you can use passwords to help prevent other people from opening or modifying your Worksheets. Once the document is protected by a password, it cannot be opened even if sent through an email as an attachment or transferred to another device unless the right password is entered.… Read More »

What is Text to Speech Feature in Excel?

How to convert texts to Speech in Excel. Microsoft Windows office 2007- 2010 accessibility features offer the Text-to-Speech commands in Excel. This feature enables your computer to play back written text or numbers as spoken words in an Excel worksheet. After you have added the Speak command to your Quick Access Tool, you can hear single words or… Read More »

What is Auto Sum In Excel?

 Calculating with the Auto Sum In Excel. Adding of numbers is the most mathematical operation ever used. Microsoft Excel makes adding of numbers so simple by using the AutoSum if you understand how to use the formulas involved. The Auto sum can be found on the Ribbon Tabs (Home and Formulas) On the Home tab, auto sum button… Read More »

What is Excel Formulas?

Calculating with Excel Formulas. Excel is more than just grid lines and cells in which you enter numbers in columns or rows. You can use Excel to find totals for a column or row of numbers, also calculate a mortgage payment, solve math or engineering problems. Excel does these calculations by using formulas in cells. A formula performs… Read More »