Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- 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
- 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
- See how our sample spreadsheet uses absolute cell references and drop-down lists
- Excel drop-down lists can speed up data entry and eliminate errors. Download our sample invoice to see how Excel's Data Validation and absolute cell reference features can help you quickly create these useful lists.In my previous article, "Use this sample spreadsheet to make the most of Data Validation drop-down lists,"...
- Tags: spreadsheet, Bob Johnson, cell, B14
- Technical articles 2001-03-26
Additional Resources
- Use error handling to enhance your Excel spreadsheets
- If you're tired of seeing #N/A errors in your spreadsheets, we've got the solution for you. Find out how built-in Excel error-handling functions can hide these errors.In my two previous articles "Use this sample spreadsheet to make the most of Data Validation drop-down lists" and "See how our sample spreadsheet...
- Tags: Bob Johnson, Excel spreadsheet, cell, Vlookup, ISNA
- Technical articles 2001-04-02
- Shared worksheet template
- my group uses a shared worksheet on a network drive to keep track of field techs dispatch. If I try to create a template that will create a new blank spreadsheet, it doesn't work. I've tried creating a macro in the template, no go. I can't reuse the old spreadsheet...
- Tags: PRODUCTIVITY, david.keegan@..., cell, Sales Invoice
- Discussion threads 2007-09-21
- Change the labels in an Excel data series
- The Chart Wizard in Excel may work a little too well at times, which is why you'll want to read this tip from Mary Ann Richardson. Learn how to change the labels in a data series so you have one set of information from multiple selections. When you select...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Click Next, Chart Wizard, Microsoft Office Suite Excel Tips Newsletter, Data Series, Office Suites, Software
- Technical articles 2007-02-06
- Excel UPDATE to MS SQL having Run-time error
- Hello All,I am very new to excel, VBA, and SQL although I have had programming experience, it has been a long time ago.I have created a form in excel to be an invoice. I have a MS SQL database that contains the customer info. I have completed the portion...
- Tags: Sales strategy, Sales force management, sales, rtfentem@..., Microsoft Excel, strSQL, Sales Invoice, Worksheets
- Discussion threads 2007-09-21
- Use this sample spreadsheet to make the most of Data Validation drop-down lists
- Excel drop-down lists can speed data entry and eliminate data-entry errors. Download our sample invoice to see how Excel's Data Validation feature can help you create these lists and auto-populate related fields.In his article "Ensure accurate data entry in Excel by using Data Validation to create drop-down lists," Jeff Davis...
- Tags: Microsoft Excel, Bob Johnson, cell, spreadsheet
- Technical articles 2001-03-20
- << Previous
- page 1 of 1
- Next >>
