On ZDNet: Palm Pre: The good and the bad
93 Resources for

excel spreadsheet

  • Subscribe to this listing via:
  • RSS
  • Email
Did you mean Excel spreadsheet (93 results)

TechRepublic Resources

Use an Excel spreadsheet to prototype your reports
Prototyping is a tried and true method for capturing the design details of user interface design. Joe Goss has discovered a very valuable electronic tool for prototyping reports -- Microsoft Excel. by Joe Goss
Tags: Excel Spreadsheet, Report, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software, Joe Goss
Blog posts 2008-06-19
Use an Excel spreadsheet to prototype your reports
Prototyping is a tried and true method for capturing the design details of user interface design. Less-experienced developers sometimes overlook the output requirements of a system when designing it. Report prototyping often reveals holes in the design for both input functions and data processing functions. Joe Goss has discovered a...
Tags: TechRepublic Inc., Excel Spreadsheet, Data-processing, Joe Goss, Microsoft Excel, Microsoft Office, Office Suites, Software, Mark Kaelin, Application development, prototyping, reports, excel, screenshots
Image galleries 2008-06-19
Linking access form with excel spreadsheet
HiI am trying to create a button on a form so that when you click on the button it transfer all the data from the form into the spredsheet.Can anyone please tell me what the best way to do it.Many thanks
Tags: Microsoft Excel, Microsoft Office, techproblem49@..., Excel spreadsheet
Discussion threads 2007-11-21
Dynamic forms fields in word linked to excel spreadsheets cells
I just had read the excellent article on "Create dynamic forms using Microsoft's word table features" There is an extra-level I wish to reach, but not sure how to achieve it:I want to link a dynamic form in word to an specific cells on an excel spreadsheet, either...
Tags: Microsoft Excel, Microsoft Office, jmdiazfranco@..., Excel spreadsheet
Discussion threads 2007-11-07
Add autonumbering to your Excel spreadsheet
Confused about instructionsMary Ann - I am confused. When you say, step 8, Go To Data | List do you mean menu item Data then item List because I do not have a list item in my data menu. I use Excel 2003. (Also no list on the Go To...
Tags: Microsoft Excel, Microsoft Office, simon.freeman@..., Excel spreadsheet
Discussion threads 2007-10-17
Add autonumbering to your Excel spreadsheet
Unlike Access, Excel does not have an autonumbering feature that increments a number each time you add a new row. With Excel 2003 and 2007, you can use the Row function to add your own autonumbering to a data list. For example, say you are creating a...
Tags: Excel Spreadsheet, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
Blog posts 2007-10-16
Creating a Unique PDF for each Worksheet Tab in Excel Spreadsheet
I use numerous worksheets tabs with a spreadsheet and need a method to easily create a pdf file for each worksheet where the pdf file name is the worksheet name.Dandmiech@aol.comDepends on volumeIf this is just a low volume project - something you need to do from time to time with...
Tags: Excel spreadsheet, dmiech@..., Adobe PDF
Discussion threads 2007-08-31
Office 2003 Excel spreadsheets in 2 different windows
I would like to view 2 different spreadsheets in 2 different windows such as one on one monitor and the second on a different monitor so I can do side by side comparisons of the docs. I don't want to split the window as the company cannot afford to get...
Tags: PRODUCTIVITY, Construction, Excel spreadsheet, Microsoft Office 2003, barrystevens@..., spreadsheet, Microsoft Excel, window, Microsoft Office
Discussion threads 2007-08-29
Excel Spreadsheet Formatting
Is there a way to cause a cell in a spreadsheet to blink when a certain condition is met?You might try herehttp://www.cpearson.com/excel/BlinkingText.aspxYou would then have to link your cell condition to trigger the procedure.It's probably easier to use conditional formatting and just change the font (Red Bold, etc) to indicate...
Tags: topgun@..., Excel spreadsheet
Discussion threads 2007-08-23
Build an Excel spreadsheet application with the power of PHP and XML
I have developed a web system using the same mechanism as the topic in this site 'Build an Excel spreadsheet application with the power of PHP and XML' and it works fine BUUUUUT it doesnt work in some computers.Is there any specific specification of the system needed like there should...
Tags: Microsoft Excel, Scripting languages, Microsoft Office, meronbisrat@..., Excel Spreadsheet Application, Excel spreadsheet, PHP, XML
Discussion threads 2007-07-25
Excel Spreadsheet help
I am trying to find a way to take information from a table in one spreadsheet and populate another cell in another spreadsheet. Can this be done?
Tags: PRODUCTIVITY, 1bravesfan@..., Excel spreadsheet
Discussion threads 2007-07-13
Importing Excel spreadsheet into mssql via Visual Basic 6
Hi,I am new to vb6. I have just started programming in vb6. can anyone please tell me in detail as to how can i import excel spreadsheet into mssql via vb6.
Tags: Microsoft Excel, Microsoft Office, Microsoft Visual Basic, manojgadiyar@..., Microsoft Visual Basic 6.0, Excel spreadsheet
Discussion threads 2007-07-09
Importing Excel spreadsheet into mssql via Visual Basic 6
Hi,I am new to vb6. I have just started programming in vb6. Can anyone please explain me in detail as to how can i import excel spreadsheet into mssql via vb6.
Tags: Microsoft Excel, Microsoft Office, Microsoft Visual Basic, manojgadiyar@..., Microsoft Visual Basic 6.0, Excel spreadsheet
Discussion threads 2007-07-09
Anatomy of Word: Taking Word tables to the next level
Word tables and Excel spreadsheets share a few things in common, such as the ability to perform calculations on numbers in each cell. This document explores these similarities and points out where Word tables fall short of Excel. by Scott Lowe MCSE
Tags: screenshots, Microsoft Word, Scott Lowe MCSE
Image galleries 2007-06-17
Problem Opening Excel Spreadsheet
Here is the lowdown:One user has a problem opening a spreadsheet she gets sent from other members of staff. Everyone else who has access can open the file no problem.The file will open but displays a gray screen where the text should be, but if you go to print preview...
Tags: Microsoft Excel, gareth.withers@..., Excel spreadsheet
Discussion threads 2007-06-05
Link Excel Spreadsheet to another Excel Spreadsheet
I have an Excel Spreadsheet that I am using like a database, and another to format and sort the data in multiple different ways. To explain this easier, I will call the first spreadsheet with all of the information in it, spreadsheet #1, and the other spreadsheet I will...
Tags: Excel spreadsheet, ethomas1@..., spreadsheet, XLS1
Discussion threads 2007-05-01
Link Access DB to Excel Spreadsheet that's open by another user
Hi all,I'm using Office '03 and am trying to link an Access DB to an Excel spreadsheet. The problem is that if the spreadsheet is opened by another user and I attempt to access the spreadsheet via the linked "table" I receive "The Microsoft Jet database engine cannot open the...
Tags: Microsoft Office, Databases, jeff.troutman@..., read only, spreadsheet, Microsoft Excel, Microsoft Access, Excel spreadsheet
Discussion threads 2007-04-16
Use dynamic ranges to make your Excel spreadsheets easier to understand
Mistake found... wrong reference for Order_DateOrder_Date should be =OFFSET(Sheet1!$A$1,0,0,COUNT(Sheet1!$A:$A),1)Not the stated=OFFSET(Sheet1!$A$1,1,0,COUNT(Sheet1!$A:$A),1).Must be a typo!Still getting a zero figure in the sum.I've made the change as specified by Edward, but it's still showing a zero value total.Any hints?----Ignore the last comment - helps if I enter into the right column -...
Tags: Microsoft Excel, Microsoft Office, Edward C. Hsu, Excel spreadsheet, Sheet1!$A:$A
Discussion threads 2007-04-04
Use dynamic ranges to make your Excel spreadsheets easier to understand
Give your numbers more distinct meanings in Excel with dynamic ranges. By using the OFFSET function and naming feature, you can give labels to your formulas, making them easier to find and reference. You can make Excel formulas easier to understand by using named ranges. For example, the...
Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Sales strategy, Sales force management, Excel spreadsheet, Click Add, sales, Total Sales, Microsoft Office Suite Excel Tips Newsletter, Formula, Office Suites, Software
Technical articles 2007-04-03
Excel spreadsheet
Data/Filter modeI have 116 line entries. When I filter on a cell I get on the lower left screen:15 of 65533 records found. This used to read15 of 116 records found.How do I correct this?
Tags: Microsoft Excel, sligg@..., Excel spreadsheet
Discussion threads 2007-03-26


500 Things Every Technology Professional Needs to Know
Did you know Microsoft's RegClean does not work with XP but you can use shareware to clean your registry? Did you know most wireless access points don't have encryption enabled by default? Did you know there are 500 tidbits of information contained in TechRepublic's 500 Things Every Technology Professional Needs to Know that will help you become a successful IT professional.
Buy Now
Disaster Planning and Recovery Pack
TechRepublic's unique Disaster Planning and Recovery Pack contains the hands-on resources you need to ensure that your IT organization is ready for its next crisis.
Buy Now

SmartPlanet