- Subscribe to this page:
- RSS
- Email Alert
excel
(10257 results)-
Blog Post
How to find duplicates in Excel
March 5, 2013 10:56am PST
You'll need more than one trick up your sleeve to find duplicates in Excel.
7 Latest comment by ssharkins@...
-
Blog Post
How to add a drop-down list to an Excel cell
June 12, 2008 12:00am PDT
Drop-down lists can greatly facilitate data entry. Here's a look at how to use Excel's data validation feature to create handy lists within your worksheets.
43 Latest comment by dhivya.vasu01@...
-
Blog Post
10 ways to reference Excel workbooks and sheets using VBA
August 25, 2009 9:08am PDT
Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.
5 Latest comment by johnywhy@...
-
Blog Post
Transpose Excel data from rows to columns, or vice versa
June 23, 2009 12:00am PDT
When you need to flip-flop data in an Excel worksheet, don't waste time doing it manually. Excel offers a handy Transpose option that will quickly take care of the task.
33 Latest comment by excelinexcel
-
Blog Post
Use SUMIFS() to sum by multiple conditions in Excel
November 14, 2011 11:25am PST
Excel's SUMIF() lets you sum values, conditionally. It's new sibling, SUMIFS() lets you sum values by multiple conditions.
8 Latest comment by peter.r7
-
-
Articles
Join character strings with Excel's concatenate function
August 8, 2002 7:00am PDT
Cleaning up spreadsheets might not be in your job description, but it's an all too common task for some consultants. Use Excel's handy concatenate function to tidy up databases by joining...
1
-
Blog Post
10 cool ways to use Excel's conditional formatting feature
April 11, 2012 2:06pm PDT
Excel's conditional formatting feature can do a whole lot more than many people realize. Susan Harkins runs through 10 practical ways to put this tool to work.
23 Latest comment by EleanorSugden
-
Blog Post
How to use Excel 2010's new conditional formatting with references
August 30, 2010 8:40am PDT
Excel 2010's new referencing option makes conditional formatting more powerful than ever before!
10 Latest comment by manishdhir
-
Blog Post
Build a simple timesheet in Excel
May 3, 2013 12:43am PDT
Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.
12 Latest comment by emma0123
-
Articles
Concatenate date cells with text cells in Excel
December 12, 2006 8:00am PST
Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.
7 Latest comment by tali.tv
-
Articles
Using Excel's Find and Mid to extract a substring when you don't know the start point
June 8, 2000 7:00am PDT
Here's how to use Excel's Find function in conjunction with the Mid function to locate and extract a string, regardless of how many characters the source string contains.
33 Latest comment by excelvba
-
Articles
Save time by using Excel's Left, Right, and Mid string functions
May 31, 2000 7:00am PDT
Don't re-key something you can extract using an Excel string function. Learn to use the "big three" string functions.
24 Latest comment by wdejesus51
-
Blog Post
Use COUNTIFS() to evaluate multiple count and criteria ranges
May 21, 2012 10:37am PDT
Excel's COUNTIFS() function is flexible enough to handle different ranges and data types.
4 Latest comment by jbenton@...
-
Blog Post
The secret to unhiding column A in an Excel worksheet
March 16, 2009 12:00am PDT
After you hide column A, it might seem like it's gone forever. Fortunately, there are two simple tricks for unhiding it.
7 Latest comment by fallon.stuart@...
-
Blog Post
Quickly fill blank cells in Excel
April 26, 2010 10:50am PDT
Blank cells can spell trouble. Here's an easy way to fill in those blanks and protect the validity of your data.
10 Latest comment by Midhunmj
-
Blog Post
A quick and dirty way to compare columns of Excel data
April 6, 2012 11:41am PDT
Using this little-known feature in Excel, you can quickly compare one column of data to another.
25 Latest comment by HAL 9000
-
Articles
Use Excel to calculate the hours worked for any shift
June 23, 2005 7:00am PDT
With Excel, you can create a worksheet that figures the hours worked for any shift. Here's how.
23 Latest comment by ron4415
-
Blog Post
Create an Excel data entry form that includes check boxes
July 31, 2007 12:00am PDT
You can keep a lot of information on an Excel data entry form, but you can make it easier for your users -- and yourself -- to create tables by adding check boxes. Here's how to set up check boxes...
31 Latest comment by Corbybhoy
-
Blog Post
Build a simple timesheet in Excel
January 26, 2010 9:43am PST
Excel makes it easy to set up a system for tracking time. Follow these steps to create your own or download our sample timesheet template and customize it to fit your needs.
38 Latest comment by raj_as
-
Blog Post
Use a formula to trigger Excel's Conditional Formatting feature
January 5, 2009 1:07pm PST
If you need a visual clue to hype a worksheet, use Excel's Conditional Formatting feature to help values stand out.
29 Latest comment by JNirvaha
