Online Excel Classes and
Online Excel VBA Classes
Business, Engineers and Scientists
Business, Engineers and Scientists
Our live "hands-on" online Excel classes and online Excel VBA classes allow us to train you or your company anywhere in the world by way of the internet. We broadcast our online Excel classes live and "hands-on" using GoTo Meeting. During the online Excel broadcast, you can see our instructor's computer and they can see yours after requesting permission through GoTo meeting. This allows our instructors to interact with you as if standing behind you in a classroom and help you with any mistakes you may have when creating the Excel problems real time on your computer. To load GoTo Meeting on your computer is usually just a quick and simple download. The GoTo meeting software does not usually violate security or anti-virus software. At most, if you work for a company with tight security control over your computer, you may have to get temporary admin permission to load it on your computer from IT.
EMAGENIT uses GOTO meeting VoIP to communicate with you over your computer during our online Excel classes and online Excel VBA classes. To use this capability, you need a computer with a microphone and a set of speakers. Today's laptops generally have speakers and microphones built into them so this is not an issue. At most, a laptop may lack a microphone which you can generally buy at an electronics store and then plug and play on your computer. If you have a computer without these features, EMAGENIT can provide conference calling via phone line during our online Excel classes and online Excel VBA classes. To reduce the noise of the class if you are training at your place of business, we strongly recommend using a headset with your computer or phone. That way you can type and talk without disturbing those around you. We recommend Logitech communication gear when taking our online Excel classes and online Excel VBA classes.
In addition to viewing our online Excel classes and online Excel VBA classes directly on your computer, you can also use another computer and projector to project the class on to a screen in a meeting room. Just simply log the other computer into our online meeting. Using this strategy, you can use your computer solely for creating the online Excel class problems without having to toggle between Excel and GoTo Meeting constantly. If you are using computer monitors alone to view our online Excel classes and online Excel VBA classes, then we suggest you use at least two of them. Using this strategy, you can use one monitor to view GoTo Meeting and the other monitor to view Microsoft Excel when creating the Excel problems. If looking to use three monitors, our standard, EMAGENIT recommends using an adapter called J5 Create to hookup a third monitor to your computer via a USB port. If your are on the go and out of the office on your laptop, ASUS makes a cool led portable monitor called the M168B 16 inch led monitor that is powered from your computer's USB port. The monitor is 8mm thick, thick of a yellow writing pad and is light weight. The B model has the higher resolution and is well worth the extra money.
Our beginning online Excel classes shows you the essential Excel skills like copying, pasting, typing data, basic formulas and formatting that are vital in your everyday business activities.
Our 1-day "hands-on" beginning online Excel classes show you the fundamentals of using Excel like entering data, worksheet cell formatting, copying and pasting, basic formula construction, auto summing and more. It not only teaches the Excel basics but the thinking and mechanics of how to apply it to your everyday problems and the future. Our beginning online Excel classes also cover Excel for Mac.
Our Intermediate online Excel classes show you the basics of analyzing business information using functions like VLOOKUP and SUMIF, how to control it using conditional formatting and data validation, and how to use Excel's extensive array of data tools to view it.
Our 1-day "hands-on" intermediate online Excel classes demonstrate how to analyze business data and create basic business analysis problems on the worksheet. Our live online Excel class 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 online class 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 class is how to link Excel with Word and PowerPoint. Our intermediate online Excel classes also cover Excel for Mac.
Our advanced online Excel classes show you how to use advanced formulas and logic, ActiveX controls, Excel's visual tools, pivot tables and database features to create powerful data analysis tools and visual displays.
Our 1-day "hands-on" advanced online Excel classes demonstrate how to develop smart adaptive business tools in Microsoft Excel. Our live online Excel class focuses on creating Excel analysis and data processing tools using advanced formulas, worksheet functions, logic, ActiveX controls, conditional formatting, data validation, Pivot Tables, MS Query and charts. Our advanced Excel online class discusses the advanced aspects of these elements and how to assemble them in advanced ways. Our online class also stresses how to create the advanced logic that allows these tools to operate autonomously and adapt to changing data. It also provides an introduction to macros (VBA). Our advanced online Excel classes also cover Excel for Mac.
Our beginning online Excel VBA classes give you the skills that you need to start developing powerful data processing and analytical tools for your business right away.
Our 2-day "hands-on" beginning online Excel VBA classes discuss 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 Excel VBA class provides a complete review of Excel VBA as well as how it is used to command the Excel environment for business purposes such as data processing, report generation and modeling. Our beginning online Excel VBA classes also cover Excel for Mac.
Our advanced online Excel VBA classes show you how to develop tools using multiple workbooks|worksheets, folders, text files, userforms, ActiveX controls, databases and linked programs that will solve your most challenging business problems.
Our 3-day "hands-on" advanced online Excel VBA classes show you how to use VBA to command advanced Excel features, create advanced data tools that use multiple workbooks and data sources; create and control advanced dashboards that use ActiveX controls, userforms and graphics; control the Windows folder system; process databases and text files, and control other programs like Word, PowerPoint and even VB.NET. It's our most advanced VBA training that we provide. Our advanced online Excel VBA classes also cover Excel for Mac.
Our advanced online Excel classes for engineers and scientists show you how to design advanced data and modeling tools using advanced formulas and logic, Excel's data tools, Excel's visual components, ActiveX controls and custom designed VBA worksheet functions that run from the worksheet.
Our 1-day "hands-on" advanced online Excel classes for engineers and scientists show you how to organize, name and store large amounts of information on worksheets; build advanced formulas and array formulas for modeling and data tools; build advanced data displays (dashboards) to visualize model information and data; process data using Excel's statistical tools; link with external databases and text files using Excel tables and Microsoft Query; and construct advanced pivot tables. It also provides an introduction to VBA macros with emphasis on creating custom VBA worksheet functions (UDF). Our advanced online Excel classes for engineers and scientists also cover Excel for Mac. Taught by an engineer.
Our beginning online Excel VBA classes for engineers and scientists give you the knowledge to start developing powerful data processing, analytical and modeling tools for engineering and science right away.
Our 2-day "hands-on" online beginning Excel VBA classes for engineers and scientists show from an engineering and science perspective how to use VBA to control key Excel features, format and process technical data, perform sophisticated calculations, create technical charts, create custom worksheet functions, manage large models and information, create report generation tools and much more. Our beginning online Excel VBA classes for engineers and scientists also cover Excel for Mac. Taught by an engineer.
Our advanced online Excel VBA classes for engineers and scientists give you the knowledge to assemble high end tech tools developed from userforms, ActiveX, mixed language programing, Excel's visual elements, databases, text files, multi workbooks|worksheets and linked programs.
Our 3-day "hands-on" online advanced Excel VBA classes for engineers and scientists show you from an engineering and science perspective how to use VBA to create advanced data analysis tools, advanced technical models, advanced database tools, dashboards using ActiveX controls and userforms, interface with other programming languages like VB.Net and FORTRAN and control other programs like Word and PowerPoint. Our advanced online Excel VBA classes for engineers and scientists also cover Excel for Mac. Taught by an engineer.
Our online Excel dashboard class shows you how to assemble high end dashboards that will rival anything on the market from advanced formulas and logic, adaptive names, ActiveX controls, charts, pivot tables, Excel's visual features and graphics.
Our 3-day "hands-on" online Excel Dashboards classes show you the complete mechanics of how to create advanced dashboards in Microsoft Excel. The dashboard types covered include various status displays, project management displays, time lines, chart gauges, various summary style charts, various maps, color coding worksheets, pivot charts and any other dashboard you can dream up. It shows how to use all of Microsoft Excel's capabilities to construct these sophisticated dashboards and most importantly how to assemble them. Our online Excel class also discusses how to build custom worksheet functions in VBA which provide the ultimate calculation capabilities. Our online Excel dashboard classes also cover Excel for Mac.
Copyright © 2002-2017
EMAGENIT All Rights Reserved