microsoft excel

Blog Post

Use Consolidate to summarize Excel data without sorting

August 29, 2012 11:47am PDT

There are a number of ways to summarize Excel data, but Consolidate is one of the easiest to implement and the results are easy to use.

Q&A

MS Excel 2007 Lookup in Another Workbook

August 29, 2012 7:33am PDT

MS Excel 2007 Lookup in Another Workbook Hello everyone. I have a complicated lookup that I need to do from 2 seperate workbooks. I will try to keep it simple. I am needing to place a value into...

2 Started by s2h21  |  Latest comment by Darryl~

Q&A

Excel sheet screwing up royal.

August 25, 2012 6:26am PDT

Excel sheet screwing up royal. I have a client that has an excel sheet that they have been using forever. Seems like every month one of the workbooks gets very hard to manipulate. Going from cell...

1 Latest comment by JSerrago@...

Q&A

Problem pasting Word text into Excel

August 24, 2012 9:00am PDT

Problem pasting Word text into Excel When I copy table text in Word and try to paste it into a specific cell in Excel, it spans multiple cells vertically down from the chosen Excel cell. I have...

2 Started by donpho  |  Latest comment by PurpleSkys

Discussion Threads

Work more efficiently by changing Excel's chart defaults

August 23, 2012 5:12pm PDT

Work more efficiently by changing Excel's chart defaults article root doesn't quite work I do a lot of x-y scatter charts (Time on the X-axis) non smoothed lines for the data sets. The 2.25 pt...

1 Started by dan@...  | 

Discussion Threads

Three tips for rounding Excel time values

August 17, 2012 2:42am PDT

Three tips for rounding Excel time values article root ($C2-$B2+($B2>$C2)) Can you explain the ($B2>$C2) section. ? Excel Tips Another excellent article. I have learned a lot from your posts and...

20 Started by johnmcdermott@...  |  Latest comment by johnmcdermott@...

Blog Post

Three tips for rounding Excel time values

August 16, 2012 8:48am PDT

Summing Excel date and time values is easy; rounding requires a bit of function help.

20 Latest comment by johnmcdermott@...

Q&A

how to prepare an excel considering in and out time?

August 16, 2012 12:06am PDT

how to prepare an excel considering in and out time? how can i calculate the working hours on daily and weekly basis considering in and out times? thus all the time should be in hr:m:s.

1 Latest comment by 17/04/1978

Whitepapers

Design and Modification of Circular Monopole UWB Antenna for WPAN Application

August 16, 2012 12:00am PDT

The basic circular monopole antenna exhibits a 10 dB return loss bandwidth over the entire frequency band, the paper proposed a modified version of simple circular monopole antenna for WPAN...

Provided by: International Journal of Electronics and Computer Science Engineering

Whitepapers

Cloud Strategies of Online Collaboration Software Vendors

August 16, 2012 12:00am PDT

This whitepaper identifies eight significant collaboration services providers and analyse, and scores them based on how well each vendor fulfils the criteria for constructing an online...

Provided by: IBM

Whitepapers

Network Reconfiguration in Distribution System by Software Simulation for Loss Reduction

August 11, 2012 12:00am PDT

The main aim of the distribution companies is to reduce their operating costs to get ahead of competition. One of the most popular approach is to increase the degree of reliability of distribution...

Provided by: Interscience Open Access Journals

Case Studies

Kennards Hire: Kennards adopts business intelligence tool to turn data insight into action

August 8, 2012 12:00am PDT

Kennards Hire started in 1948 as a small, family-owned business hiring tools and equipment to local customers. With a fast-growing business and increasing volumes of data, Kennards needed a...

Provided by: Microsoft

Whitepapers

3 Factor Securities Based on RFID,GSM and Face Recognition for Visitor Identification

August 5, 2012 12:00am PDT

Now-a-day's everything is moving from Manual to automatic so it is necessary to developed automatic security system involving more than one electronic device to make it more reliable. In the...

Provided by: International Journal of Electronics and Computer Science Engineering

Discussion Threads

Two ways to find a conditional average in Excel

August 1, 2012 11:35am PDT

Two ways to find a conditional average in Excel article root Sort/Filter and highlight works too For reporting purposes, the above method works great. If you are just looking for a quick...

3 Started by celander  |  Latest comment by ssharkins@...

Whitepapers

Implementation of Zero Knowledge Protocol in Wireless Sensor Network for Identification of Various Attacks

August 1, 2012 12:00am PDT

Wireless Sensor Networks (WSN) is excellent technology which provide great potential for situations like battlefields and commercial applications such as building, traffic survey, monitoring...

Provided by: International Journal of Emerging Technology and Advanced Engineering (IJETAE)

Whitepapers

A Comparative Study of Digital Watermarking Techniques in Frequency Domain

August 1, 2012 12:00am PDT

Digital watermarking is hiding the information inside a digital media. Its widely used in copyright protection of digital images .This paper presents a comparative study of digital watermarking...

Provided by: HELWAN UNIVERSITY

Whitepapers

Skin Tone Based Secrete Communication Using DWT

August 1, 2012 12:00am PDT

Steganography is the art of hiding the existence of data in another transmission medium to achieve secret communication. It does not replace cryptography but rather boosts the security using its...

Provided by: The World

Whitepapers

New Era Of Fundamental Change Calls For Peak Performance

July 31, 2012 12:00am PDT

Financial services firms are facing challenges today that are more severe and intractable than any they have encountered before. As they move forward in this new environment, they will likely be...

Provided by: Genpact

Blog Post

Two ways to find a conditional average in Excel

July 30, 2012 8:35am PDT

There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions.

3 Latest comment by ssharkins@...

Discussion Threads

A quick way to return the latest date in a subset in Excel

July 27, 2012 6:28am PDT

A quick way to return the latest date in a subset in Excel article root a very long-winded formulaic solution assuming data is on sheet1 and you want dates in the right format, in your summary...

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