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. Multiplying 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.
Are you spending too much time with your worksheets — and getting too little done? Turn it around with Microsoft Excel: Time-Savers for Every Skill Level. This Executive Summary packs two training webinars into one compact report, complete with screen shots and Q&A from the events. Get it now as a PDF download or printed copy.
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.
Some people man and groan about Micrsoft's dominance in office software. Not us. We think Excel is a terrific product for tracking and manipulating data — if you know how to use the software. 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.
Excel is supposed to make your job easier. But it's tough enough mastering the basics, much less the multitude of features you haven't even tapped. What good are all those capabilities if you don't know how to use them — or even about them?
There's an esay way: Learn from an expert at both software and training — Melissa Esquibel, Microsoft Certified Trainer. We've combined tow of her most popular webinars into Microsoft Excel: Time-Savers for Every Skill Level, an easy-to-follow Executive Summary that will help you truly master Excel.
Imagine! No more retyping data again and again ... trying to keep worksheets in order when you change or add information ... wasting precious time adjusting column widths and other parameters. Instead of making your work hard, Excel will work harder for you.
Microsoft Excel: Time-Savers for Every Skill Level will boost your productivity every time you open Excel. Order now, and learn on your own schedule, at your own pace. You may even enjoy it!
Get your copy today!