Office information

Instructions on how to aggregate data in groups in Excel. With a large amount of data, statistical data is very complicated. Here, with Excel 2013, the Subtotal feature helps you

Guide you to create tables in Excel. To create the table you perform the following steps: Step 1: Go to the Insert - Tables - Table tab: Step 2: The Create Table dialog box appears

Instructions on table operations in Excel. When working with tables you should pay attention to the following: 1. Edit the width of rows and columns. There are many ways to edit

Instructions to manipulate tables in Excel. 1. Insert rows and columns in the table: - For example, want to insert 1 column after salary column 1 day: Step 1: Select the column

Instructions on how to format borders and background colors for tables in Excel. Step 1: Select the table you want to create a border for - Design - Quick Styles - select the table

PDF is the most commonly used file format. With this format will minimize the editing of content. The following article introduces you to the top 3 best pdf file readers today.

Instructions on how to round numbers in Excel, help calculate faster Depending on how to round the number of digits after and before the comma, there are many number rounded

Instructions on how to reduce the size of Excel files. In order to reduce the file size, you need to determine the reason why your file size is very large. If you can't find it,

The following is a guide to page numbering in Word, aligning page numbers, and deleting page numbers to help you locate and search easily in large documents.

COVARIANCE.P function: Returns the covariance of the population, the average of the product deviations for each pair of data points in the two data sets Syntax: COVARIANCE.P

COVARIANCE.S function: Returns the covariance, the product of the deviations for each pair of data points in two data sets Syntax: COVARIANCE.S (array1, array2)

INTERCEPT function: The function returns the point at which the line will intersect the y-axis by using existing x and y values. Use the function when you want to determine the

MODE.SNGL function: The function returns the most frequently occurring, or the most repeated value in an array or range of data. Support functions from Excel 2010 onwards. Syntax:

NORM.S.INV function: The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1. Support from Excel 2010 onwards.

PERCENTRANK.EXC function: The function returns the rank of a value in a dataset as a percentage excluding values ​​0 and 1. The function supports Excel 2010 and later versions.

PERCENTRANK.INC function: The function returns the rank of a value in a dataset as a percentage including values ​​0 and 1. The function supports Excel 2010 and later versions.

PROB function: The function returns the probability that values ​​in a range are between two limits. Syntax: PROB (x_range, prob_range, [lower_limit], [upper_limit])

RANK.EQ function: The function returns the rank of a number in a list of numbers whose size is in correlation with other values. If multiple values ​​have the same rank -> the

The following article shows you how to manipulate blocks in Excel. Frequently used operations in spreadsheets when working with blocks: 1. Select blocks of contiguous cells. Place

Show you how to enter formula data in Excel. Working with Excel you can not help but work with formulas and functions in Excel. Formula data input is a type of data entry through