1. Setting up a time sheet
All MS Excel versions have a Time Card template with the basics. If you need to base the time sheet on check-in and check-out times, you may want to develop formulas with total hours for a day. It?s fairly simple from a math perspective.
For example, if Cell A1 had your start time and B1 had your end time, your formula would look like this: =(B1-A1)*24. The reason we multiply by 24 is that the result of B1-A1 will be expressed as a percentage of a 24-hour day. Mul??tiplying it by 24 gives you the multiplier to use against an hourly rate to come up with total pay.
Tip: Use the shortcut Ctrl+: (Ctrl+Shift+;) to ?punch in? and ?punch out.? It will instantly put the current time into a cell. It is literally a time stamp.
Excel can make your job easier ? if you know how to use it right. If you don?t, you could be wasting more time than you?re saving. Unlock the power of Excel here?
2. Creating drop-down lists
You can accomplish this a couple of ways.
If you have a specific set of choices you?d like work sheet users to choose from, and you want it restrictive (only these values), use the Data Validation tool (on the Data tab, Data tools group). Choose the List selection from the Allow: field. From here, you can type your values separated by a comma (like Yes, No, NA) or refer to a cell range or named range for your choices.
To help users, complete the Input Message and Error Alert tabs, too. Alternatively, if you just want users to select from entries already entered in the column, all they have to do is right-click and choose Pick from Drop-down List.
Microsoft Excel can work wonders ? or cause headaches. How can you avoid the pitfalls and get the most out of Excel? Use this training guide to master Excel!
3. Navigate anywhere
Proficient Word users probably know about Bookmarks. Bookmarks make it easy to return to certain locations in a document without scrolling or navigating with multiple Find Next actions. You can create a bookmark in Excel with a Named Range.
For example, if you use formulas on multiple work sheets to arrive at ?net profit,? name the cell containing the final number Net Profit. Then, by clicking the drop-down arrow in the Name Box (the little box to the left of the Formula Bar), you can quickly navigate there by selecting Net Profit from the list anywhere in the workbook.
Microsoft Excel: Time-Savers for Every Skill Level is the latest installment in our Office Technology Series. The editors of Administrative Professional Today have turned not one, but TWO training events into one easy-to-read Executive Summary. The first section will help you save time and hassle. The second will help you get the most out of Excel.
Excel should make your job easier, not harder. Now you can discover the tricks that will make you an Excel expert. You?ll get back all the time you?ve wasted by not using Excel to its full potential. And your extra effort and knowledge will be noticed and appreciated.
Get your copy today!
Source: http://www.businessmanagementdaily.com/29969/3-time-saving-tips-for-microsoft-excel
miss usa 2011 stevie nicks sarah michelle gellar living social nelson mandela champions online champions online