Name Box in Excel Function Formula

Name Box in Excel Function Formula

The name box is to name or mark a cell or table (several cells or range of cells) by name, which name, data in cells or tables can be called. Here I will give an example of naming a cell and naming a table, then with that name will be used through several function formulas.

Well, let’s start with the following example.

 

http://www.excel-foraccounting.com/box-excel-function-formula.html

Determine the Excel Printing Area

Determine the Excel Printing Area

Continuing the previous post related to the Page Setup – Sheet command window, we will discuss the Print Area or the printing area of ​​the excel worksheet. This Print Area is one of the printing tricks in Excel that we can do by determining the printing area that we want.

To open the Page Setup – Sheet command window, go to the Page Layout > Page Setup menu and select the Sheet tab.

http://www.excel-foraccounting.com/determine-excel-printing-area.html

Knowing Birth and Age with Excel

 Knowing Birth and Age with Excel

Just curious about our age, what day we were born and how old are we up to now? We can use several formulas in Excel. Immediately we practice through the following picture.

Complete colored cells with the following excel formulas:

Sel C2 =NOW()
Sel C4 =TEXT(C3,”DDDD”)
Sel C5 =(C2-C3)/365

http://www.excel-foraccounting.com/knowing-birth-age-excel.html

Some Elements of Print Results for Excel Worksheets

Some Elements of Print Results for Excel Worksheets

Continuing the discussion about the Page Setup – Sheet command window, the following post discusses:
– Gridlines
– Black and White
– Draft Quality
– Row and Column Heading.

Namely some form of display in the printout or print out, among which there are several worksheet elements that can be displayed in the printout, such as including gridline (help lines) in print, displaying rows and columns (column headings and rows) in print.
Get sick first, open the Page Setup – Sheet window. To open the Page Setup – Sheet command window as follows.

To open the command window of Page Setup – Sheet via the Page Layout > Page Setup menu then select the Sheet tab.

 

http://www.excel-foraccounting.com/elements-print-results-excel-worksheets.html

Numbering Excel Customize Pages

Numbering Excel Customize Pages


When you work with Excel using multiple sheets, then you expect when you print or print pages on each sheet so that they are continuous. Even though it needs to be known, page numbering is done through the footer or header which by default on each sheet, numbering the page starts with number 1. Now, how do you make the page numbering in each sheet sequentially sequential when printed or printed. Let’s follow the steps below:

(1) Make page numbering through Footer or Header, that is through the Page Setup menu. To open the Page Setup menu there are 2 (two) ways, namely through the Print Preview menu and through the Page Layout menu.

Through the Print Preview menu:

Click the Office Button button, select Print then Print Preview, as follows.

 

http://www.excel-foraccounting.com/numbering-excel-customize-pages.html

Creating a Percentage Pie Cart in Excel

Creating a Percentage Pie Cart in Excel

Pie charts are usually used to describe division pieces in a circle. Pie charts in a circle in which there are division pieces, usually the division will be more meaningful if the percentage value is added to the division pieces. Example of a Pie chart like the following picture.

Now how do you make it? The following explanation explanation.

http://www.excel-foraccounting.com/creating-percentage-pie-cart-excel.html

Combine the Criteria in the Function Formula

Combine the Criteria in the Function Formula

To illustrate the purpose of the title above, we illustrate through the following picture. To apply it, please create it first in Excel like the table in the picture.

In the picture above, the table on the left is the raw data table, while the table on the right is the data output table that we have to process based on the data on the right. How, here we will use the SUMIF Function Formula and we will combine (combine) the criteria in the function formula.


http://www.excel-foraccounting.com/combine-criteria-function-formula.html

Creating Bar Graphs through Conditional Formating Menu

Creating Bar Graphs through Conditional Formating Menu

Following is the data table that we will make graph using the Conditional Formating menu.

Next Block the “Sales” value column, then click the Conditional Formating menu and select one of the color bar options on the right.

http://www.excel-foraccounting.com/creating-bar-graphs-conditional-formating-menu.html

Looking for Maximum and Minimum Values

Looking for Maximum and Minimum Values

The following excel formula trick is how to find a value, maximum and minimum value in a range of values. This trick can be used by school teachers who are accustomed to processing student data related to the highest and lowest grades of students, or by anyone who wants to determine the lowest and highest data values ​​as analysis material, such as sales value and so on.

For more details, how can I illustrate this case as shown in the following table.

http://www.excel-foraccounting.com/maximum-minimum-values.html

Excel Formula Function COUNT

Excel Formula Function COUNT

The COUNT function to count the number of cells containing numbers or numbers in a list.
The form of writing the formula for the COUNT function formula is as follows:
= COUNT (value1, value2, …)
Value1, value2, … and so on are data that can contain various types of data, but the COUNT function only calculates data that is number or number, which is counting how many numbers or numbers are contained in the list.

http://www.excel-foraccounting.com/excel-formula-function-count.html

Straight-Line Depreciation System by Excel

Straight-Line Depreciation System by Excel

The calculation for the depreciation of fixed assets needs to be done, because the value of the benefits provided by the asset will be reduced, according to the time of usage. Depreciable amount is allocated to reduce the cost value of assets.

To calculate the depreciation of fixed assets can be done manually. However, if the number of assets to be counted many kinds, it will take a long time and the accuracy of the calculation is not necessarily guaranteed.
Straight-Line Depreciation System by Excel is an answer to the needs of the system. With a fairly simple system, the system is able to provide information depreciation of fixed assets with a fairly complete. Of the many number of assets that we input into the system can be calculated quickly and accurate results.

http://www.excel-foraccounting.com/straightline-depreciation-system-excel.html