excel News and Other Resources

Blog Post

Add autofilter to Excel and filter data by selection

October 30, 2012 8:23am PDT

Cut filtering tasks by more than half by adding the AutoFilter option to the ribbon or toolbar.

15 Latest comment by ssharkins@...

Whitepapers

Security and Vulnerability of SCADA Systems Over IP-Based Wireless Sensor Networks

October 24, 2012 12:00am PDT

An overview of Supervisory Control And Data Acquisition (SCADA) systems is presented and relevant security concerns are addressed. To secure IP-based SCADA systems, it is vital to implement secure...

Provided by: Hindawi Publishing

Discussion Threads

10 steps to creating a scrolling Excel chart

October 23, 2012 6:29pm PDT

10 steps to creating a scrolling Excel chart article root Thanks Susan I didn't realise that you could use graphs with controls. Nice tip. :) dynamic excel graphs Yes, you can. You can, even,...

2 Started by lehnerus2000 | Latest comment by itware2008@...

Whitepapers

Optimized MSE Analysis of Maximum Power Adaptation With Code Rates Over Wireless Cropped Image Transmission Using Labview

October 23, 2012 12:00am PDT

Coding plays significant role in wireless transmission as the most important scheme for communication of cropped images over wireless channels, due to its ability to deal with various channel...

Provided by: International Journal of Electronics Communication and Computer Engineering

Blog Post

10 steps to creating a scrolling Excel chart

October 16, 2012 6:57am PDT

When you have too many data points to display in a dashboard chart, add a scroll bar so users can still view all the data.

2 Latest comment by itware2008@...

Downloads

10 steps to creating a scrolling Excel chart: Demo files

October 16, 2012 12:00am PDT

These sample Excel workbooks (xls and xlsx versions) illustrate the scroll bar technique described in this 10 Things blog post.

Provided by: Susan Harkins

Q&A

How to sum up data with dynamic selection using formula in Excel?

October 15, 2012 1:28am PDT

How to sum up data with dynamic selection using formula in Excel? Hello all, How to sum up the data with dynamic selection using formula in Excel? For example: In row 1, I wanted sum up...

1 Latest comment by Stephen Lam

Discussion Threads

How to autolink Excel file in Access 2010

October 12, 2012 1:14pm PDT

How to autolink Excel file in Access 2010 I need to link an Excel file to my Access database. File name changes daily. Example: filename I need to link today is: Name20121011.xls. Tomorrow the...

1 Started by seasonA | Latest comment by seasonA

Discussion Threads

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

October 12, 2012 10:08am PDT

10 steps to adding a dependent list control to an Excel sheet article root 10 steps to adding a dependent list control to an Excel sheet Is the 10 steps to adding a dependent list control to an...

16 Started by carl2942 | Latest comment by MommaTRex

Discussion Threads

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

October 12, 2012 1:20am PDT

10 steps to adding a dependent list control to an Excel sheet article root Pinkie Horvath You just saw the benefits of a dependent list control. Now let’s see what happens when you update one of...

Started by |

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@...