Sponsored White Papers, Webcasts, and Downloads
- calculate interest between dates
- i like to know that how to calculat amount of interest between two dates in a exel worksheet when rate of interest varies with financial year i:efrom 1/4/2000 to 31/3/2001 rate is 10%from 1/4/2001 to 31/3/2002 rate is 10%from 1/4/2002 to 31/3/2003 rate is 10%from 1/4/2003 to 31/3/2004 rate is...
- Tags: arvindcfridhanbad@...
- Q&A 2005-06-24
- Use Excel's Moving Average add-in to predict customer service call load
- Monitor and predict call center volume using Excel's Moving Average add-in, which can help you spot trends that may warrant further attention, saving you headaches down the line. UPDATE: You can download an Excel example of this tip here.Your call center manager notices that the center has received an...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Customer relationship management (CRM), Use Excel, customer service, Click Moving Average, Microsoft Office Suite Excel Tips Newsletter, Call, Manager, Office Suites, Software
- Technical articles 2007-04-17
- Get answers to several Excel questions from the Help Desk Advisor inbox
- TechRepublic contributor Jeff Davis answers Excel questions sent to the Help Desk Advisor inbox. He provides tips on such areas as mail merging and data validation.One of the most enjoyable fringe benefits of writing a column for TechRepublic is receiving e-mail from Help Desk Advisor readers and subscribers to the...
- Tags: Microsoft Office, Word processors, Jeff Davis, Microsoft Excel, B14, Microsoft Word, data source, C14, help desk, mail merge, merge
- Technical articles 2002-10-08
- Make your life easier with this often-unnoticed Excel spreadsheet button
- Spreadsheets are loaded with options that only experienced users know about. Schoun Regan shows you a button option that will save time and make your life easier.I like toolbars with buttons adorned with small images on them that allow users to change the way an application works or the way...
- Tags: PRODUCTIVITY, Microsoft Excel, Social Security, Excel spreadsheet, Schoun Regan, cell, data set, Select Current Region button, Select Current Region
- Technical articles 1999-11-30
- Auditing error messages in Excel
- Some Excel users are more adept at troubleshooting error messages than others. Here's a tip you can pass along to your users that can help them pinpoint a problem cell or cells.If you support Excel users, chances are you've received calls about error messages that mysteriously appear in cells that...
- Tags: PRODUCTIVITY, Jeff Davis, cell, B14, tool, A14, auditing, Trace Error, Microsoft Excel, error message
- Technical articles 2002-09-03
- Keeping totals current in Excel
- Keeping totals current in Excelarticle rootVery handy Excel tipPut this to use immediately & simplified layout and presentation of results.An alternativeWhenever I enter a SUM formula to add the values in a range, say B4 to B10, I ALWAYS make the SUM function add up B4 to B11 (not B10),...
- Tags: SUM, excel, running totals, spreadsheet calculations, Belladrum, hardware, Microsoft Excel
- Discussion threads 2006-03-08
- Designing a foolproof data entry form in Excel
- If you support users who have trouble entering data and printing an Excel sheet, use this eight-step approach to create a foolproof form.It’s just too easy to kvetch about how incompetent some end users can be. This week, I’d like to do something about it. Here’s an Excel solution I’ve...
- Tags: Microsoft Office, Jeff Davis, Microsoft Excel, cell, data entry
- Technical articles 2001-01-16
- << Previous
- page 1 of 1
- Next >>
