Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- help design strange home network
- How would I add a router to our home network..?..we start it from a laptop with that sprint internet access-and have a 2 machine network we want to add wireless output to-Anyone have a clue....is there a router that would accept our C5 patch cord connection and give us wireless...
- Tags: home network, network, router, wireless, C5, laptop computer, T Mike, modem
- Q&A 2006-05-28
- Make Excel spreadsheets easier to read with 3-D effects
- Microsoft Excel spreadsheets are a fantastic way to organize data; however, sometimes your spreadsheets may get a bit cluttered and become hard to read. Find out how you can use 3-D effects in Excel to make your spreadsheets much easier to read. Microsoft Excel spreadsheets are not only supposed...
- Tags: 3D, Microsoft Excel, Microsoft Office, Mary Ann Richardson, PRODUCTIVITY, Excel spreadsheet, border button, Format Painter button, Format Painter, spreadsheet, cell, Microsoft Office Suite Excel Tips Newsletter, Button, C5, D5, Office Suites, Software
- Technical articles 2005-08-10
Additional Resources
- How to refernce a static increment of rows in one column,ie every other
- Example: I would like to reference cells c1:c5 to the values in cells a1, a5, a10, a15, a20.Thank you to responders
- Tags: yonatan.t.carl@...
- Discussion threads 2007-05-28
- Excel Question
- I am hoping to come up with a formula, which I have been trying to figure out for some time now.I have Column A which contains a list of thyroid values. I want to come up with a way of having 3 cells in Column B SUM the patients from...
- Tags: Microsoft Excel, cronk005@..., patient
- Discussion threads 2007-06-08
- Sumproduct formula
- Could someone assist me here :When using sumproduct formula, eg :=sumproduct(($A$1:$A$10="china")*($C$1:$C$10))This is the total revenue in US dollars from China when comparing to 4 other countries.Now in the c5 row, if accidentally we insert a say example ", then the sumproduct will show #value. is this a common weakness is...
- Tags: kajen68@...
- Discussion threads 2007-09-17
- How do I change time Hr : Min to a decimal in an excel cell
- I can not change hr:min in an excel cell to a decimal 18:30 to 18.5. I am also looking for if C4=
- Tags: wvsuperdave@...
- Discussion threads 2007-02-07
- Best RAID Level for...?
- Hi,I'm thinking on getting a Dell PowerEdge 2900 for a Database server that I'm planning on implement at my work place. This would be my first challenge as Sr. Support Specialist, but I still have some doubts "how to or what would be the best way to configure the server"....
- Tags: Storage, Servers, axortega09@..., RAID
- Discussion threads 2007-04-14
- How to program to print comments for/next to the specified cell
- Excel sheet consists of cell a b c d e f g 1 Name SC1 sc2 sc3 sc4...
- Tags: abC, achoksi@..., cell, Excel Sheet, Name, software
- Q&A 2005-03-03
- What is the meaning?
- What is the meaning of this "500:0,83,A7,69,15,E1,B9,BF,37,0E,23,90,22,74,04,AF,D2:_D0,17,26,D4,62,A0,FE,F1,33,E1,94,C5,A3,95,04,1B,07F97"It means that you have not provided enough information for a definitive answer. The above is clearly a hexidecimal memory dump of some sort - evidenced by the codes B9, B7 etc. But what type of dump and why is not shown in this.These...
- Tags: bob505_mcse@...
- Q&A 2006-05-29
- Use Excel's Solver tool to schedule your employees
- Solve a problem with Excel's Solver. This tool can help you help you optimize your employees by determining the right number of techs you need at any particular time. You don't need to guess when it comes to determining how many employees you will need to cover a shift...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Use Excel, tool, Solver, Click OK, Microsoft Office Suite Excel Tips Newsletter, Box, Cell, Productivity, Office Suites, Software
- Technical articles 2007-05-22
- Excel - Sum and Average every other row
- I have an Excel spreadsheet that has data in every other row starting in cell C2 and ending in cell C62. I am trying to get my spreadsheet to calculate the average of all of the data in these cells. I know how to do an average formula,...
- Tags: Microsoft Office, Rosstamon, cell, Microsoft Excel
- Discussion threads 2007-07-31
- Paterson Grading in IT Environment
- Hello there. Does anyone know the Paterson Grades for IT Professionals such as systems administrators and managers?Thanks for your helpNo morethan two grades below cOops- n/a -As in... How does that fit IT? ?:|The grading system used for determining Disability in the field of Psychiatrie/Psychosomatik/ Psychotherapie/Neurologie/Neuropsychologieis that what you're talking...
- Tags: IT Specialist, nidek@..., information technology, career, it management, server, IT environment, Paterson
- Discussion threads 2007-02-08
- What is the meaning?
- What is the meaning of this encrypted text (500:0,83,A7,69,15,E1,B9,BF,37,0E,23,90,22,74,04,AF,D2:_D0,17,26,D4,62,A0,FE,F1,33,E1,94,C5,A3,95,04,1B,07F97)?Note: this text is my Win XP account passwordThe whole point with encripted text is that we're not supposed to know what it is when we see it!!!To have an idea you'll need to find out which algorithm it uses and which...
- Tags: password, that-NOT
- Q&A 2006-05-29
- ssh from solaris to solaris
- I just set up ssh from one solaris system to the other, is this expected behaviour:$ ssh 182.177.5.105The authenticity of host '182.177.5.105 (182.177.5.105)' can't be established.RSA key fingerprint is 4e:31:2d:8f:e9:ca:00:45:7c:ff:a0:b0:ea:c5:91:c0.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added '182.177.5.105' RSA to the list of known hosts.Enter passphrase...
- Tags: alice_rutherford@..., SSH
- Discussion threads 2007-03-17
- Moving data in Excel
- I have an excel spreadsheet template with multiple formulas. Users do not access the formulas but they have a horrible habit of dragging the bottom row of data to the top and then filling down when starting a new form. This throws everything out as now the last formula is...
- Tags: Microsoft Excel, damian.murphy@..., cell
- Discussion threads 2007-10-03
- 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
- Use quiz scores to help Goal Seek training hit home
- Learning Excel's Goal Seek feature is difficult for students perplexed by accounting terms and methods. Cut through the confusion by teaching demo problems almost all students understand. Show them how Goal Seek can manipulate their quiz scores.Most courses introduce Excel’s business analysis tools with a demonstration of Goal Seek. Because...
- Tags: Microsoft Excel, Operational accounting, Financial services, Financial accounting, training, Mary Ann Richardson, Goal Seek
- Technical articles 2000-08-24
- Excel: determining an interest rate
- Known information:Present ValueFuture ValueNumber of PeriodsWhat I need to know:Given the above, what's the interest rate?=rate(number of periods,future value,- present value)Note: Cash inflows is positive while cash outflow should be negative). Hence if present value is your investment , then it should be in negative amount.I don't have much...
- Tags: payment, Microsoft Excel, interest rate, cash outflow, Value at Risk, abcs86@..., software
- Q&A 2004-11-03
- Analyze future profits against variable costs with Excel's data table feature
- Extrapolate with Excel! By using Excel, you can calculate current profits as well as potential profits based on the variables of your choice. Mary Ann Richardson shows how you can use Excel to help you make predictive calculations. You know that if you sell your company's product for $45...
- Tags: Microsoft Excel, Mary Ann Richardson, cell, Microsoft Office Suite Excel Tips Newsletter
- Technical articles 2007-03-06
- Use stacked Excel charts to compare data over time
- When you need to present two or more Excel charts of similar items, rather than present them separately, stack them together so that they are easier to compare. For example, you're tracking customer service calls for two of your products in a separate spreadsheet. Follow these steps to create a...
- Tags: Chart, Tab, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2007-09-25
- << Previous
- page 1 of 1
- Next >>
