Excel Training, Excel VBA Training, Excel Software Design

Microsoft Excel Training, Excel VBA Training, Excel Macro Training, Excel Macro Design

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

Next Excel Training Dates for Business, Engineers and Scientists

Scroll to See Excel Training Dates >>>

Beginning Microsoft Excel Training  (General Excel)
for Business Professionals

Beginning Microsoft Excel Training

Next Date
See Schedule

Our beginning Microsoft Excel training teaches you the essential Excel skills, methods 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.

Intermediate Microsoft Excel Training  (General Excel)
for Business Professionals

Intermediate Microsoft Excel Training

Next Date
See Schedule

Our Intermediate Microsoft 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.

Advanced Microsoft Excel Training

(General Excel)
for Business Professionals

Advanced Microsoft Excel Training

Next Date
See Schedule

Our advanced Microsoft 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.

Beginning Microsoft Excel VBA Training (Excel Macro Training)
for Business Professionals

Beginning Microsoft Excel VBA Training Business

Next Date
See Schedule

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

Microsoft Visual Basic for Applications (VBA, macros) can be used in conjunction with Microsoft Excel to construct automated business tools. VBA, a general purpose programming language, comes standard with Excel or Office. Using Microsoft Visual Basic with Excel, powerful business analysis tools can be developed quickly and with minimum cost. VBA can be used for business tasks like report generation, creating dashboards, communicating with business databases, analyzing business data, reconciling data, automating worksheet construction, business model calculations, creating charts, the list is endless. Our 2-day "hands-on" beginning Excel VBA training shows you the fundamentals of using Excel VBA programming as well as how to apply it in real world situations. Our beginning Excel VBA training for also covers Excel for Mac topics as well.

Advanced Microsoft Excel VBA Training (Excel Macro Training)
for Business Professionals

Advanced Microsoft Excel VBA Training Business

Next Date
See Schedule

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

The capability exists within Microsoft Excel and VBA to construct complex dashboard driven analysis and data processing business tools. These business tools can go far beyond simple macros becoming actual applications. Excel has a vast array of automated features like graphics, ActiveX controls, worksheets, userforms and cell ranges that when combined together allow these dashboard driven programs to be created. When you tie other programs and computer languages to Excel through VBA like Word, PowerPoint, Access, SQL Server, Lotus Notes, C and VB .Net, Excel VBA can tap into these environments obtaining the functionality it does not have. Our 3-day "hands-on" advanced Excel VBA training focuses on using all of these elements to construct sophisticated data processing and analysis programs in Microsoft Excel. Our advanced Excel VBA training for also covers Excel for Mac topics as well.

Advanced Microsoft Excel Training  (General Excel / Excel Macro Training)
for Engineers and Scientists

Advanced Excel Training for Engineers and Scientists

Next Date
See Schedule

Our advanced Microsoft 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.

Beginning Microsoft Excel VBA Training (Excel Macro Training)
for Engineers and Scientists

Beginning Microsoft Excel VBA Training for Engineers and Scientists

Next Date
See Schedule

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

In engineering and science, Microsoft Excel VBA (Visual Basic for Applications, Excel Macros) and Excel can be used to create powerful tools that automate many common engineering and science tasks. Some of these tasks include modeling, data processing, data visualization, report generation, project management and team integration. The idea behind using Microsoft Excel and Excel macros is to minimize the build time required to construct such tools. Also the combination of Excel and VBA allows some tools that  cannot be developed in other environments to be created. Our 2-day "hands-on" beginning Excel VBA training for engineers and scientists shows how to use VBA to control key Excel features that make the construction of these tools possible. Taught by an engineer. Our beginning Excel VBA training for also covers Excel for Mac topics as well.

Advanced Microsoft Excel VBA Training (Excel Macro Training)
for Engineers and Scientists

Advanced Microsoft Excel VBA Training for Engineers and Scientists

Next Date
See Schedule

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

In engineering and science, Microsoft Excel VBA (Visual Basic for Applications, Excel Macros) can be used to create complex tools that process, integrate, analyze and visualize data from (multiple data sources. Excel VBA can also be used to create advanced interfaces that present floating userforms and ActiveX controls to users as well as move and manipulate advanced graphics on the worksheet. Excel VBA can also be used in engineering and science to create sophisticated tools that communicate with databases and integrate and control information from different programs, computer languages and text files. Our 3-day "hands-on" advanced Excel VBA training for engineers and scientists shows how to use Excel VBA to create these smart adaptive engineering and science tools. Taught by an engineer. Our Excel VBA training also covers Excel for Mac subject matters.

Microsoft Excel Dashboard Training  (General Excel / Excel Macro Training)
for Combined Audience

Microsoft Excel Dashboard Training

Next Date
See Schedule

Our Microsoft Excel dashboard training shows you how to create smart adaptable Excel dashboards that display, integrate and visualize your important 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.

Microsoft Excel Training Options

Microsoft Excel Training and Microsoft Excel VBA Training - Full Schedule

Excel Training
Full Schedule

Microsoft Excel Webinar and Microsoft Excel VBA Webinar

Excel Training
Webinars

Microsoft Excel Seminars /  Microsoft Excel Seminars

Excel Training
Seminars

Microsoft Excel Onsite Training / Microsoft Excel VBA Onsite Training

Excel Training
Onsite

Microsoft Excel Self Study / Microsoft Excel VBA Self Study

Excel Training
Self Study

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

Excel Training
Skills & Classes

About EMAGENIT

About EMAGENIT

Pronounced "Imagine-It", we specialize in Microsoft Excel training, Microsoft Excel VBA training (Excel macros) and Microsoft Excel macro design for customers.

At EMAGENIT, we have been providing Microsoft Excel training, Microsoft Excel macro training (VBA) and Microsoft Excel macro design services since 1998. EMAGENIT Excel training is offered as seminars, 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 philosophy 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 instantly adjust our Excel training based upon our attendee's experience. 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 macro design covers many different areas and includes dashboard design, team integration, 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 Excel macro programming is done in the United States by EMAGENIT personnel and is not outsourced to another country. In other words, your valuable information stays with us and is safe. You can read more about our Excel macro 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 macro 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 (Excel Macros)

Microsoft Excel VBA Training

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

Our Microsoft Excel macro training covers everything you need to know about Excel VBA programming. Since 1998, our Microsoft 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 macro 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 macro 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 Link a Cell to a Drawing Shape for Advanced Displays

When creating advanced visual displays in Excel, you will want to display your cell values over maps, charts, diagrams...etc. More over if the cell values change, you would like these display values to update when the cell does as well. One simple solution is to take a drawing shape and link it to a cell to display its value. To accomplish this, first go to the Ribbon and select Insert / Shapes and then select a drawing shape that can be filled like a rectangle. Next click the mouse on the worksheet to draw the shape on the worksheet. The squares around the edges adjust the size of the shape and if you click and hold on a border (not a square) you can drag the shape around the screen. To delete press the Delete key

Draw Shape

Create a shape on the worksheet that has a fill to it like a rectangle.

NNext, you can link the drawing shape to a cell by cell reference or via cell name. Naming a cell is next week's discussion (hint for now: Click on the cell, find the box to the left of the formula bar that has the cell reference like A1 below, click in the box and type the name. The naming rules are alpha numeric, do not replicate cell references, no spaces, just alphabetical characters A-Z, numbers and underscores, do not use periods (VBA thing). Formulas / Name Manager controls the name editing and deletion. So click on the drawing shape, click in the formula bar, type an equal sign and either click on the cell to be referenced or type the name of the cell being referenced. The value of the cell should appear in the shape when Enter is pressed

Link Shape and Cell

Click on the drawing shape, click in the formula bar and create the reference to the cell to link and display its value.

Now format the shape by right mouse clicking over it and selecting Format Shape. Remember you can make it invisible by saying no fill and no line. That allows you to float the shape over a map lets say and all you see is the value. If the shape is behind a graphic, right mouse click on it and use Bring to Front or Send to Back. You can also apply a simple format to the cell value like $0.00 and it will show up in the shape. And no the red text format does not show up and other more advanced formats as well so do not even think about it. If you want that level, that is when you copy the cell and paste link it as a picture, Conditional Formatting shows up then as well. All this is just the tip of the iceberg in assembling advanced graphics in Excel.

Format Drawing Shape

Click on the drawing shape and format it, you can also apply a number format to the cell.

To learn more about advanced visual displays, check out our Microsoft Excel Dashboard 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