Left Scroll Microsoft Excel Training Banner Right Scroll

Microsoft Excel Training | Microsoft Excel VBA Training | Microsoft Excel Software Design - Services

Microsoft Excel and Microsoft Excel VBA Webinar Training

Excel | Excel VBA Webinar Training

Our Microsoft Excel and Microsoft Excel VBA Webinar training is broadcast live and is taught hands-on. We can broadcast our Excel Training anywhere in the world. Call us for more details at 1.805.498.7162.
Microsoft Excel and Microsoft Excel VBA Public Seminar Training

Excel | Excel VBA Seminar Training

Our Microsoft Excel Seminar and Microsoft Excel VBA Seminar training is taught hands-on and is also broadcast live as a webinar. Our workshops are never canned and are adjusted to our customers training needs during class.
Microsoft Excel and Microsoft Excel VBA Onsite Training

Excel | Excel VBA Onsite Training

Our Microsoft Excel and Microsoft Excel VBA Company Onsite training is customized for our customers particular Microsoft Excel needs. They are taught hands-on and can also be broadcast live as a webinar anywhere at any time.
Microsoft Excel and Microsoft Excel VBA Training Schedule

Excel | Excel VBA Training Schedule

View all of our Microsoft Excel training and Microsoft Excel VBA training offerings. Our workshops are presented as hands-on public seminars or can be broadcast live as a webinar to anywhere in the world.
Microsoft Excel and Microsoft Excel VBA Training Self-Study Manuals

Excel | Excel VBA Manuals

View all of our Microsoft Excel and Microsoft Excel VBA self-study manuals. Our self-study manuals are derived from our almost twenty years of Microsoft Excel training and software design experiences.
Microsoft Excel Training and Microsoft Excel VBA Workshop Skill Levels

Excel Workshop Guide | Skill Levels

View the skill levels required for all of our Microsoft Excel training and Microsoft Excel VBA training. All of our Excel training is customized to our customers needs in class so you do not need to be an expert to take it.
Microsoft Excel Add-Ins

Microsoft Excel Add-Ins

View all of our Microsoft Excel productivity Add-Ins and see how they can help you with your data processing and repetitive Microsoft Excel tasks. You can also make a suggestion for them if you have an idea.
Microsoft Excel Free Help

Microsoft Excel Free Help

Our free Microsoft Excel Resource Center page provides useful information on basic Microsoft Excel concepts, how to topics, cell references, formulas, Excel worksheet functions and using VBA to command Microsoft Excel.
EMAGENIT Exceleration Newsletter Signup

Exceleration Newsletter

Learn about our new Microsoft Excel products, Microsoft Excel items of interest and get special discounts on our products not found any place else on our website.

Microsoft Excel Tip of the Week

Microsoft Excel Tip of the WeekChecking for the Existence of an Item in Another Table (07/23/2015): One of the many tasks facing individuals in the workplace today is testing for the existence of an item in a worksheet table that is in another worksheet table. There are a lot of different ways to do this however the most straight forward way is to use the COUNTIF worksheet function. In the world of logic, when you want to test for the existence of something say in a program or in a formula, the most effective way to do it is to simply find some way to count what you are after. The COUNTIF function does this very thing by looking for the existence of a criterion you give it in a worksheet range, a name in this instance, then counting how many times it occurs. So for example, you have a master list in one table and you would like to see if the name dropped of in a report table that just arrived. Then you would build the COUNTIF worksheet function to look down the range of the new table that has the names in it using the name from your master table and if it returns >0 you know it exists. This concept is illustrated below using the two simple tables in columns A and D, E. When looking for text be very careful because spaces and unwanted characters in the text can corrupt the result. It is highly suggested before running the comparison that you build an auxiliary column next to the column you want to look down in the report and run the CLEAN and TRIM function to get rid of leading and training edge spaces in the data and to also clean non-printable ASCII characters in the text also. Do not underestimate this problem as it occurs in about 80% of the projects that EMAGENIT builds. The formula would look like this =TRIM(CLEAN(A1)) if the data you were after was in column A. If you have other rogue characters in the data it is also suggested that you use a function like SUBSTITUTE to clean those unwanted characters as well. To get rid all spaces in a piece of data you can use this simple formula SUBSTITUE(A1, " ", "") which will target every space. This is just the tip of the iceberg when processing data but it should set you down the right path so you can investigate it further.
A B C D E
1 Item Existance Test   Item Qty
2 A = COUNTIF( $D$1:$D$100 , A2 )   A 100
3 B     B 200

COUNTIF Function Example

For our past Microsoft Excel Tips click here.


About Our Real World Microsoft Excel Training and Microsoft Excel VBA Training

Real World Microsoft Excel and Microsoft Excel VBA TrainingPronounced "Imagine-It", we specialize in Microsoft Excel training and Microsoft Excel VBA training. We have been providing Microsoft Excel training since 1998. We offer a wide variety of Microsoft Excel training and Microsoft Excel VBA training workshops that take you from the beginning to the most advanced Excel power use. Our training experience includes companies and organizations like Time Warner, NASA JPL, Caterpillar, USDA, AMGEN, BMW, Lockheed, The US Air Force and The US Navy.

At EMAGENIT, we have been personalizing our training and problem solving since our very first day of business. Our innovative style of teaching provides you with the best hands on training in the industry. You will be amazed at how much you can learn in such a short amount of time. Our training programs are taught onsite at your workplace, through a live broadcast webinar you can come to one of our public workshops. Anytime you take a course from us, you can come back any time and retake it free, an exceptional value (free repeat details). To learn more about EMAGENIT click here.

Award Winning Microsoft Excel Software Design

NASA AwardSince 1998 at EMAGENIT, we have been developing cutting edge software in Microsoft Excel. We can build just about anything in Microsoft Excel, but we specialize in advanced modeling, visual interfaces, data processing (data mining), report generation and dashboard construction. The harder the challenge, the happier we are. We love producing a solution when other companies said it could not be done. For example, our award for helping design the Mars Rover software in Excel.
 
Over the years, we have pushed Microsoft Excel software design to its limits providing tools for business, engineering and science related tasks. Along this journey, we have also realized that Microsoft Excel macros coupled with other design tools like Visual Basic .NET, Web ASP, JavaScript and other programs like Microsoft Word and Microsoft PowerPoint allowed hybrid tools to be developed that were quick in design yet more powerful than using just Microsoft Excel macros alone. The idea is to use each environment's strengths and making them act as one seamless tool. At EMAGENIT, we do all of our programming in the US which means your proprietary information remains secure. We work continuously with businesses as well as the technical communities and we provide a life long guarantee so if something goes wrong down the road, we will always fix it. To learn more about our software design click here.

Upcoming Excel Training

Beginning Microsoft Excel Training

Beginning Microsoft Excel Training for BusinessOur 1-day "hands-on" beginning Microsoft Excel training shows you the essential skills you need to use Microsoft Excel in your daily business activities right away. Available Public Seminar and Live Webinar
Click Signup Beginning Excel Signup

Intermediate Microsoft Excel Training

Intermediate Microsoft Excel Training for BusinessOur 1-day "hands-on" intermediate Microsoft Excel training shows you intermediate Excel skills that apply to analyzing basic business information. Topics include creating useful formulas; using worksheet functions like VLOOKUP,SUMIF,IF...; creating basic Pivot Tables and using Excel's many data processing tools. Available Public Seminar and Live Webinar
Click Signup Intermediate Excel Signup

Advanced Microsoft Excel Training

Advanced Microsoft Excel Training for BusinessOur 1-day "hands-on" advanced Microsoft Excel training shows you advanced Excel skills that apply to creating smart adaptive Excel business tools. Topics include creating logical adaptive formulas that analyze complex data; using advanced data features like Pivot Tables, MS Query and text file processing; constructing basic dashboards using ActiveX controls and charts; linking to Word and PowerPoint plus much more. Available Public Seminar and Live Webinar
Click Signup Advanced Excel Signup

Beginning Excel VBA Training

Beginning Microsoft Excel VBA Training for BusinessOur 2-day "hands-on" beginning Microsoft Excel VBA training shows you the essential Excel VBA programming skills that you need to immediately develop useful powerful data processing and analytical tools that your business needs now. Available Public Seminar and Live Webinar
Click Signup Beginning Excel VBA Signup

Advanced Excel VBA Training

Advanced Microsoft Excel VBA Training for BusinessOur 3-day "hands-on" advanced Microsoft Excel VBA training shows you how to build advanced data processing tools, analysis tools and dashboard displays using Microsoft Excel VBA that will solve the most difficult business tasks. Available Public Seminar and Live Webinar
Click Signup Advanced Excel VBA Signup


Microsoft Excel Data Processing

Microsoft Excel Data Processing for Engineers and ScientistsOur 1-day "hands-on" Microsoft Excel data processing workshop shows you how to create sophisticated smart adaptive data formulas, use advanced data tools like Pivot Tables and MS Query, learn basic macros and use advanced formulas and Excel display features to create powerful data processing tools. Available Public Seminar and Live Webinar
Click Signup Advanced Microsoft Excel Signup

Beginning Excel VBA Training

Beginning Microsoft Excel VBA Training for Engineers and ScientistsOur 2-day "hands-on" beginning Microsoft Excel VBA training shows you how to use Excel VBA to control key Excel engineering and science features, format and process technical data, perform sophisticated calculations, create technical charts, create custom worksheet functions, manage large models and data, create report tools and much more. Taught by an engineer. Available Public Seminar and Live Webinar
Click Signup Beginning Microsoft Excel VBA Signup

Advanced Excel VBA Training

Advanced Microsoft Excel VBA Training for Engineers and ScientistsOur 3-day "hands-on" advanced Microsoft Excel VBA training shows you how to use Excel VBA to build advanced engineering and science tools that that solve your most difficult data and analysis tasks and help you visualize your data. Taught by an engineer. Available Public Seminar and Live Webinar
Click Signup Advanced Microsoft Excel VBA Signup


Microsoft Excel Dashboards

Microsoft Excel Dashboards TrainingOur 3-day "hands-on" Microsoft Excel Dashboard training shows you how to use advanced formulas that think and self adjust and advanced Excel display features to create sophisticated dashboards that let you visualize and integrate your Excel data. Available Public Seminar and Live Webinar
Click Signup Signup

Intro to Excel VBA Macros

Introduction to Microsoft Excel VBA Macros TrainingOur 1-day "hands-on" Introduction to Microsoft Excel VBA Macros training shows you the basics of how to use VBA to command Microsoft Excel from a data processing perspective. Available Public Seminar and Live Webinar
Click Signup Signup

Scroll Vertically to See Workshops


Site Map  Mobile Site

Copyright © 2002-2015

EMAGENIT All Rights Reserved