|
Call us at: 1.805.498.7162 1.805.558.9277 |
 |
|
Home > Microsoft Excel Classes |
|||
|
|||
 |
Microsoft Excel Classes and Microsoft Excel Macro Classesfor Business, Engineering and Science We have over 14 years of experience in teaching our Microsoft Excel classes. All of our Excel classes are based on our extensive training and software design experience with customers like BMW and NASA. Our classes not only teach how to use Excel but more importantly teach the strategy of how to apply it to everyday problems. Our classes cover basic Excel to advanced Excel macros, are "hands-on", come with an 1800+ page manual and include free repeats. |
||
|
|
|
At
EMAGENIT, we continually develop Microsoft
Excel software for our customers. EMAGENIT
received a
If
you cannot attend our training in person,
why not join us live over the internet.
| About Our Classes |
Why Attend Our Microsoft Excel Classes?
Our Public and Webcast Microsoft Excel and Microsoft Excel VBA ClassesOur Excel classes contain vital information gathered from over 14 years of training for companies like General Dynamics, The US Air Force and Boeing. EMAGENIT offers our classes in the following training formats: Public, Onsite, Webcast and Self-Study. Listed below is our currently available public and webcast classes.
Our 1-day "hands-on" beginning Microsoft Excel Class trains you on the basics of Microsoft Excel and also presents the thinking and mechanics of how to apply it to your everyday problems. Topics like data entry, copying and pasting, formatting, basic formula design, and basic worksheet functions like SUM are covered. Complete Outline and Signup
Our 1-day "hands-on" intermediate Microsoft Excel class demonstrates how to develop analysis and data processing solutions on the worksheet. It covers how to build basic dashboards from Excel's built-in features like data validation, conditional formatting, charts, and its data processing tools like pivot tables. In particular, the class demonstrates how to construct powerful formulas including logic that are key to building models and analyzing worksheet data. It discusses in depth the worksheet functions you need to use like VLOOKUP, MATCH, INDEX, SUMIFS, IF... to develop these solutions. Also discussed is how to construct proper data tables and build formulas that adjust to changing data size and header positions. Complete Outline and Signup
Our 1-day "hands-on" advanced Microsoft Excel Class demonstrates how to create sophisticated Excel solutions and dashboards using advanced formulas, array formulas, shapes, conditional formatting, data validation, charts, pivot tables and database queries. It demonstrates the strategy behind developing these adaptive worksheet solutions that think for themselves using different Excel elements in ways you have never thought possible. Our advanced Excel class also provides an introduction to Excel macros. Complete Outline and Signup
Our 2-day "hands-on" beginning Microsoft Excel Macro Class covers the fundamentals of using VBA and Microsoft Excel to develop basic dashboards and data processing tools. In our class you will learn how to use the VBA Editor and debugging tools while also learning basic programming skills including program layout, loops, logic and variables. Also provided is a complete overview of how to control Excel using its objects, properties and methods. Our beginning Excel macro classes also cover everyday issues like:
Our 3-day "hands-on" advanced Microsoft Excel Macro Class covers how to use VBA and Excel to develop sophisticated data processing and dashboard systems that not only integrate with Excel but with other programs and databases as well. In our class, you will receive a full VBA language review as well as a complete review of how to use Excel's objects, properties and methods to develop the advanced Excel programs that you require. Also covered in our advanced Excel macro class are programming topics like:
Our 1-day "hands-on" Excel VBA class shows you how to use Excel VBA (macros) to control key Excel tasks like formatting, sorting, copying and pasting, data processing and automated chart and pivot table construction. It is the information you need to start using VBA right away. Complete Outline and Signup
Our 3-day "hands-on" class shows you first how to create sophisticated dashboards manually using complex formulas, data validation, conditional formatting, charts, ActiveX controls and pivot tables then how to use VBA to build adaptive dashboards and control Excel's data and modeling tools, ActiveX controls, databases and multi-worksheet/workbook stored data. Complete Outline and Signup
Our 1-day "hands-on" Microsoft Excel class for engineering and science stresses useful formula design in the areas of technical data processing, analysis and modeling. It discusses general formula and worksheet function design along with advanced array formula design and how they pertain to sophisticated tool development. Our Microsoft Excel class for engineering and science also stresses modeling techniques along with cleaning worksheet data including parsing text, a huge problem when processing data in Excel. In addition to formula construction, how to create your own custom worksheet functions in VBA is also discussed. How to construct dashboards using ActiveX, data validation, conditional formatting ands chart is also covered. Rounding out the discussion is how to build reports in Excel using pivot tables and linking Excel with Word and PowerPoint. Complete Outline and Signup
Our 2-day "hands-on" beginning Microsoft Excel Macro class covers the basics of using VBA in the engineering and science world. In our class you will learn about the VBA Editor and how to control it along with basic programming skills like program structure, loops, logic and variables. Also covered is a complete review of how to use Excel's objects, methods and properties to control its engineering and scientific capabilities. Our beginning Microsoft Excel macro class also covers important issues like:
Our 3-day "hands-on" advanced Microsoft Excel Macro Class covers how to use VBA to develop sophisticated dashboard and data processing tools that integrate the Excel environment along with other applications. In our class you will receive a full VBA language review along with key debugging strategies. Also presented is a complete review of how to use Excel's objects, properties and methods to develop the sophisticated Excel programs you want. Also covered in our advanced Microsoft Excel macro classes are advanced issues like:
Public Classes LocationPublic Classes Location: Thousand Oaks, CA Directions: Hotel and Activities Hotel: Thousand Oaks Inn EMAGENIT is based in Thousand Oaks, CA which is in the vicinity of Los Angeles county (LA County), Ventura county, Santa Barbara county and San Diego county. We hold all of our courses onsite nation wide. We also webcast (webinar) our public workshops, consult our webcast page for more information. Our seminar workshops are a short commute for those living in:
|
|||||||||||||||||||||||||||||||||||||||||||||||
