- Subscribe to this page:
- RSS
- Email Alert
microsoft excel
(10212 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.
8 Latest comment by thanhonap
-
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 things that are hard to find (or gone altogether) in Office 2013
May 23, 2013 6:20am PDT
Is Office 2013 hiding the tools and options you rely on? Here are some features that have been reshuffled -- or removed.
82 Latest comment by ssharkins@...
-
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
-
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.
22 Latest comment by EleanorSugden
-
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
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!
11 Latest comment by jeboy.06
-
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.
26 Latest comment by VickiJSmith
-
Blog Post
Build dynamic charts in Excel
May 28, 2013 1:22am PDT
Users will appreciate an Excel chart that updates right before their eyes.
3 Latest comment by GraemeLeggett
-
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
-
Blog Post
Use EDATE() and relative addressing to create a quick date matrix in Excel
May 28, 2013 12:26am PDT
With a little planning, you can create an easy-to-implement date matrix in Microsoft Excel.
7 Latest comment by jshewsbury@...
-
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
-
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@...
-
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
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
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
