I am trying to show you concrete examples of how to use formulas and macros in Excel 2010. Many users search for how to calculate your monthly schedule, the repayment schedule of a loan, the sales analysis to the bank account and make handling workbooks. I am providing all tricks that can be useful for you too. Excel is probably the most versatile and effective program from the Microsoft Office package. It can be used as well as for sophisticated analysis and reports for lists, tables and simple calculations. So PC WORLD is based on Excel as already developed an MP3 player program and a file manager). Against complex of three right, but practical examples can be found here, the tricks that you use formulas and macros for many purposes, right: A is used to calculate your overtime, another to set up a payment schedule for a loan, and the third for analysis of cash flow on your bank accounts. The menu names used here refer to the Excel versions 2003, 2007 and 2010. In older versions from Excel 97 are similar to the designations in the rule where the 2003 version.
To calculate your monthly working
Open the file "Employment.xls, located in the sample files with Excel 2010. In it you need to program anything yet. All tasks can be solved only through the skillful use of formatting and formulas.
Cell as a date or time format
To track your daily working time for one month, you need cells for dates, times and number of hours. You can use Excel to assign each cell a specific format. In the sample file that is already done. Check here as the cells B4 to B25 (B4: B25), by clicking in the first and widen the selection by pressing the left mouse button down. Then click the right mouse button on the label and choose Format Cells. This will open a window where you can select the left under "Category", which type of data in the selected cells are mentioned later in this case "Date". To the right you can choose type, such as the date values to be displayed, 03/14/2001. In the same way you can in the cells E4: G25 see that the format of "Time" is of type "13:30" specified. If you want to calculate the total hours worked, as has happened in cell I28, then the format will help "time" would not achieve because they naturally never get beyond 23:59. When you open the window above cell formatting for the cell I28, you can see that here the custom format [h] mm was assigned. The square brackets around the "h" ensure that Excel counts the hours rather than days, but as the number of hours. The cells K4: K25 indeed look as if they had the format of "Time".
Bookmarks