About Us - Professional Freelance Expert Excel Consultants and Excel Programmers If you need help with your Excel files, with or without the use of Visual Basic for Applications (VBA/Macros/Code) you have found your solution.  We do this on a full-time basis.  We can help you with a single formula, or with full-blown integration and automation. Our corporate office is based in the Irvine area of Orange County California. We have developer offices across the globe, from Irvine, to San Francisco, to Dallas and New York, and Manchester.    ExcelConsultant.Net.  714 262 6893 . Our Services - Expert Excel, Macro, and Access Help & Support for your Business Excel Formula help : If you need help with some of Excel's advanced formulas we definitely have the experience to do so, quickly and efficiently.  We have years of experience using them, in a wide variety of situations.  We cannot only tell you how to use them, but what other formulas might be better suited to your needs.  In addition to this, we can tell you the best way to use the formulas, what to watch out for, etc.  VLookups, HLookups, SumIfs, Offset, If, Concatenate, IsError, Index, Match, etc., are just a few of the more advanced formulas we can teach you to use.  Help can be over the phone, face-to-face, via e-mail, etc.  You tell us which way works best for you.  Excel based Visual Basic for Applications (VBA - Macros/Code): Many people have learned that in order to get the most out of Excel, you need to harness the incredible power of VBA.  VBA is what macros are made of, it is the code behind the buttons, UserForms, events, etc.  An example would be a button to print 10 different worksheets with a single click.  A recorded macro is made up of VBA.  Recorded macros are extremely limited in what they can do.  Having a programmer that can create a custom macro is much more powerful and efficient.  It is also extremely affordable when compared to repeatedly doing the same action manually.  Also, th more times a person does the same action the more possible it is that they will make an error.  Macros remove that risk.  If you have never harnessed the power of VBA, this might be the perfect time to do so.  We have been writing this code for clients for years.  Let us write some for you and your unique situation.  Excel Templates : Excel templates are being used more and more all of the time, in all sorts of companies and in all sorts of applications.  They allow you to custom tailor an Excel application to your unique situation.  They allow you to standardize the way you and your team do business.  They reduce the time needed to work thru multiple files because they are based on a standard you have created for you and your team.  Steve's budget sheet is exactly the same as Nancy's budget sheet.  It makes consolidation, analysis, and manipulation faster, easier, cheaper, and more reliable.  If you have the opportunity to build an Excel template from scratch, take the time and effort to build it right the first time and it will save you money, time, and headaches down the road.  We have been building Excel templates for so long, for so many different industries, that we have a strong knowledge of what works best in what situations.  Allow our experience to benefit you and your team. Excel based Financial Analysis, Reporting, Budgeting, Forecasting, Business Plans, Professional Trading, etc .: I have over ten years o of hands-on experience working in finance.  This experience includes developing budgets, forecasts, business plans, reports, analysis, pivot table design, Ad Hoc analysis, trading stocks, mutual funds, and options, etc.  I was able to automate much of this work.  Not only did I do the work, I built the systems to do the work better, faster, and more accurately than it was done before.  I have done financial work for some very large companies such as Honda, Robert Mondavi, Tenet Health care, Kaiser Permanente, Merrily Lynch, American Express, to just name a few.  So I know what works, what does not work, and whey that is the case.  Allow us to use the hands-on experience to help you and your company. Excel Pivot Tables : Pivot Tables are really becoming popular.  They allow you to quickly and efficiently analyze your data in a concise and well laid out format.  Once you know how they work they are a snap to use.  Let us leverage the power of Pivot Tables for you and your company. Excel Troubleshooting : Do you need help with just one small issue? If for whatever reason you can not get that formula to work, or that chart/graph to look exactly they way you like, or to get that button you use to run your macro to do what you are asking of it, let us look at it for you.  We have debugged so many issues/bugs that you would think we wee exterminators!  Why spend hours upon hours try to solve it yourself when we can usually do it in 15 minutes or less.  You and your problem are not unique, there are only so many things that can go wrong, that we have seen much of them so many times, that we can most likely do it for you in minutes.  Believe it or not, I can often solve your problem without even seeing the file.  If you are having a problem with a VLookup note returning the data you are expecting, I can pretty much determine why in just a few minutes of speaking with you.  So the next time you have a deadline and are pulling your hair out over an Excel problem, call us, we will quickly solve your problem, and you can move on to more important things. Excel Training : We can train you on any aspect of Excel &/or VBA (Macros), and even Access.  Do you want to learn how to create/use Pivot Tables, how to write embedded If statements, how to create a chart or graph, or how to write a VLookup?  If so, we can help.  We can do it over the phone, via e-mail, or face-to-face, be it one-on-one or to a room of people.  You tell us what it is you need and we will quickly provide you with a reliable and cost effective solution.  We are also proficient in Access.  We are not only Excel Programmers and Excel Consultants, but we are also Access Programmers and Access Consultants.  This means if you need either Excel Programming or Access Programming, we can help.  We are also experts in Integrating and Automating Excel and Access.  Consider us as your number one source for Excel Help, Access Help, and Macro Help.  We want to be your number one source for Support in Excel, Access, VBA, and SQL Server.  Call us today if you need Help in Access, Excel, and/or Macros.  We are here to provide help and support for your small business.   View Contact Information Site Map