Latest - Excel

Excel – Examples and guidance for VALUE function- a function for converting string to number

By Laura | 09/20/2014 12:00
To convert a string to a number, Excel supports you a function - VALUE function. Normally, you do not need to use Value function since Excel will automatically convert text to numbers, however, in some cases, VALUE function will be combined with other functions to give users desired result.

Excel – AVEDEV function, calculating absolute deviation average

By Giang Doan | 08/01/2014 13:10
In the analysis and data processing, you have to calculate the absolute deviation average of given variables. AVEDEV function will help you solve this problem quickly and accurately. Let’s follow to know how to use formula and function of AVEDEV.

AVERAGEIFS function, calculating average with multiple conditions

By Laura | 07/28/2014 16:00
You have to calculate average score of subjects or numbers with given conditions. The consideration of conditions will be time-consuming without special tools in Excel. Let’s get to know how to use AVERAGEIFS to simplify this task.

Excel – AVERAGEIF function, calculating average with conditions

By Laura | 07/28/2014 13:00
AVERAGEIF is used for calculating average of cells with given conditions. The function for calculating average with conditions is more sufficient and convenient than the normal function for calculating average.

Excel - PRODUCT function for multiplying

By Giang Doan | 07/23/2014 13:00
To multiply numbers, Excel supports you with a very convenient function-PRODUCT. This function helps you multiply numbers quickly and efficiently.

How to fix errors in Excel quickly

By Giang Doan | 07/21/2014 17:50
When you want to open an Excel file but it has errors and cannot display, it will make you worry since it might be an important contract or a report, ect.

Excel - LEFT function, for cutting left string

By Laura | 07/19/2014 17:50
LEFT function is a function used to cut a string from the left side. Depending on cases, we can use this function flexibly. If you still do not understand about LEFT function and how to apply it, follow the article below to learn more about this function clearly.

Excel – Usage of PivotTable and PivotChart for data analysis

By Giang Doan | 07/18/2014 13:00
You are looking for a method to create statistical reports for the business situation, population growth, ect or any other public figures to serve your work. The solution for you is a combination of Pivot Table and Pivot Chart in Excel. Using these 2 tools, you can easily analyze data, create reports vividly and attractively.

Excel - How to using the SUM function

By Laura | 07/17/2014 19:00
SUM function in Excel is often used to calculate the sum of numbers on a spreadsheet. Using Sum function will help you save a lot of time and effort compared with conventional manual calculations.

Excel - Insert washout text and logo in Excel 2013

By Giang Doan | 07/09/2014 13:00
Watermark helps you mark your products by words and logo. Text, logo or image inserted into your spreadsheet will lie blurry under the text.

Excel - common errors and their solutions

By Giang Doan | 06/19/2014 19:45
While using Excel, it is impossible to avoid mistakes when dealing with functions and formula. Therefore, knowing the causes of these mistakes is necessary for you to come up with the most effective solutions.

Excel – How to create charts, graphs in Excel

By Laura | 04/26/2014 12:00
Graphs are visual performances of the inanimate figures into vivid pictures. In Excel there are many different types of graphs serve different purposes, but not everyone knows.

Excel – LARGE function, returning largest value number k

By Laura | 04/25/2014 12:00
LARGE function points out the largest value number k in a given data arrange, helping you to find your expected value from the rank of that value in the data array.

Excel – MAXA function, returning largest value

By Laura | 04/25/2014 10:00
MAXA function returns the largest value, including logic value and numerical value in document. You can use this function to find out the largest value, highest score in class, etc.

Excel – FREQUENCY function, counting frequently-appeared values

By Laura | 04/24/2014 12:00
FREQUENCY function in Excel returns the results which are an arithmetic array and count the rate of occurrence of values in a certain scale.

Convert Excel to PDF, the best Excel to PDF converter

By Laura | 04/11/2014 12:00
PDF files often have highly security to protect its content, it only allows user to read the content without changing or copying the content on the file.

Critical shortcuts in Excel

By Laura | 04/02/2014 12:00
Manipulating on Excel spreadsheet is not simple if you do not know anything about its shortcuts. Using shortcuts will help you save a lot of time and effort.

Excel – Auto-number columns

By Laura | 04/01/2014 12:00
Numbering column is indispensable when you use Excel spreadsheets. So how to make this manipulation become simple and easy?

Excel – HLOOKUP function - a search function in Excel

By Laura | 03/14/2014 12:00
Hlookup function in Excel is a function for searching and referring by column or row. When you use this function, if the referring conditions are satisfied, the searched value will be the value on a certain cell.

Excel – Round function – round number in Excel

By Laura | 03/14/2014 12:00
Round function is known with the function of rounding number on Excel. We often use several features of this function while having not known all about it. Let’s get to know more about Round function with through this following article.

Excel – Break a line in Excel

By Laura | 03/14/2014 12:00
In Word document, if we want to break a line, we only need to put the entry marker at a certain place and press Enter. However, we cannot apply this method in Microsoft Excel.

Excel – COUNTA function – count data cells

By Laura | 03/13/2014 12:00
COUNTA in Excel is a function which allows you to count data cells at a certain scale. You can use this function in a simple and quick manner.

Dmax function in Excel – Take smallest value in row or column

By Laura | 03/13/2014 12:00
Dmax is a function which returns the maximum value in a column or a row of a list or a data sheet according to a certain condition.

Excel – Dsum function - calculate sum in Excel

By Laura | 03/13/2014 12:00
Excel is an application which provides various functions to make the calculation faster. Dsum is a common function which is used by many people and is a very quick function for calculating sum with a very simple formula.

Excel – Turn column to row in Excel

By Laura | 03/13/2014 12:00
If you have an Excel file in which you input wrong data for column into row or vice versa, what will you do? You will delete data and input them again? It will be time-consuming. Here, will guide you to turn column to row in Excel.

Latest update

Copyright BETDOWNLOAD.COM © 2014 - All rights reserved