Left Scroll Microsoft Excel Training Banner Right Scroll
Upcoming Microsoft Excel Training and Excel VBA Training
Business Professionals Engineers and Scientists Combined Audience
Beginning Excel Intermediate Excel Advanced Excel Beginning Excel VBA Advanced Excel VBA Data Processing Beginning Excel VBA Advanced Excel VBA Excel Dashboards Intro to Excel VBA
Beginning Microsoft Excel Training for Business
See Schedule
Intermediate Microsoft Excel Training for Business
See Schedule
Advanced Microsoft Excel Training for Business
See Schedule
Beginning Microsoft Excel VBA Training for Business
See Schedule
Advanced Microsoft Excel VBA Training for Business
See Schedule
Microsoft Excel Data Processing for Engineers and Scientists
See Schedule
Beginning Microsoft Excel VBA Training for Engineers and Scientists
See Schedule
Advanced Microsoft Excel VBA Training for Engineers and Scientists
See Schedule
Microsoft Excel Dashboards Training
See Schedule
Introduction to Microsoft Excel VBA Macros Training
See Schedule

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 WeekSubtotal Function (08/24/2015): In everyday Microsoft Excel worksheet usage, everybody using worksheet functions has encountered the problems of hidden rows getting in the way of summations, max and min calculations....etc. Microsoft Excel however has a worksheet function called SUBTOTAL which has the capability to ignore hidden rows. This function can be utilized for such basic calculations as SUM, MAX, MIN, AVERAGE...etc. This function takes at least two arguments, the first one specifies what type of calculation you want to do and if you want to skip blanks via code numbers, the second one and onward specify the ranges, formulas, numbers... that you want to calculate. For example for the first argument, a 9 would mean SUM and a 109 would mean SUM but skip hidden rows. For the second argument and onward, you could use A1:A10, 1 or A1+A2, basically anything that calculates. The SUBTOTAL function pictured below demonstrates these concepts.
A B C
1 1 4  
2 2 5  
5 3 6  
      = SUBTOTAL( 109, A1:A5, B1:B5 )

SUBTOTAL Formula Example

 This function is also of great use when using the Excel data filtering tools. To learn more about how to use functions like these, check out our Intermediate Microsoft Excel workshop.

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.


Site Map  Mobile Site

Copyright © 2002-2015

EMAGENIT All Rights Reserved