About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert Login (Experts Only)
About Us  ·  FAQ  ·  Tell Friends About Us  ·  Link To Us  ·  Free Encyclopedia  ·  Disclaimer  ·  Tech Support   
  You are here:  AllExperts > Computing/Technology > Business Software

Category:  Excel Sort By:  
NameExpertise  Status
Aidan Heritage  
View Profile
I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwardsAvailable
Ask A Question
View Past Answers
Stuart Resnick  
View Profile
I can answer any question relating to MS Excel formulas, or to programming with vba (Visual Basic for Applications) in the Excel environmentAvailable
Ask A Question
View Past Answers
Richard Roberts  
View Profile
Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of a spread sheetAvailable
Ask A Question
View Past Answers
Craig  
U.S.
View Profile
I can answer most general questions, including formatting, shortcuts, pivot tables etc. I have just started using macros, so vba is not my strong suit. I also enjoy explaining the solution at the questioners level of understanding. I am an accountant by trade, so that is my primary area of expertise, but I am willing to tackle just about anything.Available
Ask A Question
View Past Answers
Jan Altman  
U.S.
View Profile
I was the very first Microsoft Certified Excel Trainer in the San Francisco Bay Area, and one of the first in Word. My work has involved such things as training classes, designing databases, programming, writing columns, and even authoring a couple of Excel books. Feel free to send me any level of question about how to use Excel. (Note that I am not familiar with VBA programming. I am, however, quite proficient in the original macro language that came out with Excel 4.)Available
Ask A Question
View Past Answers
Bill Hermanson  
U.S.
View Profile
I am an expert at data manipulation, the use of logical statements, combining tables and extracting data, all the LOGICAL, LOOKUP & REFERENCE functions, creating professional appearing spreadsheets, complex functions, integrated charts and visual displays, user interfaces.... I can make Excel do anything! But PLEASE... NO MACRO QUESTIONS!Available
Ask A Question
View Past Answers
Bob Umlas  
U.S.
View Profile
I`m a Microsoft Excel MVP (Most Valuable Professional) and have been since the inception of the program in 1995. I can answer every kind of Excel question except: API, Importing/exporting to other programs (powerpoint, word,...)Available
Ask A Question
View Past Answers
Richard Rost  
U.S.
View Profile
I am happy to answer any questions about Microsoft Excel. If you have an Excel problem, let me help you with it. Also, please be sure to check the Microsoft Excel Tips & Tricks and Microsoft Excel Tutorials sections of my web site.Available
Ask A Question
View Past Answers
Douglas M. Smith  
U.S.
View Profile
I specialize in solving formula, feature and structure related problems. I know many tricks to help make your spreadsheets and processing more efficient.Available
Ask A Question
View Past Answers
Bill  
U.S.
View Profile
I can provide help with most all EXCEL questions and most all questions about writing EXCEL macros. I have been developing macros for about 10 years in EXCEL and have switched to it from Lotus 1-2-3 after about 10 years of writing macros in it. Typically, I will not write a macro for you unless it is very short because of all the details a macro has to know about to work every time all the time. Please understand that I do not know it all and will be the first to say so. As politely as possible, I don't write macros for people on this site who need one, want one, seem to imply that they need one, and/or seem to think I am expected to write one UNLESS they are very short, quick, and simple. 99% of all macros are more involved than what you think and rarely am I provided with enough specific and complete details to have the code work the first time and every time. This typically means too many follow-up emails, and subsequent macro changes due to lack of specific details, just to get those details so that the macro would work, all of which is on my own free time. The voice of experience from responding to many questions from people who ask me to write a macro for them from this site tells me this. I don't mean to come across as unhelpful but macros are usually very specific and without ALL of the specifics the macro I would write will not address all of your needs and the layout, location, formatting, conditions, etc. of your data and any related files the macro would have to work with. What seems like a simple task to you is almost always more involved than what you think to have the macro ALWAYS work in EVERY situation. If you have a macro you have already written and have a question about it then perhaps I could help with that. I am sure and hope you can and do understand.Available
Ask A Question
View Past Answers
Tom Ogilvy  
U.S.
View Profile
Worked with the program for many years - provided assistance on MS Excel Newsgroups since 1997. Have received the Microsoft MVP award annually since 1999. I don't answer questions on using Excel in a browser Since I have no way to test this. Prefer not to answer charting questions. I consider myself to be particularly knowledgeable about using VBA internal to Excel but have no problems with formulas and pivot tables either.Available
Ask A Question
View Past Answers
Edward H. Mori  
U.S.
View Profile
Expert with pivot tables, very good with many functions, excellent in report formatting. I don't do charts.On Vacation
returns 09/15/2008
View Past Answers
Nathan Head  
U.S.
View Profile
Microsoft Excel questions related to advanced formulas, Pivot Tables, filters, forms, graphs, and just about anything else (EXCEPT for VB and Macros, I don't have any expertise there).On Vacation
returns 09/23/2008
View Past Answers
Jan Karel Pieterse  
Netherlands
View Profile
Excel and Excel/VBA questionsOn Vacation
returns 09/08/2008
View Past Answers
Amal  
India
View Profile
Can answer basic worksheet related questions like formulae usage, connecting to RDBMS from server to extract rows from tables, basic macro construction, pivot table creation, dynamic updation of worksheet data from Server RDBMS..On Vacation
returns 10/02/2008
View Past Answers
Tushar Sakhalkar  
India
View Profile
Formulae in Excel. VB Macros.. Though not really expert in this.On Vacation
returns 10/07/2008
View Past Answers
Miguel Zapico  
View Profile
I can answer any question that I can replicate in my current enviroment (I use Excel 2003 with Windows XP). That may include formula related questions on other Excel version, but it will be hard to deal with configuration and machine related issues.On Vacation
returns 09/08/2008
View Past Answers
Richard Stephens  
U.S.
View Profile
Can respond to questions up to and including advanced (very rusty on VBA) Currently using Excel 2003 and Xp (can still remember some of the earlier excel programs. No question to basic.On Vacation
returns 09/07/2008
View Past Answers
Damon Ostrander  
U.S.
View Profile
I have extensive experience with VBA programming in Excel 2003 back to Excel 5. I am an consultant in a small defense technology services company, and have developed a wide range of applications in VBA, including simulations involving mixed-language programming, satellite orbit mechanics, graphics and animation, and real-time applications. I am interested in moderate to hard VBA-related questions only.On Vacation
returns 09/20/2008
View Past Answers
Chad Welch  
U.S.
View Profile
I have a lot of experience with VBA; Sub procedures, functions etc. I am also very familiar with array formulas.On Vacation
returns 09/14/2008
View Past Answers
Adelaide carvalho  
Portugal
View Profile
I will be able to answer any question on Excel and Visual Basic for Applications - class modules, recursive procedures and functions are my favourite Maxed Out
View Past Answers
 

Recent Answers
2008-09-05  Import text from row to row:   Alex, Here is about an 85 percent solution. Much of the code was written by Chip Pearson. I have added code to handle the XLS. I just need to adjust it for the row to row part for the text file....
2008-09-05  Using INDEX/MATCH to look up multiple values:   Dale, ROW(326:326) tells it to return the 326th largest number. It looks like you should drag it down 1 more row to get it to go to 327 (so if you started with row(1:1), you only have the formula...
2008-09-05  Separating Excel Tabs:   Jeff, It is so easy to copy an entire sheet. Its so easy that there isn't an automated method. Clicking the upper left corner where the row & column indicators meet (there is a small blank...
2008-09-05  Copy the cell to another cell automatically:   You need a helper column, first row must be blank -- and you can hide this column (best). Let's use column J: J2: =MATCH("*open",OFFSET($A$1,J1,0,1000,1),0)+J1 fill this down as far as you want. Don't...
2008-09-05  Rotate a shape:   Play with this -- I don't have the time to find what's really needed for this one -- I don't usually manipulate shapes, so have little experience: Sub MyTry() Static z As Single, notfirst As Boolean...
More Answers for "Excel"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.