- Subscribe to this page:
- RSS
- Email Alert
microsoft excel
(830 results)-
Discussion Threads
Use this Excel quick fill handle trick to insert partial rows and columns
June 11, 2013 8:56am PDT
Use this Excel quick fill handle trick to insert partial rows and columns article root Well I think it is superior....... I work with large tables of data and so often I have to insert a partial...
1 Started by bernices |
-
Discussion Threads
Use SUMIFS() to sum by multiple conditions in Excel
May 31, 2013 7:03am PDT
Use SUMIFS() to sum by multiple conditions in Excel article root Error in article Above the first screenshot, I believe you flipped the A range and the C range in the formula. English /...
5 Started by itdept@... | Latest comment by DonG43
-
Discussion Threads
Use EDATE() and relative addressing to create a quick date matrix in Excel
May 29, 2013 3:22am PDT
Use EDATE() and relative addressing to create a quick date matrix in Excel article root Nice tip. EDATE is the shortened version of DATE... ...i.e. =EDATE($A2,B$1) is equivalent to...
7 Started by spiras | Latest comment by jshewsbury@...
-
Discussion Threads
Build dynamic charts in Excel
May 28, 2013 4:14pm PDT
Build dynamic charts in Excel article root Discovery! I have never used Tables in Excel, but this is a revelation. Thanks! Excellent Article !! i love working with Excel, and this article makes...
3 Started by clive.ellis@... | Latest comment by GraemeLeggett
-
Discussion Threads
Excel 2013 Flash Fill anticipates needs on the fly
May 27, 2013 10:16am PDT
Excel 2013 Flash Fill anticipates needs on the fly article root Might be useful if you have limited tasks Could see this being helpful if your work is very limited. IE, my company is too small...
4 Started by maszsam@... | Latest comment by Slayer_
-
-
Discussion Threads
Group Excel charts together for displaying, copying, and pasting
May 21, 2013 8:41am PDT
Group Excel charts together for displaying, copying, and pasting article root 3 New Ways To Customise Your Charts In Excel Nice simple tip! Many people don't realise just how simple it is to get...
-
Discussion Threads
Build a simple timesheet in Excel
May 3, 2013 1:40am PDT
Build a simple timesheet in Excel article root A Couple of Ideas I like your step by steps, the following are things I usually do to make it easier on both the developer and the user. When...
-
Discussion Threads
Three tips for using Excel's conditional formatting more efficiently
April 11, 2013 3:34pm PDT
Three tips for using Excel's conditional formatting more efficiently article root Inherited spreadsheets The sheets I inherit from others tend to be the worst, though I've revisited some of my...
2 Started by Full Tao-er | Latest comment by ssharkins@...
-
Discussion Threads
Transposing Excel data via the fixed and live methods
April 2, 2013 7:57am PDT
Transposing Excel data via the fixed and live methods article root Fixing Formulae Fixing the formulae ($ signs before and after the Column reference in each formula) retains the linkages after...
1 Started by rki@... |
-
Discussion Threads
How to delete duplicate values and duplicate records in Excel 2007 and 2010
March 29, 2013 8:53am PDT
Good FREE resource Here is a good resource too: http://www.mindgems.com/products/Fast-Duplicate-File-Finder/Fast-Duplicate-File-Finder-About.htm How to delete duplicate values and duplicate...
1 Started by allancass |
-
Discussion Threads
One of the most important questions you should ask in an interview
March 27, 2013 3:20pm PDT
One of the most important questions you should ask in an interview article root Impressing the non-techie I was converting an in-house app from Lotus to Excel--and the business analysts were...
56 Started by chriscol@... | Latest comment by Slayer_
-
Discussion Threads
Determine the remaining number of days in the same year
March 24, 2013 2:19pm PDT
Determine the remaining number of days in the same year article root Follow on question Thanks, Susan, this is great info! Now, how about if I want to enter a starting date in $E$3 on an Excel...
7 Started by myMary | Latest comment by lee_dimambro@...
-
Discussion Threads
Three easy ways to use color in an Excel worksheet
March 12, 2013 7:56am PDT
Three easy ways to use color in an Excel worksheet article root Always one new thing....... Just when you think you know it all you come out with a useful tip that I didn't even know I needed or...
-
Discussion Threads
Three ways to guide users through an Excel input range
March 8, 2013 4:54am PST
Three ways to guide users through an Excel input range article root Table and Protection Hello Susan, As always your tips are valuable. Concerning to this topic I have a question that I hope you...
3 Started by McGnity | Latest comment by Marshwiggle
-
Discussion Threads
10 advanced formatting tricks for Excel users
March 8, 2013 3:49am PST
10 advanced formatting tricks for Excel users article root Great Support! Thanks a lot for sharing such valuable information with examples. I think such articles may help to develop advanced...
16 Started by saamihaamid | Latest comment by hdas2012
-
Discussion Threads
How to find duplicates in Excel
March 6, 2013 7:34am PST
How to find duplicates in Excel article root Excel 2007 and later, use conditional formatting In Excel versions 2007 and later, it is much easier to find duplicates using Conditional,...
8 Started by eclark@... | Latest comment by thanhonap
-
Discussion Threads
Poll: Do you program against Office?
February 28, 2013 9:45am PST
Poll: Do you program against Office? article root I've been doing some Though I have to admit, Excel and VBA was one part that got me into the IT department from Accounting in the first place!...
21 Started by hometoy | Latest comment by DavidTheConsultant
-
Discussion Threads
10 steps to creating a custom list for sorting in Excel
February 7, 2013 7:55am PST
10 steps to creating a custom list for sorting in Excel article root Custom Sort Great tip, Susan! This came at an opportune moment for me, and simplified what initially was starting to look...
5 Started by DaveUnger | Latest comment by ssharkins@...
-
Discussion Threads
Highlight Excel list values when they change
February 6, 2013 12:20am PST
Highlight Excel list values when they change article root Excel 2003 Those commands are not available in Excel 2003....or the version I have in work Other formula I think it's better use range...
23 Started by 1000048875 | Latest comment by ssharkins@...
-
Discussion Threads
10+ tips for working with Excel's Subtotal feature
January 23, 2013 7:27am PST
10+ tips for working with Excel's Subtotal feature article root great article (as usual) The hidden values thing in table A can prove very useful I used to memorise all the options and their...
3 Started by jbenton@... | Latest comment by jbenton@...
