Call us at:   1.805.498.7162     1.805.558.9277

Home > Live On-Line Microsoft Excel Training - Instructor Led

Live Online Microsoft Excel Training - Instructor Led

for Business, Engineering and Science

For Over 8 Years, EMAGENIT has been providing live instructor led Online Microsoft Excel Training. Our online training not only demonstrates how to use Excel mechanically, but also the strategies behind using it to solve everyday work problems. Our online classes are based upon our real world Excel experiences in consulting and designing software for companies. Our training services cover basic Excel to advanced Excel VBA training. We train large companies over the web like Apple, Boeing, BMW and Citrix as well as individual persons. Our online training is broadcast live, is "hands-on", comes with an 1800+ page manual and includes free repeats.

Why Pick Our Live Online Microsoft Excel Training?

• It is not a prerecorded workshop. It is a live broadcast over the internet with the student and teacher interacting over VoIP or using a dedicated conference line

• You work the same examples as the instructor does real time

• The instructor can see your computer to answer any questions you may have, with your permission

• We always teach realistic Excel problems facing the attendees

• Our workshops evolve constantly, no one training session is the same as the last. During the training, we ask our attendees what problems they are facing and steer the training along those lines

• All of our online Microsoft Excel training is conducted by instructors that teach and develop Excel software. We teach what we practice

Online Microsoft Excel Training - Business

Intermediate Microsoft Excel - Live Online Training

Our 1-day "hands-on" intermediate Microsoft Excel training demonstrates how to develop data processing tools and analysis problems on the worksheet. Our live online Excel workshop demonstrates how to construct useful formulas that employ a large array of worksheet functions including VLOOKUP, SUMIF, MATCH, INDEX, IF... that are the key to building models and analyzing worksheet data. It also demonstrates how to construct these formulas using cell and range names, a key strategy to making worksheets upgradeable, adaptable and easy to maintain. Our intermediate Excel training course also demonstrates how to use key Excel tools like conditional formatting, data validation, autofilter, sorting, text wizard and pivot tables. Also demonstrated is how to work with worksheet text using tools like text to columns and functions like SUBSTITUTE, CLEAN, LEFT, RIGHT, MID, LEN and TRIM. Also covered in the workshop is how to link Excel with Word and PowerPoint and how to build basic dashboards. Complete Outline and Signup

Advanced Microsoft Excel - Live Online Training

Our 1-day "hands-on" advanced Microsoft Excel training demonstrates how to develop sophisticated Excel tools using array formulas, advanced formulas, conditional formatting, drawing shapes, data validation, charts, pivot tables and database queries. Our live online Excel workshop presents the strategies behind developing these advanced worksheet tools and dashboards using various Excel elements in ways you have never thought of before. Our advanced Excel training also discusses ways to setup Excel as a database where information can be stored and retrieved. It also provides an introduction to VBA macros. Complete Outline and Signup

Beginning Excel VBA - Live Online Training

Our 2-day "hands-on" beginning Excel VBA training discusses the fundamentals of using VBA in the business world. Using Excel and VBA together, powerful business tools can be developed cheaply and quickly that rival any software package on the market today. Our live online VBA workshop provides a complete review of VBA as well as how it is used to command the Excel environment for business purposes such as data processing, report generation and dashboard development. Complete Outline and Signup

Advanced Excel VBA - Live Online Training

Our 3-day "hands-on" advanced Excel VBA workshop focuses on using all of Excel's built-in features along with VBA to construct sophisticated business tools that process data and models. Excel's vast array of features like drawing shapes, charts, ActiveX controls, worksheets, Pivot Tables, userforms and cell ranges along allow these dashboard driven tools to be created quickly. Our live online VBA training provides a review of VBA and the strategies for developing these complex tools in Excel using VBA. Complete Outline and Signup

Online Microsoft Excel Training - General Attendance

Introduction to Microsoft VBA Excel - Live Online Training

Our 1-day "hands-on" Intro to Excel VBA workshop shows you how to use VBA to control essential Microsoft Excel tasks like sorting, copying and pasting, formatting, controlling ranges and data, controlling worksheets and workbooks, chart creation and pivot table construction. It discusses VBA fundamentals like loops, logic and variables then discusses how to use Excel objects, properties and methods to control key Excel functionality. Our live online VBA training provides you with the essential information that you need to start leveraging VBA right away for your tasks. Complete Outline and Signup

Microsoft Excel Dashboards - Live Online Training

Our 3-day hands-on Excel and VBA workshop shows you first how to create sophisticated dashboards manually using advanced formulas, data validation, conditional formatting, charts, ActiveX controls and pivot tables. Our live online VBA training then demonstrates how to use VBA to build adaptive dashboards that control Excel's data and modeling features, userforms, ActiveX controls, databases and multi worksheet and workbook stored data. Complete Outline and Signup

Online Microsoft Excel Training - Engineering and Science

Microsoft Excel For Engineers and Scientists - Live Online Training

Our 1-day hands-on Excel workshop stresses basic and advanced formula design in the areas of technical data analysis, engineering analysis and modeling. The workshop discusses basic formula construction using cell and range names along with common worksheet functions. It also discusses advanced array formula design using nested worksheet functions and how they can be utilized to develop sophisticated "thinking" Excel tools. Also stressed is model construction and cleaning worksheet data including parsing text. In addition to formula construction, how to use VBA to create your own custom worksheet functions is also discussed. Our live online Excel training also demonstrates how to construct engineering dashboards using ActiveX controls, Data Validation, Conditional Formatting, charts, drawing shapes and pivot tables. Rounding out the workshop is how to link Excel with Word and PowerPoint allowing automated reports to be built. Complete Outline and Signup

Beginning VBA Excel - Live Online Training

Our 2-day "hands-on" beginning Excel VBA workshop covers the general use of VBA in the engineering and science community. Our live online VBA training covers basic programming topics like loops, variables, logic construction and using object oriented programming to control Microsoft Excel for engineering and science purposes. It also covers important topics like processing resizing data with VBA, workbook and worksheet control, range and cell control, filling data in forms, table construction, automated chart construction, basic dashboard construction, modeling and how to build custom worksheet functions (UDF's) in VBA. Our workshop also discusses controlling Microsoft Word and PowerPoint for report generation purposes and how to control databases. Complete Outline and Signup

Advanced VBA Excel  - Live Online Training

Our 3-day "hands-on" advanced Excel VBA workshop covers the advanced use of Excel VBA in engineering and science. Our live online VBA training covers topics like complex data analysis problems, accessing information in multiple data sources, advanced modeling and advanced dashboard construction. Our workshop also covers controlling the windows filing system for data storage and data extraction. Also explored is using VBA to automate engineering chart construction and to control other applications such as Microsoft Word and Microsoft PowerPoint. Our workshop also covers team linking; database communication using ADO and DAO and communicating with other computer languages like FORTRAN and VB.Net. In essence, everything that we use in the advanced software we build for other companies. Complete Outline and Signup