[Overview] Having Strong Knowledge in all Worksheet Functions Up to Excel 2010, Pivot Table & It's Utilities, Excel Menu Options & It's Utilities and so on...
[Services] Member of Several Excel Discussion forums and serving in Allexperts from 2009 and sharing my excel knowledge.
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.
I can answer questions regarding worksheet functions (formulas, data, etc) and I have a fairly good handle on VBA. I can help with many, though not all VBA questions to provide coding, menus, macros, and automation. To someone who does almost nothing with code, I may come across as "expert" level. However, to someone who really knows their code very well, they consider me closer to a beginner. :)
What I am good at, is piecing together a lot of research to put together reasonably good, workable code. So even if I don't write it all from scratch, I can often help you.
I do accept and appreciate donations...Yes, I enjoy participating in web forums where mutual help is always exchanged for free, but allexperts is a bit different, as it's answering anonymous questions from anonymous persons, often a valuable bit of code that would cost you $100 of a paid person's time, with virtually nothing in return. So I greatly appreciate a $5 or $10 here and there, if you so choose.
YOU MUST TELL ME WHICH EXCEL VERSION YOU ARE ON. 2003, 2007
I enjoy providing quality answers. To me a quality answer means that as an .....
I can answer questions regarding using Excel in general, analytics, macros, VBA, formulae, etc. More specifically, I try to understand your business requirement, and suggest an effective and efficient method to solve your problem using any of the above features of Excel.
If experts answer your question, please rate them. Positive / Negatives don't matter, rate them for they gave you their time.
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
Excel Tips & Tricks and
Excel Tutorials sections of my web site.
You can also watch my complete Excel 2010 For
Beginners tutorial online which is over 90 minutes of
FREE
videos and an eBook.
Excel Formulas, macros, automation. Microsoft Excel MVP - 2010. Code site with free code snippets and techniques: https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/files
I can answer questions relating to MS Excel formulas, or to programming with vba (Visual Basic for Applications) in the Excel environment.
Please follow the following guidelines: your question should focus on one specific issue you want to learn. It's beyond the scope of this free service for me to create entire projects or complex vba solutions for you from scratch. You should be able to do most of the work yourself, and come here when you need help with a specific point you're stuck on.
ALWAYS include a simple, concrete example illustrating what you want to learn. Explain this example in detail in the text of your question (what data is in which cells of which sheets, etc). Be very precise about the results you want, using this sample to make the logic clear. Always keep these examples SIMPLE. Never e.g. use 18 worksheets in your example if using 2 or 3 will do. Never use ranges like AI567:BB865 if using a range like A1:B3 will do. Thanks.
Selected as an Excel MVP by Microsoft since 1999. Answering Excel questions in Allexperts since its inception in 2001. Able to answer questions on almost all aspects of Excel's internal capabilities. If seeking a VBA solution, please specify that in your question itself so I give you the answer you want.
[Excel has weak protection - if you are distributing an application, I don't answer questions on how to protect your project from your users.]
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,...)
I have extensive experience with VBA programming in Excel 5 through Excel 2007. 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.
In Excel 2003 I can handle all basic questions such as how to copy and paste, all medium type questions such as pivot tables, and also am proficient in basic macros. I am also quickly learning 2007 where everything is pretty much the same but all in different places. Please be as detailed in writing your question as possible as that goes a long way in my ability to give the best answer possible.
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..
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 excel. I am not an expert in charting, macros, or pivot tables.
I can answer Microsoft Excel 2000-2007 questions regarding formatting, styles, shortcut keys, templates, forms, etc, but will not answer any macro questions.
I specialize in formatting, charts/graphs and non-technical areas of Excel. Primarily subject areas listed below in Microsoft Excel 2003, 2007 or 2010. You will find many people with a greater level of proficiency in the areas of Formulas and Development than myself on this site.
BASIC Creating a Basic Worksheet | Performing Calculations | Modifying a Worksheet | Formatting a Worksheet | Printing Workbook Contents | Managing Large Workbooks INTERMEDIATE Organizing Worksheet and Table Data | Presenting Data Using Charts | Inserting Graphic Objects | Customizing and Enhancing Workbooks | Themes | Templates | Collaborating | Restricting Access | Protecting Files | Working with Multiple Workbooks | Linking Cells | Editing Links | Importing and Exporting Data | Working with Templates and Charts | Managing Data in Workbooks ADVANCED - Do not have adequate proficiency to answer the topics below.
Calculating Data with Advanced Formulas | Auditing Worksheets | Analyzing Data | Using Excel with the Web | Structuring Workbooks with XML | Manipulating Data Using Statistical and Lookup Functions | Analyzing Data Using Data Analysis Tools | Working with Data Using Financial Functions | Examining Data Using Math Functions | VBA of any kind CANNOT ANSWER .....
Debbie Brown, say the value is in C3 in another cell =IF(AND(COUNTIF(C3,"*DLV*")>0,COUNTIF(C3,"*CNF*")>0),"Y","N") That finds the substrings "DLV" and "CNF" in the specified cell and if they
Nick Rupp assume the dates are in A1:A26 then =(countif(A1:A26,">=Jan 1, 2012")-Countif(A1:A26,">=Jan 31, 2012"))/26 format the cell to display as percentage If you had Jan 1, 2012
(Sorry -- had a mistake)... Instead of having them put an X in column H, why not simply clear whatever is in column G? In any case, here's code to do what you want. Right-click the sheet tab, select
Hi Ammon, The dir(filespec) command returns the first file in the folder meeting the filespec. Subsequent files are returned by using dir(), e.g.: Dim sFileName as String sFilename=Dir(Cells(2,
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
