i would like to create payroll worksheet in excel.?
962883
easiest thing is to look through microsoft's website for templates. \nhttp://office.microsoft.com/en-us/templates/results.aspx?qu=payroll&av=TPL000
1090153
What goes in: Every invoice or receipt that is paid out. Labor, lumber, permit fees, pizza for the local kids who might help, etc.\n\nIf you're computer-savvy, Microsoft Excel is a simple but competent way to keep track of the expenses. If not, then feel free to do it the old-fashioned way by pen and ink.\n\nSimplest way to organize it would be a sequential listing by month. At the end of the month, tally the month's expenditures. If you want information by category, e.g., how much have we spent on lumber to date, then you could make the colums as categories. In that case, a computer program such as Excel would come very much in handy but it's not critical.\n\nBest of success.
220375
Try Microsoft Office templates.
1013881
Look at other procedures within your office. Surely they follow some sort of template.\n\nI suggest doing that. Look at the other procedures and copy the format.
128367
There is actually a good one as a sample spreadsheet template in Microsoft Excel. there is even a better one in the older versions of Microsoft Works spreadsheet tool.
943817
[EDIT - DELETED A WHOLE BUNCH OF TEXT]\n\nthat kind of thing is complex to create in a macro form, normally the kind of thing that you'd pay someone to do because i'd imagine it's easily a couple of hours work to write all the code, test it, iron out bugs etc. there *may* be a built in function in excel to do something like this but i wouldn't have thought so - i'm happy to be proved wrong:\n\n----found on t'internet----\nA1:A10 (your list of values)\nB1:B10 (leave blank)\nC1: =A1*B1 (copy thist fomula down through to C10)\nC11: =SUM(C1:C10)\n\nNow to use Solver....\nTools>Solver\nSet Cell: C11\nEqual to the Value of: 1173.76\nBy Changing Cells: B1:B10\nSubject to the Constraints....\n(click the add button and constrain B1:B10 to Binary)\nClick [OK]\nClick [Solve]\n\nExcel will toggle cells B1:B10 between 1 and 0 until it comes up with a combination that sums to 1,173.76\n----end of instructions----\n\nit depends on the setup of your spreadsheet - if it's one huge page that's a jumble of undistinguishable invoices with no reference to who the invoices belong to, it means manually checking the results of the macro for the set of results that applies only to one 'customer'. ideally you'd want a seperate sheet for each customer and then the macro or above method can be ran on whichever sheet/customer the cheque is from.\n\ni dunno about other people on here but i wouldn't spend hours of my time creating such a thing for the sake of 10 points which aren't really worth anything - i CAN tell you that if the above method doesn't do the job that it'd mean creating a loop that will add up every possible combination of totals from the sheet then comparing it each time against the grand total until it gets a 'hit'.\n\ni can't imagine this kind of sorting being practical for huge amounts of figures, probably a list of 20 at most because you could get into some big big processing time otherwise.\n\ni would be interested in hearing anyone elses ideas about doing it?
421773
MS access will do that, \n\nlookfor help in excel for JET or OBDC
1036250
Collect the sum of the overhead for your business.\nCount how many instances of overhead.\nThe average will be the sum / count.\n\nMake a cell with the formula:\n'=SUM(start_col_row : end_col_row)'\nEg, B1 '=SUM(A1:A14)'\n\nMake another cell with this formula:\n=COUNT(start_col_row : end_col_row) '\nEg, B2 '=COUNT(A1:A14)'\n\nMake yet another cell with this formula:\n=(cell_with_sum / cell_with_count) * 100'\nEg, B3 '=(B1/B2) * 100'\n\nThis gives the average overhead in percentage, for your business.\n\nHow you do the comparison of your average vs. national average is entirely up to you.  You could just look, you could take yours away from the national, etc.
290527
If you have Microsoft Excel, this link may help:\n\nhttp://www.unc.edu/~beyle/pres--012306.xls\n\nDetails on how they came up with it, and a link to that spreadsheet can be found here:\n\nhttp://www.unc.edu/~beyle/jars.html
720830
You can create one yourself if you want. Just include:\nDate, To, To #, From, From #, # of pages (including cover sheet) being faxed, and Message.
995900
It depends on how you have your other amounts organised.\n\nIf you have a column or row that is for periodic end amounts, eg, weekly totals.  You can set up a range for these.  For an example, assume the column A holds the weekly totals.   They start from A1 and finish A52.\n\nCreate a new cell and type this formula, without the quotes:\n'=sum(A1 : A52)'\nThats it.
1101710
You don't NEED to create a new procedure (actually, it would be a function, not a procedure, if you want it to return the answer), because you can use the Click() procedure of the "calculate payroll" button, but like the procedure, there's no place for the answer unless you use a Text box for the results of the calculations.  Whereas a function will return the value you want into a local variable and you can continue using the results of your calculations.
1135073
If you have a spreadsheet application like Microsoft Excel, then you can place all the items of the buget into the columns or rows of the spreadsheet.  How you have them organised is up to you.\n\nIf you want a sub total, for some items, but not others, etc, you could make a cell.  A cell is the name of the component where you type stuff in.  In this cell, you would want to write something like '=sum(B3:B4)' if you had some buget items in cells B3, and B4.\n\nExample:\n----------------------------------------------\n| - |          A          |          B           | \n| 1 | Mum             |                        |\n| 2 | Income         |                        |\n| 3 | Employment |   $10.00         |\n| 4 | Investments |    $20.00         |\n| 5 | Sub-Total     | =SUM(B3:B4) |\n\n'=SUM(B3:B4)' would be viewed as $30.00\n\nIf you want to make a total, it is the same as making a sub-total, except you would want to use more cells for the sum.\n\nFor more help on the 'sum' function, check the help included with Microsoft Excel under the topic 'sum' or 'function' or both :)
497451
Create a PivotTable report   \nShow All\nHide All\nOpen the workbook where you want to create the PivotTable report (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.). \nIf you are basing the report on a Web query (Web query: A query that retrieves data stored on your intranet or the Internet.), parameter query (parameter query: A type of query that, when you run it, prompts for values (criteria) to use to select the records for the result set so that the same query can be used to retrieve different result sets.), report template (report template: An Excel template (.xlt file) that includes one or more queries or PivotTable reports that are based on external data. When you save a report template, Excel saves the query definition but doesn't store the queried data in the template.), Office Data Connection file, or query file, retrieve the data into the workbook, and then click a cell in the Microsoft Excel list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) containing the retrieved data.\n\nIf the retrieved data is from an OLAP (OLAP: A database technology that has been optimized for querying and reporting, instead of processing transactions. OLAP data is organized hierarchically and stored in cubes instead of tables.) database, or the Office Data Connection returns the data as a blank PivotTable report, continue with step 6 below.\n\nIf you are basing the report on an Excel list or database, click a cell in the list or database.\n\nOn the Data menu, click PivotTable and PivotChart Report. \nIn step 1 of the PivotTable and PivotChart Wizard, follow the instructions, and click PivotTable under What kind of report do you want to create? \nFollow the instructions in step 2 of the wizard. \nFollow the instructions in step 3 of the wizard, and then decide whether to lay out the report onscreen or in the wizard. \nUsually you can lay out the report onscreen, and this method is recommended. Use the wizard to lay out the report only if you expect retrieval from a large external data source to be slow, or you need to set page fields (page field: A field that's assigned to a page orientation in a PivotTable or PivotChart report. You can either display a summary of all items in a page field, or display one item at a time, which filters out the data for all other items.) to retrieve data one page at a time. If you aren't sure, try laying out the report onscreen. You can return to the wizard if necessary.\n\nDo one of the following: \nLay out the report onscreen\n\nFrom the PivotTable Field List window, drag the fields with data that you want to display in rows to the drop area labeled Drop Row Fields Here. \nIf you don't see the field list, click within the outlines of the PivotTable drop areas, and make sure Show Field List  is pressed in.\n\nTo see what levels of detail are available in fields that have levels, the click  next to the field.\n\nDrag fields with data that you want to display across columns to the drop area labeled Drop Column Fields Here. \nDrag fields that contain the data that you want to summarize to the area labeled Drop Data Items Here. \nOnly fields that have the  or  icon can be dragged to this area.\n\nIf you add more than one data field, arrange these fields in the order you want: Right-click a data field, point to Order on the shortcut menu, and use the commands on the Order menu to move the field.\n\nDrag fields that you want to use as page fields to the area labeled Drop Page Fields Here. \nTo rearrange fields, drag them from one area to another. To remove a field, drag it out of the PivotTable report. \nTo hide the drop area outlines, click a cell outside the PivotTable report.\n\nNote  If data is very slow to appear as you lay out the report, click Alw
1120124
Not sure if this is what you mean, but ...\nCreate an Excel sheet,\n\nRow 1 is the titles, in this order\nDate, Value, Sale, Month 1, Month 2, ... Month 6, Month 7, Sale Total, Accumulated Total.\nYou can use whatever titles you want.\n\nIn Row 2,\nLeave Date and Value blank.\nIn Sale, type '=B2*0.045',\nIn each month, eg, Month 1, Month 2, etc, type '=B2*0.025'\nIn Sale Total, type '=SUM(C2:J2)'\nIn Accumulated Total, type '=SUM(K2)'\nSelect the columns, C2 to K2, then grab the little square in bottom right hand corner of the selection you just made.  Hold you mouse button down, go down the page to how many entries you want.\n\nThe only thing you will have to do manually, is to update the Accumulated Total column.\nRow 3, =sum(k2:k3)\nRow 4, =sum(k2:k4),  etc
204627
http://redcort.com/timeclock.html\n\nIf you are looking for a simple solution use a template for Microsoft Excel:\n\nhttp://office.microsoft.com/en-us/templates/TC011201441033.aspx
968999
Perhaps if you phrased your questions as ideas, \n\nLike, \n\n"I'm going to use Excel to create a spreadsheet and enter all the data that way." \n\nIt will give your boss a chance to say, "No I want you to enter the data through...." or say, "Yes, that would work well." \n\nOr, there's always the option of Monster.com