excel News and Other Resources

Whitepapers

IBM System xÂ® x86 servers: Delivering customer satisfaction by excelling in hardware and support

October 12, 2012 12:00am PDT

Leading IT Industry analysts Technology Business Research (TBR) conducts quarterly x86 Server Customer Satisfaction (CSAT) studies to identify what factors are most important to small and midsize...

Provided by: IBM & Intel

Whitepapers

IBM x86 Servers in the Cloud: Serving the Cloud

October 12, 2012 12:00am PDT

An analysis and perspective from leading IT Industry analysts Technology Business Research (TBR) on how x86 servers and the implementation of private clouds offer a secure and cost-effective means...

Provided by: IBM & Intel

Blog Post

10 steps to adding a dependent list control to an Excel sheet

October 10, 2012 2:23pm PDT

Here's a timesaving way to create a list that changes depending on the user's selections.

16 Latest comment by MommaTRex

Discussion Threads

Excel lost column labels

October 7, 2012 12:25pm PDT

Excel lost column labels How do I restore my column lables "A" "B" "C"... back on my excel spreadsheet. I have the row lables "1", "2", "3"... but know lables.

1 Started by dickatkins | Latest comment by dickatkins

Q&A

Excel find and replace formula

October 7, 2012 8:35am PDT

Excel find and replace formula Hi everybody. I am forex and options trader. Options contracts look like this: 'GOOG 121005C770" or "GOOG 121005P770". I need to have a formula that can lookup the...

3 Latest comment by eilli

Image Gallery

Tim Cook's most excellent Apple adventure (pictures)

October 5, 2012 4:10am PDT

In the year since his predecessor Steve Jobs died, Tim Cook has been sailing the Apple ship with few stumbles and great success in the company's financial performance.

Q&A

How do I correct Excel & Word crashes?

October 3, 2012 7:33am PDT

How do I correct Excel & Word crashes? When I try to save a Word or Excel (Office 2007) file the programs stop responding and shut down. This problem started yesterday before I installed Evernote....

4 Started by johnsonhw@... | Latest comment by jk20092010

Whitepapers

Cloud Computing in South African SMMEs: Risks and Rewards for Playing at Altitude

October 1, 2012 12:00am PDT

Cloud computing can offer an excellent value proposition to Small, Medium and Micro Enterprises (SMMEs), for whom cash flow, physical IT assets, and human resources are at a premium. However,...

Provided by: IRJCSEA

Q&A

Excel Nested IF

September 26, 2012 9:52am PDT

Excel Nested IF Please tell me why this IF statement won't work completely? =IF(B2=5,"Exceeds Expectations",IF(3,"Meets Expectations",IF(1,"Needs Improvement",IF(" "," ")))).The first two...

2 Started by mslwill | Latest comment by cleaverx@...

Blog Post

Creating a data project using SQL Server Integration Services

September 26, 2012 9:16am PDT

Edmond Woychowski walks though the creation of a data project using SSIS, a data migration tool that is part of SQL Server Standard Edition or above.

1

Discussion Threads

A quick trick for hiding duplicate Excel values

September 26, 2012 6:42am PDT

A quick trick for hiding duplicate Excel values article root Why formating rather than data approach? Data > Filter > "Unique records only" use this all the time looks even better if the next...

12 Started by bturner23@... | Latest comment by ssharkins@...

Q&A

Plot only non-zero value in Excel Bar graph

September 25, 2012 11:06am PDT

Plot only non-zero value in Excel Bar graph I want the bar graph to show only those bars that have non-zero value . How it could be possible ? see link www DOT excelforum DOT...

2 Started by noman999 | Latest comment by robo_dev

Blog Post

A quick trick for hiding duplicate Excel values

September 25, 2012 8:47am PDT

Duplicate values aren't wrong, but you might not want to display them. Use this simple technique to hide duplicate values in Excel.

12 Latest comment by ssharkins@...

Discussion Threads

Project plan template from Techrepublic - excel problems

September 25, 2012 5:04am PDT

Project plan template from Techrepublic - excel problems Hello, I am using the excel project spreadsheet downloaded from TechRepublic but because I deleted some of the columns/dates etc. I get...

1 Started by InaFosli | Latest comment by InaFosli

Q&A

Can I insert multiple columns in between multiple columns in Excel?

September 24, 2012 4:17pm PDT

Can I insert multiple columns in between multiple columns in Excel? I have 75 columns but I want to insert two additional columns between each one. Can I do that with one or two commands?

1 Latest comment by carola@...

Q&A

Help with Excel nested function

September 23, 2012 8:34pm PDT

Help with Excel nested function Hi everyone, I am new to nested functions and am trying to use the following: =IF(NOT(OR(F3:H3)),"Do not...

3 Started by liz749 | Latest comment by cleaverx@...

Q&A

formula in excel that can find the last occurrence of each item in a list

September 20, 2012 9:54pm PDT

formula in excel that can find the last occurrence of each item in a list I need a formula that can find the last occurrence of each item in a list. Scenario: Column A(Products) Column B(Date of...

4 Latest comment by Ding_gi

Discussion Threads

Automatically updating excel graphs when new data is added

September 19, 2012 10:00pm PDT

Automatically updating excel graphs when new data is added Hi I have to produce graphs monthly for a report that contain alot of data. Is there a simple way for the graphs to update when new...

1 Started by JaimeeC | Latest comment by JaimeeC

Discussion Threads

10 tips for summarizing Excel data

September 17, 2012 5:00pm PDT

10 tips for summarizing Excel data article root Very nice summary of useful techniques This is the nicest summary of summarising I have seen, it is direct and concise, useful and informative....

8 Started by mark@... | Latest comment by ssharkins@...