microsoft excel News and Other Resources

Case Studies

Baker Hughes: Global Oil Services Firm Supports Self-Service BI With a Single Version of the Truth

July 24, 2012 12:00am PDT

Baker Hughes, a global oilfield services company operating in more than 80 countries, has long used data warehouses to support decision making. The company wants to push Business Intelligence (BI)...

Provided by: Microsoft

Discussion Threads

10 Excel defaults you can customize to work the way YOU want

July 23, 2012 6:35am PDT

oh please import csv files Good list. Thanks. Is there a way to change the default delimter to "Comma" when you import from a text file using the wizard. 10 Excel defaults you can customize to...

5 Started by hws1947@... | Latest comment by showbizk

Q&A

vlookup returns a zero need blanks

July 21, 2012 1:02pm PDT

vlookup returns a zero need blanks Excels vlookup finds the lookup value but returns a zero if blank need it to return a blank instead. Maybe there is a number formatting that suppresses 0? You...

3 Started by glendalelest@... | Latest comment by rodney.mcmullan@...

Blog Post

10 Excel defaults you can customize to work the way YOU want

July 18, 2012 8:13am PDT

You don't have to adjust every Excel workbook to meet your needs. By changing a few settings, you can make all your workbooks automatically conform to your preferences.

5 Latest comment by showbizk

Whitepapers

Motion Planning of an Autonomous Mobile Robut Using Artificial Neural Network

July 12, 2012 12:00am PDT

The paper presents the electronic design and motion planning of a robot based on decision making regarding its straight motion and precise turn using Artificial Neural Network (ANN). The ANN helps...

Provided by: Academy & Industry Research Collaboration Center

Whitepapers

Energy Footprint of Advanced Dense Numerical Linear Algebra Using Tile Algorithms on Multicore Architecture

July 12, 2012 12:00am PDT

The authors propose to study the impact on the energy footprint of two advanced algorithmic strategies in the context of high performance dense linear algebra libraries: mixed precision algorithms...

Provided by: University of Tehran

Q&A

Transposing an Array of data into a single column in Excel

July 11, 2012 4:12am PDT

Transposing an Array of data into a single column in Excel I have a bunch of data which is spread into an Excel sheet spanning 24 columns and abut 1000 rows. For each of the 1000 rows I need all...

2 Started by Shriks | Latest comment by jladen@...

Whitepapers

Interactive Analysis for Business Information and Insights

July 9, 2012 12:00am PDT

To keep pace with the competition and seize timely opportunities, people in your organization need access to critical business intelligence (BI) to answer ad hoc questions and queries. Predefined...

Provided by: SAP

Discussion Threads

10 steps to a multi-column search in Excel

July 6, 2012 6:18am PDT

10 steps to a multi-column search in Excel article root Off-screen rows I'm not sure there would be a lot of times when I would want to use this approach over auto-filter or database lookups....

1 Started by sparent |

Whitepapers

Data Clustering and Topology Preservation Using 3D Visualization of Self Organizing Maps

July 6, 2012 12:00am PDT

The Self Organizing Maps (SOM) is regarded as an excellent computational tool that can be used in data mining and data exploration processes. The SOM usually create a set of prototype vectors...

Provided by: International Association of Engineers

Q&A

Linking cells between worksheets in Excel 2007

July 5, 2012 3:17pm PDT

Linking cells between worksheets in Excel 2007 Hi, I am creating a CRM tracker in Excel for my small business. In Sheet 1, I'd like to have certain information that I enter from Sheet 2...

1 Latest comment by PrattPhotos

Blog Post

10 steps to a multi-column search in Excel

July 5, 2012 7:22am PDT

This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting.

1

Discussion Threads

How to filter an Excel 2007 and 2010 data set for the current week

July 2, 2012 9:52am PDT

How to filter an Excel 2007 and 2010 data set for the current week article root advanced filter Thanks for the last bit, Susan. I now finally understand what the advanced filter does! Thanks...

4 Started by jbenton@... | Latest comment by ssharkins@...

Blog Post

How to filter an Excel 2007 and 2010 data set for the current week

July 2, 2012 12:23am PDT

Use Excel 2007 and 2010's built-it date filters when they're adequate. When they're not, try helper columns and date functions.

4 Latest comment by ssharkins@...

Podcasts

Railscasts #362: Exporting CSV and Excel

July 2, 2012 12:00am PDT

As the user will see it is easy to add a CSV export option to Rails. In this podcast, the speaker explains about exporting CSV and Excel. The speaker will also show how to export for Excel in a...

Provided by: Oleksiy Kovyrin

Whitepapers

Reaching Process Excellence with Oracle Process Accelerators

July 1, 2012 12:00am PDT

In this white paper, we see OVUM's assessment of Oracle OpenWorld2011, relating to Oracle Business Process Management suites. In regards to BPM Process Accelerators, OBUM believes that the...

Provided by: Oracle

Whitepapers

Efficient and Secure Web Services by Using Multi Agents

July 1, 2012 12:00am PDT

Mobile agents are an excellent technology for implementing Web services. Within a set of federated Web services, mobile agents can reduce bandwidth requirements and mitigate the effects of...

Provided by: Islamic Azad University

Whitepapers

Comparative Analysis of Energy-Efficient Low Power 1-Bit Full Adders at 120nm Technology

July 1, 2012 12:00am PDT

In this paper, the authors present new Low power and Energy efficient 1-Bit Full adder designs featuring Centralized, XOR-XOR and XNOR-XNOR CMOS design styles. Energy efficiency is one of the most...

Provided by: International Journal of Advances in Engineering & Technology (IJAET)

Q&A

Add Time Cells in EXCEL 2003

June 30, 2012 5:50pm PDT

Add Time Cells in EXCEL 2003 OK - This SHOULD be easy, but I'm missing something... I have an EXCEL 2003 workbook that I'm using to keep track of my exercise times and other exercise info. I've...

1 Latest comment by bds_1959@...

Discussion Threads

Quick tip: Find Excel's XLStart folder fast

June 30, 2012 11:01am PDT

Quick tip: Find Excel's XLStart folder fast article root The Simple Way Why not do the simple thing and just hit the windows key and type xlstart? Doesn't work that way for me That pulls up the...

10 Started by earlkaplan@... | Latest comment by Marshwiggle