- Subscribe to this page:
- RSS
- Email Alert
excel
(824 results)-
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...
1 Started by TerenceNoah |
-
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@...
-
Discussion Threads
Display multiple subtotaling functions in Excel
January 23, 2013 7:08am PST
Display multiple subtotaling functions in Excel article root Thought I knew everything... ...but apparently not When I wanted an average AND a sum, for instance, I used to add an average to two...
2 Started by jbenton@... | Latest comment by sparent
-
Discussion Threads
Tim Cook's most excellent Apple adventure (pictures)
January 20, 2013 6:28am PST
Tim Cook's most excellent Apple adventure (pictures) article root TRAINING + 100% JOB PLACEMENT GUARANTEE IN SAP & Oracle Apps SAP & Oracle Apps Training in Mumbai, Navi Mumbai ,Thane, Kalyan,...
-
Discussion Threads
Two dynamic chart enhancements using Excel
January 17, 2013 3:03am PST
Two dynamic chart enhancements using Excel article root No negative plot Hello Susan, For a complete Excel nob like me that was a very helpful article. I may have made a mistake somewhere but I...
2 Started by nick.harrison@... | Latest comment by ssharkins@...
-
Discussion Threads
Summarize data in excel 07
January 14, 2013 9:12am PST
Summarize data in excel 07 How to summarize data by year or month from below table: Date sales 01.01.2011 100 01.02.2011 200 01.03.2011 100 06.03.2011 400...
4 Started by loveatallca | Latest comment by PurpleSkys
-
Discussion Threads
Five budget apps to help you keep tabs on your spending
January 9, 2013 8:37am PST
Five budget apps to help you keep tabs on your spending article root Budgets? How do you track your expenses and balance your budget? Do you have an app for that? GNU Cash A full featured...
6 Started by Mark W. Kaelin | Latest comment by HAL 9000
