- Subscribe to this page:
- RSS
- Email Alert
circula reference warning office 2007 xp pro excel
(10258 results)-
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...
-
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...
-
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...
-
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@...
-
Blog Post
10 tips for summarizing Excel data
September 17, 2012 10:25am PDT
Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data.
8 Latest comment by ssharkins@...
-
Downloads
10 tips for summarizing Excel data: Demo files
September 17, 2012 12:00am PDT
These sample Excel workbooks (xls and xlsx versions) illustrate the summarizing techniques described in this 10 Things blog post.
Provided by: Susan Harkins
-
Q&A
need help using excel
September 15, 2012 9:36pm PDT
need help using excel Hello :) Iam new to excel and need to know if it is possible to even do this.my manager does a basic schedule which is fine but the issues is that daily the employees are...
2 Started by MOOKIESMAMA | Latest comment by PurpleSkys
-
Discussion Threads
Five Google Spreadsheet features to help kick your Excel addiction
September 14, 2012 8:39am PDT
Five Google Spreadsheet features to help kick your Excel addiction article root Excel versus Google Spreadsheets Is there still a missing feature that prevents you or your organization from...
4 Started by Mark W. Kaelin | Latest comment by Atharton_CB
-
Blog Post
Five Google Spreadsheet features to help kick your Excel addiction
September 14, 2012 8:38am PDT
Updates and added features have leveled the playing field, giving Google Spreadsheets capabilities that Excel may never have.
4 Latest comment by Atharton_CB
-
Whitepapers
Cloud Computing in South African SMMEs
September 14, 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: University of Canterbury
-
Q&A
Excel: Dropdown list depending on colors
September 13, 2012 12:38am PDT
Excel: Dropdown list depending on colors Hi, I have 2 column say City(Column) & Area(Column B) within City. I need to create a dropdown list for column B depending on the Background Color Present...
2 Started by sagar.morakhia | Latest comment by richardhx
-
Whitepapers
Mobile Cloud Computing: Implications and Challenges
September 10, 2012 12:00am PDT
During the last few years, there is a revolutionary development in the field of mobile computing, multimedia communication and wireless technology. Together with an explosive growth of the mobile...
Provided by: Institute of Electrical & Electronic Engineers
-
Discussion Threads
EXCEL FORMULA W/O using pivot table
September 7, 2012 2:57pm PDT
EXCEL FORMULA W/O using pivot table Need to sum up the top three costs by brand. As you can see toyota is indicated twice in two different amounts so I would need the formula to rollup brands...
