ADVANCE FILTER PRIMER
We use AdvanceFilter function when we want to filter our data in data area (database) based on more than one column titles. If we want to filter our data in data area (database) based on one column title only, we use AutoFilter.
We can access the AdvanceFilter function by clicking menu 'Data/Filter/AdvanceFilter'.
Before we use this function, we must have data in a proper data area (database). A data area is a rectangular area of adjacent cells boundaried by a row on top, a row at the bottom, a column in the left and a column in the right. A data area is proper and ready for use by the function if it has the following characteristics :
∙ The cells in the first row of the data area must be used as data titles.
∙ Cells used as data titles must not have a blank cell between each other. (You can start data area from any row, not necessarily the first row of the sheet).
∙ Actual data must appear in rows below the data titles row.
∙ There must not be a row which all its cells are blank in each row below the data titles. (You must have at least one cell in a row which is not blank. Other cells can be blank in that row). If there is a row which all its cells are blank, this row is considered as the last row of the data area.
When we want to use AdvanceFilter, we need to identify what columns titles (or data titles) we want to use as basis of filtering. We identify them by writing the relevant data titles in another area (preferably in other sheet). In that other sheet, we write the data titles in a separate cell in a row (any row) and must be adjacent to each other. In cells below each titles, write the item that we want to see as a result of the filtering. (It could be more than one cell filled with item under each title). The item must be one that is actually available in cells below that title in the actual data area.
The area where we write the selected data titles and the selected items below it is called a 'CRITERIA'.
So, a simple Criteria looks like this :
A
B
C
1
Title A
Title B
Title C
2
xxxx
Yyyy
aaaa
3
bbbb
kk
4
hhh
If we fill the Criteria that look like this :
A
B
1
Title A
Title B
2
xxxx
Yyyy
3
4
This means we want to see rows where each row has item 'xxx' below a data title A AND has item 'yyyy' below data title B. Only rows having these 2 items will get selected, the rest will be hidden.
If we fill the Criteria like this :
A
B
1
Title A
Title B
2
xxxx
3
4
This means we want to see rows where each row has item 'xxx' below a data title A AND has any other item under data title B. Only rows having item 'xxx' under title A will get selected (Data under title B can consist anything). The rest will be hidden.
If we fill the Criteria like this :
A
B
1
Title A
Title B
2
Xxx
Yyyy
3
Aa
4
This means we want to see rows where each row has item 'xxx' below a data title A AND has item 'yyyy' below data title B AND ALSO each row which has item 'aa' below a data title A AND has any other item below data title B . Only rows satisfying these conditions will get selected. The rest will be hidden.
If we fill the Criteria like this :
A
B
1
Title A
Title B
2
xxxx
3
aa
Yyyy
4
This means we want to see rows where each row has item 'xxx' below a data title A AND has any item below data title B AND ALSO each row which has item 'aa' below a data title A AND has item 'yyyy' below data title B. Only rows satisfying these conditions will get selected. The rest will be hidden.
If we fill the Criteria like this :
A
B
1
Title A
Title B
2
Xxx
3
aa
Yyyy
4
This means we want to see rows where each row has item 'xxx' below a data title B AND has any item below data title A AND ALSO each row which has item 'aa' below a data title A AND has item 'yyyy' below data title B. Only rows satisfying these conditions will get selected. The rest will be hidden.
If we fill the Criteria like this :
A
B
1
Title A
Title B
2
xxxx
3
Yyyy
4
This means we want to see rows where each row has item 'xxx' below a data title A AND has any item below data title B AND ALSO rows which each row which has item 'yyyy' below a data title B AND has any item below data title B. Only rows satisfying these conditions will get selected. The rest will be hidden.
By now, you would see that a blank cell in the ‘Criteria’ block represents ANY. A row in the Criteria represents a row in the actual data area.
After you set the Criteria then you can start using the menu 'Data/Filter/AdvanceFilter'.
You can set more than one Criteria in one sheet to serve different filtering.
After the Criteria is ready, activate the sheet which contain the data you want to filter. Click menu 'Data/ Filter/ AdvanceFilter'. You will see a dialog with title 'Advance Filter'.On the right of 'List range' label is your data area automatically identified by Excel. (Check this range. If wrong, click cancel and correct you data setting to follow the rules, and start again). Click on the 'Criteria range' box. Click at the sheet where the criteria that you want to use reside. Select the criteria range. Automatically the 'Criteria range' box will be filled with the address of your selection area (criteria range). Click OK. Your data in the data area will get filtered accordingly (You see only data that you want to see).
Summary
To filter data based on one item in one column, use AutoFilter operation.
To filter data based on more than one item from one column, use 'Custom' in the AutoFilter menu.
To filter data based on more than one item from more than one column, use AdvanceFilter operation.
Tuesday, January 20, 2009
Monday, January 19, 2009
Using ‘Conditional Sum Wizard’ to build an Array Formula
Using ‘Conditional Sum Wizard’ to build an Array Formula
An Array Formula is a formula technique that can be used to sum values in a column based on items in more than one other column.
We will use a sample to show how to use Array Formula to get the total of values in one column (QTY) where two conditions are present in the same row ie column MTH contain item ‘1’ and column ITEM PURCHASED contain item ‘Gum X’.
1. Activate the cell that you want the have the formula.
2. Click menu ‘Tools/ Add-Ins’.
3. A dialog with title ‘Add-Ins’ will appear.
4. If there is no mark ‘right’ in the box to the left of ‘Conditional Sum Wizard’, put the mark by clicking it once.
5. Click OK.
6. The dialog will disappear.
7. Click menu ‘Tools/ Wizard/ Conditional Sum’. (If there is no ‘right’ mark on the left of ‘Conditional Sum Wizard’ in the earlier dialog, this menu will not be available).
8. After a while, a dialog with title ‘Conditional Sum Wizard – Step 1 of 4’ will appear.
9. In the box under the label ‘Where is the list that contains the values to sum, including the column labels’, write the address of your data area.
10. Click the button ‘Next’.
11. After a while, a dialog with title ‘Conditional Sum Wizard – Step 2 of 4’ will appear.
12. In the box at the right of the label ‘Column to sum’, select the column which contain values we want to sum. In this case we select column ‘QTY’.
13. We don’t want to sum all values in the column ‘QTY’ but we want to sum values which satisfy certain conditions that we set. Our conditions is that we will sum values which columns MTH contain item ‘1’ and column ITEM PURCHASED contain item ‘Gum X’ and both items must be available in the same row. We will enter the conditions in the box below the button ‘Add Condition’. We will enter the conditions one by one (initially the box is empty) :
We want to enter the first condition, ie MTH=1.
(To remove a condition, click at the condition, then click button ‘Remove Condition).
14. Click ‘Next’.
15. After a while, a dialog with title ‘Conditional Sum Wizard – Step 3 of 4’ will appear.
16. Select the option label ‘Copy just the formula to a single cell’.
17. Click ‘Next’.
18. After a while, a dialog with title ‘Conditional Sum Wizard – Step 4 of 4’ will appear.
19. Under the label ‘Type or select a cell and then click Finish’, enter the cell address that you want the result to appear.
20. Click ‘Finish’.
21. You will see the result in the cell that you identify in step 19. 22. You can see the formula in the formula bar. You will notice that the formula is preceded with “{“ sign and ended with “}” sign, which indicate that the formula is an Array Formula. If you understand the mechanic of Array Formula, you don’t have to use the ‘Conditional Sum Wizard’ to build the formula. If you edit the cell containing an Array Formula, the braces sign “{“ and “}” will disappear (to put back the formula into an array formula, press ‘Ctrl’, ‘Shift’ and ‘Enter’ keys simultaneously).
An Array Formula is a formula technique that can be used to sum values in a column based on items in more than one other column.
We will use a sample to show how to use Array Formula to get the total of values in one column (QTY) where two conditions are present in the same row ie column MTH contain item ‘1’ and column ITEM PURCHASED contain item ‘Gum X’.
1. Activate the cell that you want the have the formula.
2. Click menu ‘Tools/ Add-Ins’.
3. A dialog with title ‘Add-Ins’ will appear.
4. If there is no mark ‘right’ in the box to the left of ‘Conditional Sum Wizard’, put the mark by clicking it once.
5. Click OK.
6. The dialog will disappear.
7. Click menu ‘Tools/ Wizard/ Conditional Sum’. (If there is no ‘right’ mark on the left of ‘Conditional Sum Wizard’ in the earlier dialog, this menu will not be available).
8. After a while, a dialog with title ‘Conditional Sum Wizard – Step 1 of 4’ will appear.
9. In the box under the label ‘Where is the list that contains the values to sum, including the column labels’, write the address of your data area.
10. Click the button ‘Next’.
11. After a while, a dialog with title ‘Conditional Sum Wizard – Step 2 of 4’ will appear.
12. In the box at the right of the label ‘Column to sum’, select the column which contain values we want to sum. In this case we select column ‘QTY’.
13. We don’t want to sum all values in the column ‘QTY’ but we want to sum values which satisfy certain conditions that we set. Our conditions is that we will sum values which columns MTH contain item ‘1’ and column ITEM PURCHASED contain item ‘Gum X’ and both items must be available in the same row. We will enter the conditions in the box below the button ‘Add Condition’. We will enter the conditions one by one (initially the box is empty) :
We want to enter the first condition, ie MTH=1.
Under the label ‘Column’, select ‘MTH’. Under the label ‘Is:’, select ‘=’. Under the label ‘This value:’, select ‘1’. Click ‘Add Conditions’. The condition will be entered in the box.Now we want to enter the second condition, ie ITEM PURCHASED=’Gum X’.
Under the label ‘Column’, select ‘ITEM PURCHASED’. Under the label ‘Is:’, select ‘=’. Under the label ‘This value:’, select ‘Gum X’. Click ‘Add Conditions’. The condition will be entered in the box. Now there are 2 conditions in the box.We don’t want to enter more conditions.
(To remove a condition, click at the condition, then click button ‘Remove Condition).
14. Click ‘Next’.
15. After a while, a dialog with title ‘Conditional Sum Wizard – Step 3 of 4’ will appear.
16. Select the option label ‘Copy just the formula to a single cell’.
17. Click ‘Next’.
18. After a while, a dialog with title ‘Conditional Sum Wizard – Step 4 of 4’ will appear.
19. Under the label ‘Type or select a cell and then click Finish’, enter the cell address that you want the result to appear.
20. Click ‘Finish’.
21. You will see the result in the cell that you identify in step 19. 22. You can see the formula in the formula bar. You will notice that the formula is preceded with “{“ sign and ended with “}” sign, which indicate that the formula is an Array Formula. If you understand the mechanic of Array Formula, you don’t have to use the ‘Conditional Sum Wizard’ to build the formula. If you edit the cell containing an Array Formula, the braces sign “{“ and “}” will disappear (to put back the formula into an array formula, press ‘Ctrl’, ‘Shift’ and ‘Enter’ keys simultaneously).
Valid Data Area
Below ia a sample of valid data area:
A
B
C
D
E
F
G
H
1
Another sample :
A
B
C
D
E
F
G
H
1
2
X
X
X
X
X
X
X
3
X
7
X
8
X
9
Pivot Table Operation Primer
PIVOTTABLE OPERATION PRIMER
PivotTable function is accessible from menu 'Data/PivotTable and PivotChart report'. This function can be used to generate summaries for our database.
Before we able to use it we must have a proper data area (or database area). A data area is a rectangular area of rows and columns. The topmost row must contain titles in columns. Data must start immediately below the row of titles. Row of titles can start at any row. The titles in the row must be adjacent to each other (not be separated by any blank cell). The last row in the data area is not fixed. It is the last cell in any column which all cells above it contain data without any blank cell in between. If a row contain all cells blank, the last row of the data area is the first row above it. Only one column is required to have non-blank cell to the last row.
4
X
5
X
2
X
X
X
X
X
X
3
X
X
4
X
X
5
X
X
6
X
7
In the above, there are 2 data areas : A2:C6 and E2:F5 (X represent data). A blank column (column D) acts as the separator.
In the following sample, there are 2 data areas ie A2:F4 and D6:D8. A blank row (row 5) acts as the separator :
A
B
C
D
E
F
G
PivotTable is used to summarised data in the data area. It can find totals (values or quantities) of an unique item in data area and combinations of more than one unique item in the data area.
If you want to try the following, make sure you have a data area ready. For working sample, construct a data area with following details: Fill adjacent cells in a row with titles ; Date, Mth, Account-Debit, RM-Debit, Account-Credit, RM-Credit, Item Purchased, Qty purchased, Item sold, Qty sold. Fill data in rows below the titles.
Before we click on the menu 'Data/ PivotTable', we must activate a cell in the data area. This would make Excel recognise the data area (behind the screen). After we click the menu, a dialog box with title 'PivotTable and PivotChart wizard - Step 1 of 3' appear.
Under 'Where is the data that you want to analyze', select 'Microsoft Excel list or database'. (Usually this is automatically selected). Under 'What kind of report do you want to create', select 'PivotTable' (Usually this is automatically selected). Click 'Next'. A dialog box with title 'PivotTable and PivotChart wizard - Step 2 of 3' will appear.
Under 'Where is the data that you want to use', enter the address of the data area (Usually this is automatically selected). (It is good to check the range identified by Excel. If the range address is not as you expect, cancel the operation, correct the data area and start all over again). (If you follow the guidelines on the data area, it should be okay). Click 'Next'. A dialog box with title 'PivotTable and PivotChart wizard - Step 3 of 3' appear.
Click 'layout'. If Microsoft Excel cannot identify a proper data area, the following message will appear :
Otherwise, a dialog with title 'PivotTable and PivotChart Wizard - Layout' will appear.
The top portion (above the grey line) contain simple instruction only. On the right side is buttons representing titles in title row in the data area. You can drag any one button at a time to PAGE box, COLUMN box or ROW box or DATA box on its left and release it there.
If you drag and release the button on the PAGE box, each unique items available under the title in the data area will appear as the main selection in the top portion in the PivotTable report that will be generated.
(You can always drag button out of the PAGE box to revise your selection).
If you drag and release the button on the COLUMN box, each unique items available under the title in the data area will appear in the top rows (in columns) in the PivotTable report that will be generated.
(You can always drag button out of the COLUMN box to revise your selection).
If you drag and release the button on the ROW box, each unique items available under the title in the data area will appear in the left-most columns (in rows) in the PivotTable report that will be generated.
(You can always drag button out of the ROW box to revise your selection).
If you drag and release the button on the DATA box, each total count of items available under the title in the data area which appear under both COLUMN box and ROW box will appear as the count or value in the PivotTable report that will be generated. (You can always drag button out of the DATA box to revise your selection). (Normally we drag button which represent quantity or value into the DATA box, not button which represent text). (This is because DATA box is where totals of count or value will appear).
It is not necessary to put button into PAGE box. You can leave this box without a button. At least, you must have ROW box AND DATA box or COLUMN box AND DATA box filled with button or both.
Some buttons may not be useful for the PivotTable function, so we never drag them into the boxes.
You can put more than one buttons in each box. It is best to experiment to see the result. Only after you do few experiments (say 10) you will be able to predict what form of report will be produced by the PivotTable functions.
After you put necessary buttons into the boxes, click OK. You will get back to the dialog box with title 'PivotTable and PivotChart Wizard - Step 3 of 3'. Click 'Options'. You will get a dialog box with title 'PivotTable Options'.
In the box on the right of 'Name' label, you can give a name for the PivotTable report that will be generated.
The rest are defaults. You can ignore it if you work the first time. Click OK. You will get back to the dialog box with title 'PivotTable and PivotChart Wizard - Step 3 of 3'. Click 'Finish'. A new sheet with the report in it will be presented to you.
Below is a sample result :
In the above sample, 'ITEM SOLD' is a title in the underlying data area. What we see below it (Model A, Model B and Model C) are the unique items available in data under the title 'ITEM SOLD' in the underlying data area. It appears on the left side of the report because we drag the ITEM button into the ROW box (left side) in the layout dialog in step 3 of PivotTable wizard.
If we click on the little arrow-head on the right of 'ITEM SOLD', a list will appear together with OK button and CANCEL button. The list contain all unique items available in the data area under column 'ITEM SOLD'.
Automatically all unique items will appear in the report. We can select which unique item can appear or not appear in the report by marking or unmarking the box at the left of the unique item in the list.
Click OK to make the computer accept our selection and dismiss the list. The report will get updated with the selection. Click 'cancel' to dismiss the list without effecting any changes to the report.
We can change the actual spelling of the unique items in the report without affecting the actual spelling in the underlying data.
In the above sample, 'MTH' is also a title in the underlying data area. What we see in a row immediately below it (1, 2, 3, 4) are the unique items available in data under the title 'MTH' in the underlying data area.
It appear on the top side of the report because we drag the MTH button into the COLUMN box (top side) in the layout dialog in step 3 of PivotTable wizard.
If we click on the little arrow-head on the right of 'MTH', a list will appear together with OK button and CANCEL button. The list contain all unique items available in the data area under column 'MTH'. Automatically all unique items will appear in the report. We can select which unique item can appear or not appear in the report by marking or unmarking the box at the left of the unique item in the list. Click OK to make the computer accept our selection and dismiss the list. The report will get updated with the selection.
Click 'cancel' to dismiss the list without effecting any changes to the report.
We can change the actual spelling of the unique items in the report without affecting the actual spelling in the underlying data.
In the above sample, the word 'Data' on the right of 'ITEM SOLD' refers to the total or sum of numbers (quantity or values). Actually it is a bit misleading. The better word may be is 'Total' or 'Sum' or 'Count'.
The repeated items below it are the items that is get summed or totalled in the report. Sum of QTY' means that it is values under title QTY in the underlying data that get summed. Sum of RM-CREDIT' means that it is values under title 'RM-CREDIT' in the underlying data that get summed.
Sum of QTY' appear on the right side of ITEM SOLD but below MTH because we drag QTY button to the DATA in the layout dialog in step 3 of PivotTable wizard.
Sum of RM-CREDIT' appear on the right side of ITEM SOLD because we drag RM-CREDIT button to the DATA box but below ITEM SOLD button in the layout dialog in step 3 of PivotTable wizard. It appear below 'Sum of QTY' in the report because we drag RM-CREDIT button to below QTY button in the DATA box in the layout dialog.
We can change the spelling of 'Sum of QTY' and 'Sum of 'RM-CREDIT' (in this case) without affecting the underlying data.
If we click on the little arrow-head on the right of 'Data', a list will appear together with OK button and CANCEL button. The list contain all unique items which we drag into the DATA box. We can select which unique item can appear or not appear in the report by marking or unmarking the box at the left of the unique item in the list. Click OK to make the computer accept our selection and dismiss the list. The report will get updated with the selection. Click 'cancel' to dismiss the list without effecting any changes to the report.
If we select only one item from the list, the 'Data' portion of the report will disappear (only values will remain).
We can change the actual spelling of the unique items in the report without affecting the actual spelling in the underlying data.
If we drag only one button into the DATA box in the layout dialog, the 'Data' portion of the report will disappear (only values will remain).
Sometimes, when we drag a button into DATA box, the default in the result is a count of item instead of a sum of the item.
If we want to find the sum (which usually is) : Right-click on the report. A floating menu will appear. Select 'Wizard'. We will get the step 3 of the PivotTable wizard. Click 'layout'. We will get the 'Layout' dialog box.
Look at the buttons inside the DATA box. If you find the word 'Count of' on a button and you want to change to 'Sum of' :. Double-click on the relevant button. A list will appear. Under 'Summarize by', select 'Sum' from the list. Click 'OK'. We will come back to the 'Layout' dialog box. Now notice the 'word 'Count' is replaced with 'Sum'. Click 'OK'. We will come back to the step 3 of the PivotTable wizard. Click 'Finish'. The report will get updated and the figure in the report is now a sum instead of a count.
You can format the report and the content of the report in the normal way you use formatting in Excel.
Eg, you can format numbers, font etc.
You can change and edit the content (numbers and words) in the report the normal way we do in Excel.
The report does not contain any formulas.
You can delete the sheet and the the Report to save disk space, if you want. You can always rebuild it again.
If you make any changes in the underlying data, you may want to update the report (if you do not delete the report). Just click any cell in the report, then right-click once. A floating menu will appear. Select 'Refresh'.
The report will get updated.
If you want to create another report, you may get this dialog :
Please read the message in the dialog. This message dialog appear after you click 'Next' on the step 2 dialog in the PivotTable wizard. You will not get this message dialog when you build a first report. This message simply means that Excel has detected that you are working on the same data area which a report has already exist. You are given an option whether you want to use the current report as a basis for your new report. If you use the current report, it means Excel will use the same underlying data in the new report.
This will save memory and will avoid Excel from getting slower and also safe your disk space and keep your Excel file smaller. This is the best choice (selecting 'Yes') in the dialog.
Please read the message in the dialog. This message dialog appear after you click 'Next' on the step 2 dialog in the PivotTable wizard. You will not get this message dialog when you build a first report. This message simply means that Excel has detected that you are working on the same data area which a report has already exist. You are given an option whether you want to use the current report as a basis for your new report. If you use the current report, it means Excel will use the same underlying data in the new report.
This will save memory and will avoid Excel from getting slower and also safe your disk space and keep your Excel file smaller. This is the best choice (selecting 'Yes') in the dialog.
We can use a shortcut way to build a report. Click any cell in the data area from which you want it to be a base for your report. Click menu 'Data/ PivotTable and PivotChart Report'. A dialog with title 'PivotTable and PivotChart Wizard - Step 1 of 3' appears. Click 'Finish'. You will be presented with a new sheet. In the new sheet you will have a few boxes. You will see boxes with the following instructions :
‘Drop Page Fields here',
'Drop Row Fields here'.
'Drop Column Fields here'.
'Drop Data Items Here'.
You also see dialog box containing buttons representing the column titles on the underlying data area.
You can drag one button at a time into a box to form a scheme of your report (the same way you do in the Layout dialog). The box with 'Drop Data Items Here' preferably be the last box which you drag a button into.
As soon as you drag a button into the 'Drag Data Items Here' box, the port will be ready for you.
Thursday, January 1, 2009
Contacting the author
Contacting the Author
The′ author can be contacted at e-mail address ibh1@live.my
The′ author can be contacted at e-mail address ibh1@live.my
Tuesday, January 1, 2008
Back cover
BOOK-KEEPING WITH MICROSOFT EXCEL
Microsoft Excel has long been used to help in book-keeping and accounting tasks. This book shows how you can use Microsoft Excel for all your book-keeping tasks in a small or medium-sized business. Book-keeping tasks here include recording of data from various sources, and the preparation of Trial Balance, Balance Sheet, Profit & Loss statement and other reports.
You will see how formulas can be used to automate updating of your Trial Balance, Balance Sheet, Profit & Loss statement and other reports. No programming at all is required. Using Excel's AutoFilter, CustomFilter, AdvanceFilter and Pivot Table operations, you can get the necessary listings, summaries, and totals quickly.
Just follow the steps outlined in this book to build the data file, set the formulas and functions, and you will be ready to enter data. If you do not want to build the file from scratch, you can use the sample file provided with this book.
WHO WOULD BENEFIT FROM THIS BOOK?
Book-keepers, Accounts Assistants, Account Executives. Accountants and Accounting students will find this book of interest. In fact, anyone with a basic book-keeping knowledge and some familiarity with Microsoft Excel will be able to understand and use the materials presented in this book.
BONUS
For newbies, there is a beginner's guide on book-keeping at the end of the book. There is also an explanation of Excel's Pivot Table and AdvanceFilter operations.
ABOUT THE AUTHOR
The author has a Bachelor of Accounting degree and clocked up more than 18 years of experience in the accounting line and its related fields. 1 Through the years, he has continuously explored ways of using his computing knowledge to assist him in his work. In this book, he shares with readers his knowledge gained from his hands-on work.
TIMES
The companion CD contains sample data for you to try out the operations mentioned in this book and familiarize yourself with the system.
983-58-0889-9
9 789835 808890
Microsoft Excel has long been used to help in book-keeping and accounting tasks. This book shows how you can use Microsoft Excel for all your book-keeping tasks in a small or medium-sized business. Book-keeping tasks here include recording of data from various sources, and the preparation of Trial Balance, Balance Sheet, Profit & Loss statement and other reports.
You will see how formulas can be used to automate updating of your Trial Balance, Balance Sheet, Profit & Loss statement and other reports. No programming at all is required. Using Excel's AutoFilter, CustomFilter, AdvanceFilter and Pivot Table operations, you can get the necessary listings, summaries, and totals quickly.
Just follow the steps outlined in this book to build the data file, set the formulas and functions, and you will be ready to enter data. If you do not want to build the file from scratch, you can use the sample file provided with this book.
WHO WOULD BENEFIT FROM THIS BOOK?
Book-keepers, Accounts Assistants, Account Executives. Accountants and Accounting students will find this book of interest. In fact, anyone with a basic book-keeping knowledge and some familiarity with Microsoft Excel will be able to understand and use the materials presented in this book.
BONUS
For newbies, there is a beginner's guide on book-keeping at the end of the book. There is also an explanation of Excel's Pivot Table and AdvanceFilter operations.
ABOUT THE AUTHOR
The author has a Bachelor of Accounting degree and clocked up more than 18 years of experience in the accounting line and its related fields. 1 Through the years, he has continuously explored ways of using his computing knowledge to assist him in his work. In this book, he shares with readers his knowledge gained from his hands-on work.
TIMES
The companion CD contains sample data for you to try out the operations mentioned in this book and familiarize yourself with the system.
983-58-0889-9
9 789835 808890
Subscribe to:
Posts (Atom)