Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Use Access' Where clause to calculate query totals for specific conditions
- Access is versatile enough for you to sort parameter query totals that are unique to certain conditions. Mary Ann Richardson shows how to use the Where clause to make calculations based on specific criteria within your data. In addition to letting you total, average, count, and perform other...
- Tags: Microsoft Access, Microsoft Office, Databases, Mary Ann Richardson, cell, Microsoft Certified, Click Create Query, Total Cell, Microsoft Corp., Microsoft Office Suite Access Tips Newsletter, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2007-06-05
Additional Resources
- Time Sheet
- Has anyone any idea how to calculate a timesheet where the total hours for the month are in the format "111:00" and this is reduced by formula after deducting the daily workinjg day???? PLEASE HELP - I am getting too thin on top for thisLet me first see if I...
- Tags: bjjhome.bt@..., cell, reference cell
- Q&A 2005-02-21
- Excel help, constant running total
- I need help with an inventory workbook our company has. We need it to have a running total of parts instock, and as we use the worksheet to input data, the inventory will change and then we have another sheet for output data that will tell us what parts we...
- Tags: Excel Help, james62, software, Microsoft Excel, cell
- Q&A 2006-05-02
- ConsoXL (exe)
- Consolidate most Excel financial forms without selecting a cell! Save your time for analysis. Look at the total and immediately see the breakdown of each cell. ConsoXL consolidates multiple workbooks and sheets of different formats at once. It calculates the total and creates or not the links between the cells....
- Tags: Cell, ConsoXL
- Software downloads 2007-11-21
- Build summary sheets quickly with Excel's Paste Options
- If you need to link cells in your Microsoft Excel workbook to cells in other worksheets, then discover how easy it is to use Word 2002's Paste Options Smart Tags. Also, learn how to use the Paste Button to link to a cell in Word 2003. When building a...
- Tags: Microsoft Excel, Microsoft Word, Microsoft Office, Mary Ann Richardson, Word processors, cell, Quarter Total cell, Paste Button, Quarter Total, Microsoft Office Suite Excel Tips Newsletter, Office Suites, Software
- Technical articles 2005-09-28
- Apple developing iPhone Nano - What would you spend on a cell phone?
- Most only willing to pay $99 or less for a cell phoneAfter a week of polling, readers of TechRepublic's Mobile and Wireless blog have voiced their desire for low-cost cell phones. Although the total number of respondents is still small, 40 percent reported a willingness to spend $99 or less...
- Tags: Cellular phones, Telecom & Utilities, Apple Inc., Bill Detwiler - TechRepublic, cell phone, phone, Apple iPhone
- Discussion threads 2007-07-18
- Formula Problems
- I want to make a formula that will apply to the whole spreadsheet/workbook.eg. A B C D E - E being the TOTAL columnDaily figures are added to A B C D, and a total is needed in column E, to continue down the page. Okay this is easily done...
- Tags: E
- Q&A 2005-06-24
- Excel Add (Sum) Every Other Nth Cell Software (exe)
- Total every second, third, and fourth column or row in selected cell in MS Excel. In other words, a simple tool to reduce your working time. This version is the first release on CNET Download.com.
- Tags: Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2008-01-16
- Any Excel Gurus Out There?
- hello all, is it possible to reference data from a merged cell into a single cell? and if so how? whenever i try it i get #VALUE in the single cell. any help with this would be greatly appreciatedre: merged cell referenceIf you're getting #value in the single cell, you...
- Tags: Microsoft Excel, hull_max@..., cell, single cell, merged cell
- Discussion threads 2007-07-11
- How do i highlight the active cell in Excel?
- Is there a way to highlight the active cell in excel, so that when you click on a cell it shows up in yellow or some other color? I'm not referring to the option to use the paint bucket to fill the active cell. I want the highlight to disappear...
- Tags: freakyj92@..., Microsoft Excel, active cell, cell
- Discussion threads 2007-10-18
- Save time formatting in Excel with custom styles
- Cellls are building blocks of your Excel document. In this tip, Mary Ann Richardson teaches you how to reformat cells all at once using a set style. Are you tired of reformatting Excel cells over and over again with the same format? Then create a style that will...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, cell, workbook, Go-to Format, Microsoft Office Suite Excel Tips Newsletter, Style, Office Suites, Software
- Technical articles 2006-07-18
- Use your mouse for special paste operations in Excel
- Your mouse does have a place in your Excel spreadsheet—you can use it to perform paste operations and access pop-up menus. Here's how. You don't need to hunt and click through a number of menus to perform special paste operations in Excel—you can simply use the right-mouse ...
- Tags: Microsoft Excel, Mary Ann Richardson, cell, mouse, Microsoft Office Suite Excel Tips Newsletter, Mice, Hardware, Peripherals, Microsoft Office, Office Suites, Software
- Technical articles 2006-07-25
- 10 keyboard shortcuts for speeding your work with Excel data
- Which Next Cell?Nice collection of keyboard shortcuts, but the first one input and move to next cell has two shortcuts, depending on the direction of input:Type + Enter takes you to the next cell DOWN;Type + Tab takes you to the next cell RIGHT.When inputting across, using TAB to...
- Tags: Microsoft Excel, keyboard, MJGunther, cell, keyboard shortcut
- Discussion threads 2007-10-10
- Excel adding information from one cell to another cell
- I have three different cells with words in them and i need to add them all into one cell. Is there a formula for this?examplecell a1 says happya2 sada3 madi want my end product to becell a1 saying happy sad mad thanks.
- Tags: Microsoft Excel, happy_murray@..., cell
- Discussion threads 2007-05-14
- Locate any Cell Phone/Cell Phone Number!
- Because of the demand of Cell-phone, antennas are everywhere in our society. After few days of research, I found out we are not only can be monitor our everyday lives by Credit Card but also with our Cell-Phone (# of People owned a cell-phone is much higher than Credit Card.)...
- Tags: Cell, cell phone, GPS, mak1515@..., networking, telephone, wireless
- Discussion threads 2006-09-14
- Excel 2003 Hyperlink Issue
- I'm trying to hyperlink a single work in a sentence that is all within one cell. So far, I'm only able to link to the entire cell/sentence. Example: Can techrepublic answer this question? With techrepublic underlined/highlighted as the hyperlink. All within a single cell. ...
- Tags: cell, matthewhaggerty@..., windows, 2003, excel, hyperlink, Microsoft Excel
- Discussion threads 2007-01-31
- Want to Receive Cell Phone Calls On Desktop/Laptop
- I am having hell load of calls on the cell phone from the vendors all the day long.it is really not comfortable to hold the Cell phone all the time, and I hope it is damaging my head aswell.We are 6 people working in this department, and looking for a...
- Tags: Cellular phones, fdeeez@..., cell phone, telephone, laptop computer, desktop
- Discussion threads 2007-04-22
- How do I create value limits in Excel?
- Customer wants to create a formula for commission. Possible commission is calculated as 20% (=C8*20%) of total sale. Actual commission is 50%(=1/2*J25) of profit. If over possible commission cell should reflect only possible commission, if under possible commission cell should reflect exact amount. I don't have very much experience with...
- Tags: Sales force management, Microsoft Excel, rblack@..., commission
- Discussion threads 2007-06-21
- Cell Values
- I am working on a quote form and have a table on the form with column headings 1,2,3,4,5 and row titles of a,b,c,d. As the user selects a $ amount in the table, I need to populate the $ amount in another cell. Can someone start me in...
- Tags: cell, Value at Risk, karabryan@..., software
- Q&A 2006-01-30
- Excel ~ Special Cell Formatting
- Does anyone know how to format maybe even build a specialized format to apply to a specific Cell. For instance, I want a specific cell (A1) to capitalize anything that is entered into it (cell A1). (I don't want one cell to show the contents of another cell.)...
- Tags: Microsoft Excel, patricia.lynn@..., cell, Cell
- Discussion threads 2007-10-10
- << Previous
- page 1 of 1
- Next >>
