Excel Training, Excel VBA Training, Excel Software Design

Excel Training, Excel VBA Training, Excel Software Design

LA Microsoft Excel Training, Microsoft Excel VBA Training, Microsoft Excel Software Design LA

Microsoft Excel Training Options

Excel Training and Excel VBA Training - Full Schedule

Excel Training
Full Schedule

Excel Training and Excel VBA Training - Webinar

Excel Training
Webinars

Excel Training and Excel VBA Training - Seminars

Excel Training
Seminars

Excel Training and Excel VBA Training - Onsite

Excel Training
Onsite

Excel Training and Excel VBA Training - Self Studys

Excel Training
Self Study

Microsoft Excel Classes and Microsoft Excel VBA Classes - Class Skill Levels and Comparisons

Excel Training
Skills & Classes

Next Excel Training Dates for Business, Engineers and Scientists

Scroll to See Excel Training Dates >>>

Beginning Excel Training
for Business Professionals

Beginning Microsoft Excel Training

Next Date
See Schedule

Our beginning Excel training teaches you the essential Excel skills and strategies that are vital to know for your everyday business activities.

Our 1-day "hands-on" beginning Excel training teaches the must know basics of using Excel like its program operation, typing in worksheet cells, worksheet formatting, building simple formulas, copying and pasting, filtering, sorting, summing, printing and more. Our beginning Excel training not only teaches you the mechanics of how to use Excel but how to solve common problems encountered in the workplace. Our beginning Excel training also covers Excel for Mac topics as well. Complete Training Outline

Intermediate Excel Training
for Business Professionals

Intermediate Microsoft Excel Training

Next Date
See Schedule

Our Intermediate Excel training shows you how to process and manage your data with formulas, worksheet functions and Excel's built-in data tools.

Our 1-day "hands-on" intermediate Excel training shows you how to manage and process business data on the worksheet using a variety of time saving Excel tools. Excel training topics include formula construction basics; using worksheet functions like VLOOKUP, SUMIF and IF; organizing data on the worksheet in tables; using Excel's built-in data tools to process data; building professional charts; constructing pivot tables and pivot charts; importing text files; data mining text on the worksheet and linking Excel with Word and PowerPoint for reporting purposes. Our intermediate Excel training also covers Excel for Mac material. Complete Training Outline/Signup

Advanced Excel Training
for Business Professionals

Advanced Microsoft Excel Training

Next Date
See Schedule

Our advanced Excel training demonstrates how to assemble advanced Excel formulas, data features and visual elements into adaptive business tools.

Our 1-day "hands-on" advanced Excel training shows you how to create smart adaptive business tools. Excel training topics include advanced logic and usage; advanced formulas; array formulas; ActiveX controls; advanced conditional formatting; advanced data validation; advanced pivot tables and charts; Excel tables; relationships and Microsoft Query. after introducing these advanced features, our Excel training also discusses the strategies of how to assemble them into powerful tools. Also discussed in our Excel training  is the advanced logic that allows these adaptive business tools to operate autonomously. It also provides an introduction to Excel VBA. Our advanced Excel training also covers Excel for Mac subject matters as well. Complete Training Outline/Signup

Beginning Excel VBA Training
for Business Professionals

Beginning Excel VBA Training Business

Next Date
See Schedule

Our beginning Excel VBA training provides you with the Excel VBA skills to start creating powerful data processing and analytical tools for business.

Our 2-day "hands-on" beginning Excel VBA training provides you with the basics skills to start developing useful business tools immediately. Covered in our Excel VBA training is a full review of the Excel VBA language including using logic, variables, expressions, objects, properties, methods and loops. Also covered is how to assemble, run and debug programs. Other important Excel VBA training topics covered include using Excel VBA to control workbooks, worksheets, cells, ranges, copying and pasting, sorting, filtering, worksheet data processing, calculations, worksheet and VBA functions, worksheet formatting and building charts and pivot tables. Excel for mac topics are also covered in our beginning Excel VBA training. Complete Training Outline/Signup

Advanced Excel VBA Training
for Business Professionals

Advanced Microsoft Excel VBA Training Business

Next Date
See Schedule

Our advanced Excel VBA training demonstrates how to develop advanced Excel VBA tools that process, integrate and display advanced data sets.

Our 3-day "hands-on" advanced Excel VBA training shows you how to use the Excel VBA combination to build smart, adaptive business tools. Covered in our advanced Excel VBA training is a full Excel VBA language review with emphasis on how objects really work and how to use them. Also covered in our Excel VBA training is how to use Excel VBA: to create advanced data processing tools that use multiple data sources; to create and control advanced dashboards with ActiveX controls, worksheets, userforms and graphics; to control the Windows folder system; to communicate with databases and process text files; to control Word, PowerPoint and even languages like VB.NET. Excel for Mac is also covered in our advanced Excel VBA training. Complete Training Outline/Signup

Advanced Excel Training
for Engineers and Scientists

Advanced Excel Training for Engineers and Scientists

Next Date
See Schedule

Our advanced Excel training shows how to assemble Excel formulas, visual elements and data features into advanced engineering and science tools.

Our 1-day "hands-on" advanced Excel training for engineers and scientists shows how to build advanced visualization tools, data tools and models for engineering and science. For data and modeling tools, our Excel training shows how to: use names to organize and transmit data; use key worksheet functions; build advanced formulas; build advanced pivot tables; use Excel tables; build advanced array formulas and build advanced logic formulas. It also covers numerical analysis techniques for the worksheet. For visual tools, our Excel training demonstrates how to build complex visual displays from ActiveX controls, charts and graphics and formulas. It also provides an introduction to Excel VBA macros stressing UDF's. Taught by an engineer. Our Excel training also covers Excel for Mac topics. Complete Training Outline/Signup

Beginning Excel VBA Training
for Engineers and Scientists

Beginning Microsoft Excel VBA Training for Engineers and Scientists

Next Date
See Schedule

Our beginning Excel VBA training teaches the Excel VBA skills needed to start creating useful modeling, analysis and data tools for engineering and science.

Our 2-day "hands-on" beginning Excel VBA training for engineers and scientists shows how to use VBA to control key Excel features used in engineering and science. Covered in our Excel VBA training is a complete Excel VBA language review of how to use variables, loops, logic, objects, properties and methods to build programs. It also discusses the strategies behind program construction. Our Excel VBA training also covers using Excel VBA to format and process data, perform advanced calculations, create charts, create custom worksheet functions (UDF) used in modeling, manage large models and information, create report generation tools and much more. Taught by an engineer. Our beginning Excel VBA training for also covers Excel for Mac topics as well. Complete Training Outline/Signup

Advanced Excel VBA Training
for Engineers and Scientists

Advanced Microsoft Excel VBA Training for Engineers and Scientists

Next Date
See Schedule

Our advanced Excel VBA training shows how to build advanced modeling; data analysis; and visual tools in Excel VBA for engineering and science.

Our 3-day "hands-on" advanced Excel VBA training for engineers and scientists shows how to use Excel VBA to create smart adaptive engineering and science tools. Our Excel VBA training begins with a full review of the Excel VBA language stressing how objects work and how to use and build them. After reviewing VBA, our advanced Excel VBA training focuses on using Excel with VBA to produce smart adaptive data tools; advanced models; advanced database tools; visual interfaces with ActiveX controls, userforms, shapes and events; advanced apps that talk to other languages and programs like Word and PowerPoint. Taught by an engineer. Our Excel VBA training also covers Excel for Mac subject matters. Complete Training Outline/Signup

Excel Dashboard Design Training
for Combined Audience

Microsoft Excel Training Dashboards

Next Date
See Schedule

Our Excel dashboard design training shows you how to create smart adaptable Excel dashboards that display and integrate your data.

Our 3-day "hands-on" Excel dashboard design training shows how to create advanced Excel dashboards by combining various Excel elements. Our Excel dashboard training covers various types of displays including status, summary, project management, time lines, gauges, tornado charts, maps and moving graphics. It demonstrates how to create these dashboards by assembling various Excel elements including formatted charts, drawing shapes, conditional formatting, data validation, worksheet formatting, names, pictures, advanced formulas, array formulas, pivot tables and Excel tables. Also demonstrated is how to build custom VBA worksheet functions that run from the worksheet. Our Microsoft Excel training also covers Excel for Mac subject matters. Complete Training Outline/Signup

About EMAGENIT

About EMAGENIT

Pronounced "Imagine-It", we specialize in Microsoft Excel training, Microsoft Excel VBA training and Microsoft Excel software design for customers.

At EMAGENIT, we have been providing Microsoft Excel training, Microsoft Excel VBA training and Microsoft Excel software design services since 1998. EMAGENIT Excel training is offered as semiars, live hands-on webinars, onsites and self study options. We offer a wide variety of Excel training and Excel VBA training choices that can take you from the beginning Excel topics to the most advanced Excel topics you can dream up. Our training philosphy we have used at EMAGENIT since day one is simple, our Excel training is always customized for our customers from the get go. Whether it is a public seminar or onsite, we instanly adjust our Excel training based upon our attendee's expierence. You are in control of the training not us. If you are wondering about who we have taught, our experience includes companies and organizations like the USDA, RAND, AMGEN, BMW, Lockheed, The US Air Force and The US Navy (list of customers). Our innovative style of teaching will provide you with the best hands on Excel training in the industry. You will be amazed at how much you can learn in such a short amount of time with us. And of course, anytime you attend an Excel training or Excel VBA training session with us, you can come back any time and retake it for free, an exceptional value (free repeat details). To learn more about EMAGENIT click here.

Our Excel software design (custom macros) covers many different areas and includes dashboard design, report generation, data processing, model construction, data mining and data integration. We cover engineering, science and business topics and handle both large and small projects. All of our programming is done in the United States by EMAGENIT personel and is not outsourced to another country. In otherwords, your valuable information stays with us and is safe. You can read more about our software design services below.

About Our Microsoft Excel Training

Microsoft Excel Training

Our Microsoft Excel training covers the real world Excel topics needed to succeed in today's business and technology oriented world.

Our Microsoft Excel training covers the real world Excel topics needed to succeed in today's business and technology oriented world. EMAGENIT's Excel training services have been developed and refined from continually teaching the likes of NASA, Time Warner, BMW, Caterpillar, Boeing, Lockheed, Apple and Disney. In every single one of our Microsoft Excel training sessions, we adapt to the our customers needs. Our Microsoft Excel training always focuses around your needs and problems, not some preplanned syllabus that cannot be deviated from. Most of all, we explain everything in our training on a level that the customer understands and we make sure of this in every Excel training session we teach. Since EMAGENIT opened its doors in 1998, our Microsoft Excel training has been continually refined and updated to include the latest Microsoft Excel techniques and Microsoft Excel technology. Also our Excel training covers topics for business professionals and engineers / scientists separately and you will see them divided this way.

Our Excel training goes far beyond just the canned run of the mill training topics encountered today. From the get go in our beginning Excel training level, our customers are exposed to important topics like proper data entry, basic formula design, basic data processing, how to use worksheet functions, proper worksheet layout and chart design. In our intermediate Excel training level, we explain in depth how Excel works focusing on Excel's data tools, formulas, worksheet functions, names and organizing data. In our advanced Excel training level, our training goes after topics like advanced self-adjusting formulas, advanced data processing techniques, array formulas, dashboards, visual interfaces, advanced pivot tables, modeling, and connecting Excel with external data sources. All of our Microsoft Excel training levels draw from our award winning Microsoft Excel software design experiences, so what is shown in our Excel training is what we have battle tested over and over again in our industry software since 1998. The best thing though about our Microsoft Excel training is the free repeats. No two EMAGENIT Excel training sessions are the same; you will want to revisit us again to see what is new.

About Our Microsoft Excel VBA Training

Microsoft Excel VBA Training

Our Microsoft Excel VBA training covers everything you need to know about Excel VBA programming.

Our Microsoft Excel VBA training covers everything you need to know about Excel VBA programming. Since 1998, our Excel VBA training knowledge has been built around our software design experiences for customers like NASA, Medtronic, Caterpillar, Time Warner and Northrup Grumman. We have designed just about every piece of software you can dream up in Excel and our Microsoft Excel VBA training reflects this. First and foremost, our VBA training focuses on our customer's needs, not some preplanned syllabus that has nothing to do with what is going on in the industry today. Our Excel VBA training shows you how to apply the latest and greatest Microsoft Excel VBA technology in ways that will increase your productivity a thousand fold. And most of all, EMAGENIT loves it when our customers bring their problems with them. We love to use our customers problems as the corner stone in our Excel VBA training sessions developing and teaching the Excel VBA material from that point of view. We think on our feet during our training and you will always see this reflected in the topics covered. Also our Excel VBA training covers topics for business professionals and engineers / scientists separately and you will see them divided this way.

Our Microsoft Excel VBA training goes far beyond just canned run of the mill topics. In our beginning Excel VBA training level, we review the basics of programming, logic, data processing, modeling and how to assemble Excel's tools and interfaces into a cohesive program. We teach you not only the mechanics but also the strategies behind how to use Excel VBA to solve problems. In our upper Excel VBA training levels, our training covers advanced data processing, advanced dashboard interfaces, advanced report generation, integrating multiple data sources, integrating Excel VBA with .Net and that is just the beginning. Again though now matter what the Excel VBA material covered, you will find a thorough answer in the training no matter the complexity. Our motto in Excel VBA is the harder the programming problem, the more fun it is to solve it. The best feature about our Microsoft Excel VBA training is our free repeats policy. No two EMAGENIT VBA training sessions are ever the same; you will want to use us as a support source and visit us again and again to continue learning.

Microsoft Excel Training Tip of the Week

Microsoft Excel Tip

Our Microsoft Excel training tip of the week provides useful information that lets you work easier.

How to Use Conditional Formatting to Flag Data

Many times when analyzing numerical data on the Excel worksheet, you want to visually flag data that meets some criteria that you have. Microsoft Excel has a built-in tool called Conditional Formatting that can help you accomplish such a task. To use Conditional Formatting, first organize your data on a worksheet.

Data for Conditional Formatting

Organized data to be flagged with Conditional Formatting.

Next select the data that will be flagged by highlighting it or if you are unsure of the size of the data set, just select the whole column by clicking on the column letter like B.

Selecting Data for Conditional Formatting

Cleaning table data so it can be filtered.

Next proceed to the Ribbon and select Home / Conditional Formatting / New Rule and the New Formatting Rule dialog box will appear. There area a lot of rules to use on this dialog box (from 1 at the top to 6 at the bottom) but the 2nd and 6th rule are the most useful when building interfaces that light up cells. The difference between them is that rule #2 looks at the actual selected cell value and uses logic to color it while the #6 rule can look at other cell values around it using logic formulas and color the selected cell based on their values. So on the dialog box, click the #2 rule (2nd row from the top).

Select Rule #2 on New Rule Dialog Box

Select rule #2 on New Formatting Rule dialog box.

On the dialog box screen, in the first drop down make sure Cell Value is selected, that is the default. That means you are going to look at the cell value directly in your criteria. In the second drop down from the left, select greater than in the drop down and in the last box type in the value to compare against like 2.00.

Select Rule #2 on New Rule Dialog Box

Fill out logic for #2 rule.

Once the logic is filled out, click the Format button and this button will pull up the Format Cells dialog box. This is where you will set the look of the cells to be flagged that meet the logic criteria you just set for the rule. For a quick example, click the Fill tab and set the color to Red and click the OK button. Now click the OK button on the New Formatting Rule dialog box and the cell values that are > 2 will color red. Note that if you selected the header cell in you selection and it colors by mistake, select the cell, go to the Ribbon and select Home / Conditional Formatting / Clear Rules / Clear Rules from Selected Cells to clear the Conditional Formatting.

Set Cell Format

Set the format for the cells that meet the criteria.

Colored Cells Meet Condition

Colored cells meet the set condition.

To learn more about Conditionla Formatting, check out our Intermediate Microsoft Excel Training.

Award Winning Excel Macro Design

EMAGENIT NASA Award

EMAGENIT creates award wining software in Microsoft Excel for NASA, The US NAVY, Caterpillar, Time Warner Cable and Northrup Grumman.

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

Microsoft Excel Add-Ins Version 9.0

Microsoft Excel Add-Ins

Our Microsoft Excel Add-Ins have been redesigned and improved to tackle your rogue data and repetitive task Excel problems.

Our Microsoft Excel Add-Ins are designed to tackle the tough data problems and repetitive tasks that you encounter in Microsoft Excel. From automatically time stamping worksheets, to comparing different tables, to cleaning data so it can be used effectively on worksheets, they have you covered. If you have an idea after reading about our add-ins, click on the suggestion link and fill out the form. If we can use your idea, you get a free version of the software for as long as we make them. To view our list of Excel Add-Ins, click here.

Microsoft Excel Training Help Page

Excel Resources Page

Our Microsoft Excel Resources page provides useful information and tips about Microsoft Excel.

It discusses basic Excel operations like writing formulas, running worksheet functions, typing data and using worksheets. Also discussed is how to use our favorite worksheet functions in real life situations and the syntax behind writing them in formulas. Our resources page also discusses why you want to use Excel VBA (macros) in Excel and the basics behind its operation. To view our resources page click here.


Site Map

Copyright © 2002-2015

EMAGENIT All Rights Reserved