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 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 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 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 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 Paste the Parts of a Range (Paste Special)

Many times when copying and pasting cells and ranges on the worksheet, the need will arise to paste only certain parts of what you copied. To accomplish this, you use Paste Special when copying. To Paste Special, first select the cell or range that you wish to copy and then copy it by pressing Ctrl+C.

Copy Data

Copy the Cells or Range to Paste by Selecting and Pressing Ctrl+C.

Next select the destination cell, right-mouse click and select the Paste Special word from the shortcut menu. Note that when you pass your cursor over Paste Special, you will see icons appear representing all the different paste special options. Instead of trying to memorize these icons, it is much easier to use the screen we are about to use. Later you can learn the icons. Once the name is clicked, the Paste Special screen will appear.

Selecting Paste Special

Right Mouse Click Over the Destination Cell and Click the Paste Special Name.

On the screen, in the Paste group section, select the type of paste you want to perform. This is where you get to choose what you are going to paste. A common task to do is when you are pasting a range with formulas, you will want to remove the formulas and just keep the values because when you paste cells with formulas to different workbooks, it creates a whole host of problems like formulas not working right, external references... and so forth. To accomplish this task, just click the Values option and click OK. Only the values will paste from the selected cell/range. What you do not tend to think about is that you can do a paste in phases. So after pasting the values you can right-mouse click again over the start cell or highlighted paste area, activate Paste Special again and paste the cell formats then the column widths and so forth. You can keep going and only paste the particular elements you want excluding others.

Paste Special Values Option

Select the Values Option to Avoid Pasting Formulas.

Paste Special Different Parts

You Can Keep Pasting Different Parts Using Paste Special.

In addition to copying data, you can also perform mathematical operations while using paste special (discussed here), but one of the coolest things to do and a real time saver is that you can transpose information. That means you can copy a table, row or column and make columns into rows and rows into columns. To use this feature, you just check the Transpose box at the bottom of the screen.

Transpose Data

Use the Transpose option to Transpose Data.

In conclusion, learning how to take advantage of this feature can really make life easier when pasting information within Excel. If you are looking to automate Excel using VBA and build data processing systems, it is a must to know. One last tip, if you are only looking to copy formats only fast, you can click on the cell or range to copy the formats from, proceed to the Home tab and click the Format Painter button (Paint Brush) under Copy on the left-hand side. Next click or highlight over the cell or cells that you want to paste the formats to and the format will be pasted. The Format Painter has instructions when hovering over the button so be sure to read them.

Format Painter

Use the Format Painter to Quickly Transfer Formats.

To learn more about Paste Special, 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