microsoft excel News and Other Resources

Discussion Threads

Poll: Do you program against Office?

February 28, 2013 9:45am PST

Poll: Do you program against Office? article root I've been doing some Though I have to admit, Excel and VBA was one part that got me into the IT department from Accounting in the first place!...

21 Started by hometoy | Latest comment by DavidTheConsultant

Blog Post

Excel's Auto Outline quickly hides data details to simplify viewing

February 28, 2013 7:49am PST

Excel's Auto Outline feature quickly hides detail noise so you can view just a summary of your data.

Discussion Threads

10 steps to creating a custom list for sorting in Excel

February 7, 2013 7:55am PST

10 steps to creating a custom list for sorting in Excel article root Custom Sort Great tip, Susan! This came at an opportune moment for me, and simplified what initially was starting to look...

5 Started by DaveUnger | Latest comment by ssharkins@...

Blog Post

10 steps to creating a custom list for sorting in Excel

February 6, 2013 1:18pm PST

When you need to implement a special sort order that Excel can't accommodate, use this trick to set up a custom sort.

5 Latest comment by ssharkins@...

Discussion Threads

Highlight Excel list values when they change

February 6, 2013 12:20am PST

Highlight Excel list values when they change article root Excel 2003 Those commands are not available in Excel 2003....or the version I have in work Other formula I think it's better use range...

23 Started by 1000048875 | Latest comment by ssharkins@...

Downloads

10 steps to creating a custom list for sorting in Excel: Demo files

February 6, 2013 12:00am PST

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

Provided by: Susan Harkins

Blog Post

Highlight Excel list values when they change

February 4, 2013 11:04am PST

If your Excel lists repeats values and you need help finding changes, try this easy conditional format.

23 Latest comment by ssharkins@...

EBooks

Get the skills you need with an Information Assurance master’s degree

February 1, 2013 12:00am PST

Information Assurance Degree - Online or On-Campus The world's dependence on computers and information systems continues to deepen, creating a growing, but increasingly competitive, market for...

Provided by: Regis University

Whitepapers

An Approach to Automation Selection of Decision Tree Based on Training Data Set

February 1, 2013 12:00am PST

In Data mining applications, very large training data sets with several million records are common. Decision trees are very much powerful and excellent technique for both classification and...

Provided by: International Journal of Computer Applications

Whitepapers

Stepping Into the Cloud: A Practical Guide to Creating and Implementing a Successful Cloud Strategy

January 29, 2013 12:00am PST

The benefits promised by cloud computing are excellent, but when faced with conflicting reports of risks and benefits, many companies struggle to take this good idea to a practical reality. This...

Provided by: IBM

Whitepapers

IBM x86 Servers in the Cloud: Serving the Cloud

January 24, 2013 12:00am PST

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

Discussion Threads

10+ tips for working with Excel's Subtotal feature

January 23, 2013 7:27am PST

10+ tips for working with Excel's Subtotal feature article root great article (as usual) The hidden values thing in table A can prove very useful I used to memorise all the options and their...

3 Started by jbenton@... | Latest comment by jbenton@...

Discussion Threads

Display multiple subtotaling functions in Excel

January 23, 2013 7:08am PST

Display multiple subtotaling functions in Excel article root Thought I knew everything... ...but apparently not When I wanted an average AND a sum, for instance, I used to add an average to two...

2 Started by jbenton@... | Latest comment by sparent

Blog Post

Display multiple subtotaling functions in Excel

January 21, 2013 12:05am PST

There's more to Excel's Subtotal feature than you might realize. You can add multiple subtotaling functions to the same row, and you can add multiple rows.

2 Latest comment by sparent

Discussion Threads

Tim Cook's most excellent Apple adventure (pictures)

January 20, 2013 6:28am PST

Tim Cook's most excellent Apple adventure (pictures) article root TRAINING + 100% JOB PLACEMENT GUARANTEE IN SAP & Oracle Apps SAP & Oracle Apps Training in Mumbai, Navi Mumbai ,Thane, Kalyan,...

Started by |

Q&A

I use MS Excel 2010. I have a list that conains email and non-email address

January 18, 2013 1:28pm PST

I use MS Excel 2010. I have a list that conains email and non-email address I used the FIND and MID commands,using the "@" as the midstring but could only sort the fields to the right, truncating...

4 Started by edwardfowler | Latest comment by johbelnel@...

Discussion Threads

Two dynamic chart enhancements using Excel

January 17, 2013 3:03am PST

Two dynamic chart enhancements using Excel article root No negative plot Hello Susan, For a complete Excel nob like me that was a very helpful article. I may have made a mistake somewhere but I...

2 Started by nick.harrison@... | Latest comment by ssharkins@...

Q&A

Summarize data in excel 07

January 15, 2013 7:14am PST

Summarize data in excel 07 How to summarize data by year or month from below table: Date Sales US$ Customer name 01.01.2011 100 MAC 01.02.2011 200...

4 Started by loveatallca | Latest comment by wizard57m-cnet

Discussion Threads

Summarize data in excel 07

January 14, 2013 9:12am PST

Summarize data in excel 07 How to summarize data by year or month from below table: Date sales 01.01.2011 100 01.02.2011 200 01.03.2011 100 06.03.2011 400...

4 Started by loveatallca | Latest comment by PurpleSkys