Sabtu, 11 Agustus 2018

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.


Jumat, 10 Agustus 2018

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

Kamis, 09 Agustus 2018

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.



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