How Our Excel Onsite Training Can Help
You
Scroll Down to View Pictures
▼ ▲
Swipe Picture Left < < < < < < < <
In our Excel onsite training, we
cover the little things that you need to know when constructing
formulas and processing data. We cover the important worksheet
functions like IF, INDIRECT and VLOOKUP and the subtle important
things that are often overlooked like names, Excel tables and
string concatenation ( i.e. &'s). We also cover how to lay
things out on the worksheet and format it for rapid reporting
and modeling.
Swipe Picture Left < < < < < < < <
In our Excel onsite training,
we go way beyond normal Excel training, we can show you how to combine Excel
features to produce stunning visual displays that help
convey the state of your data. We will teach you how to use
formulas, charts, conditional formatting, worksheet formatting, drawing shapes and
pictures separately then combine them to produce a desired
result. We have over 20 years of experience designing
software in Excel for customers like Lockheed Martin and
Caterpillar.
Swipe Picture Left < < < < < < < <
In our Excel onsite training,
we can show you how to use things like data validation and conditional formatting in unique
ways to produce various management tools. Using conditional
formatting, we can also show
you how to use it to just flag your data. Oh yes, we also
cover the logic.
Swipe Picture Left < < < < < < < <
In our Excel onsite training,
we can show also show you how to create pivot tables and
pivot charts. We can also show you how to shape and process
your data using Power Query or using Microsoft Query.
Swipe Picture Left < < < < < < < <
In our Excel onsite training,
we also show you how to use Excel VBA to create powerful
reporting, modeling and dashboard tools for a fraction of
the cost of existing software. We teach you the programing
strategies that you need to succeed like processing100
workbooks of data. Our training can take
you from beginning to the most advanced VBA programming
topics using our 20 + years of Excel VBA experience.
We cover Excel for Mac in all of our Excel onsites.
Details.
Why Choose Our Excel
Onsites?
Excel Training Since 1998. EMAGENIT has been providing Microsoft Excel
onsite training for the likes of NASA; the US Air
Force, Navy and Marines; the USDA; AMGEN; Time Warner; HSBC;
Disney and BMW since 1998.
We Cover Every Excel Topic. Our Excel
onsite training covers
from beginning Microsoft Excel to advanced
Microsoft Excel VBA macro programming topics. Whether it is formatting
a worksheet, building formulas, filtering data, building pivot tables, linking
to databases, or building advanced VBA macros, we cover it.
We Break Things Up. Our Excel
onsite training is not a one fit for everyone deal. We break our Excel classes into two
main discipline categories: business and
engineering / science.
That way each group is free to be themselves without boring the
other side.
We Customize Our Excel Company Onsite. Our Excel training outlines,
linked to from below, are only the starting point for our Excel
onsites. We can tailor an Excel onsite for your company that
follows a particular outline with some customized problems
thrown in or we can mix and match different parts of our
outlines to
tailor a unique Excel onsite. Also in our training, we never
teach a "canned" manual following Excel onsite (boring to say
the least). We think on our feet
and incorporate your company's Excel problems into our onsite training
real time if necessary.
We love to get these problems ahead of time of course, but
usually get handed them at the beginning of the training or
during training. Either way works for us.
Our Excel Onsites Have Unique Information.
As many companies discover in our training, we cover more Excel topics
that your company will use in 2 hrs than most Excel training companies
cover in a day. We have been told this repeatedly. That is because our Excel instructors are
actual Excel
software developers and know what Excel topics are used in
industry. This means we have seen a lot, we have manipulated
Excel a lot, and know a lot of Excel tricks that come from building software and
"blowing up"
Excel a couple of 100 times over the years.
We Cover All Versions of Excel Including Excel for Mac.
In our Excel onsites, we cover all the versions
of Microsoft Excel including
Excel for Mac. We even
cover how to effectively use VBA in Excel for Mac 2016.
A Detailed Manual and Free Repeats. All of
our Excel onsites come with a 2000+ page manual and
Free Repeats.
The manual explains in detail what was covered in our training
so you can review the strategies and methods step-by-step after
the class. We will direct you to the manual sections of interest
during the training.
Excel Onsite Details
- Call us at
1.866.924.6244 for more information on how we can
come onsite to your business.
- EMAGENIT can travel to your place
of business to provide Microsoft Excel onsite training and
Microsoft Excel VBA onsite training.
- We can supply
computers for your staff to use for any version of Microsoft
Excel for Windows. We do not supply computers for Excel for
Mac but Mac users are always welcome.
- If teaching the onsite
using GoToMeeting, we can break the training up to meet your
schedule. Contact EMAGENIT for more details.
- EMAGENIT travels all over the
United States presenting our Excel onsite workshops.
- We can also travel outside the
U.S. to Canada and Europe. Please contact EMAGENIT at
1.866.924.6244 for more
information.
- We can broadcast our live hands-on
Microsoft Excel onsite training and Microsoft Excel VBA onsite
training directly to your company via the internet
anywhere around the world at anytime using GoToMeeting.
- During the onsite broadcast,
attendees can see the instructor's computer
and the instructor can see the attendee's computers with
their permission. The instructor can then look at the Excel problem on the attendee's computer
and provide guidance just like standing there in person in class.
- To use GoToMeeting, just perform a simple download. The software does not usually
violate security or anti-virus software.
- Call us at
1.866.924.6244 for more information on how we can
come broadcast live to you over the internet.
- EMAGENIT is based in Thousand
Oaks, CA which is located in Ventura County
and is in the vicinity of Los Angeles County,
Orange County and Santa Barbara County.
- We routinely perform our Excel
onsite training in the Northern California area including
San Jose, CA (Silicon Valley) ; Mountain View, CA ; San
Francisco, CA ; Sacramento, CA ; Napa, CA
- We routinely perform our Excel
onsite workshops all over the Southern California area
including: Santa Barbara, CA;Santa Clarita, CA;Valencia, CA;Goleta, CA; Simi Valley, CA; Newbury Park, CA; Camarillo, CA; Oxnard, CA; Moorpark, CA; Santa Monica, CA; Pasadena, CA; Thousand Oaks, CA; Bakersfield, CA; Sherman Oaks, CA
Encino, CA; Woodland Hills, CA; Reseda, CA; San Fernando, CA; La Canada | Flintridge, CA; Altadena, CA; Chatsworth, CA; Topanga, CA; Calabasas, CA; Burbank, CA; Granada Hills, CA; Los Angeles, CA; Hollywood, CA; Woodland Hills, CA
West Hollywood, CA; Studio City, CA; Westwood, CA; Century City, CA; Santa Monica, CA; Culver City, CA; Marina Del Ray, CA; Hawthorne, CA; Beverly Hills, CA; San Diego, CA; El Centro, CA; Poway, CA; El Cajon, CA; Escondido, CA; Temecula, CA
Camp Pendleton, CA; San Juan Capistrano, CA; Irvine, CA; Anaheim, CA; Huntington Beach, CA; Long Beach, CA; Ridgecrest, CA.
- As stated above, EMAGENIT travels all over the
United States presenting our Excel onsite workshops.
Some of our Excel onsite training locations have included: San Diego, CA; Dallas | Fort Worth, TX; Washington, DC; Portland, OR; Orlando, FL; San Jose, CA; Las Vegas, NV; Kansas City, KS;
Phoenix, AZ; Boston, MA; New York, NY (Wall Street); Alexandria, VA; Greenville, SC; Denver, CO; Pensacola, FL; New Orleans, LA; Charlotte, NC;
Raleigh, NC; Charleston, SC; Nashville, TN; Huntsville, AL; Atlanta, GA; San Jose, CA; Indianapolis, IN; Detroit, MI; Saginaw, MI; Dearborn, MI;
Denver, CO; Seattle, WA; Wichita, KS; Topeka, KS.
Onsites for Business Professionals
View Onsite Details
Beginning Excel
Company Onsite for Business Information
| Overview: |
Our 1-day
hands-on beginning Excel onsite training shows you the
fundamentals of using Excel like entering data, worksheet
formatting, copying and pasting, basic formula construction,
auto summing and more. This Excel onsite not only teaches the
basics of Microsoft Excel but the thinking and mechanics of how
to apply it to everyday problems as well. In addition to
presenting our Excel onsite at your company, we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below to view all the
available public training dates. |
| Audience: |
Business Professionals |
| Duration: |
1-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Intermediate Excel
Company Onsite for Business Information
| Overview: |
Our 1-day hands-on
intermediate Excel onsite training shows you intermediate Excel
skills that apply to analyzing business information. Excel
onsite topics include building formulas using functions like
VLOOKUP,SUMIF and IF; linking and managing worksheet
information; organizing and analyzing worksheet data with
Excel's data tools and functions; building professional charts;
building basic Pivot Tables; cleaning worksheet text; and
linking Excel to other programs like Word and PowerPoint.
In addition to presenting our Excel onsite at your company, we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below to view all the
available public training dates. |
| Audience: |
Business Professionals |
| Duration: |
1-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Advanced Excel
Company Onsite for Business Information
| Overview: |
Our 1-day hands-on
advanced Excel onsite training demonstrates advanced Excel
skills that apply to creating smart adaptive Excel business
tools. This Excel onsite training 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.
in addition, our advanced Excel onsite also discusses the
advanced aspects of these elements and how to assemble them in
ways that you have never seen before. The onsite 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). In addition to presenting our Excel onsite at your company, we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below
to view all the available public training dates. |
| Audience: |
Business Professionals |
| Duration: |
1-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Beginning Excel VBA
Company Onsite for Business Information
| Overview: |
Based on our Excel VBA software design experiences, our
2-day hands-on beginning Excel VBA onsite
training provides a full review of the Excel VBA language
including logic and shows you how to use it to control essential
Excel features like workbooks and worksheets, copying and
pasting, sorting and filtering, worksheet data processing,
calculations, worksheet and VBA functions, worksheet formats,
charts and pivot tables. In addition to presenting our Excel VBA onsite at your company,
we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below
to view all the available public training dates. |
| Audience: |
Business Professionals |
| Duration: |
2-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Intermediate Excel VBA
Company Onsite for Business Information
| Overview: |
Our
2-day hands-on Intermediate Microsoft Excel VBA
onsite focuses on how to use Excel as a sophisticated
data analysis, data fusion and data visualization tool.
Our Excel VBA training starts with the basics showing
you how to use VBA to command Excel's cells, ranges and
data tools in ways that apply to data fusion and data
analysis. It then demonstrates how to analyze data using
various loops, functions and logical techniques with the
focus on handling re-sizing data tables, locating hard
to find headers and reading non-standard data table
formats. It then discusses how to use VBA loops and
logic to perform data fusion on multiple workbooks and
worksheets from multiple folders. It also discusses how
to perform data fusion on multiple text files and
databases fusing all their information together with
data from worksheets. Along with combining databases,
text files and worksheets, how to access and control
other programs is also discussed in our Intermediate
Excel VBA training. How to use Excel VBA to visualize
the collected data in various worksheet table
configurations, charts and drawing shapes is also
covered. In addition to presenting our Excel VBA onsite at your company,
we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below
to view all the available public training dates.
|
| Audience: |
Business Professionals |
| Duration: |
2-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Advanced Excel VBA
Company Onsite for Business Information
| Overview: |
Based on our toughest Excel VBA customer projects, our
3-day hands-on advanced Excel VBA onsite
training shows 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, user forms 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 onsite that we provide. Our advanced
Excel VBA onsite also covers Excel for Mac subject matters. In addition
to presenting our Excel VBA onsite at your company,
we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below
to view all the available public training dates.
|
| Audience: |
Business Professionals |
| Duration: |
3-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Microsoft Excel-Aided Business for Business Professionals
Company Onsite Information
| Overview: |
Learn to use Microsoft Excel and Excel VBA to solve your
difficult business tasks. Our 4-day
hands-on onsite training shows you the steps
and strategies behind using Excel and VBA to produce
business tools that do days of work in seconds. This
onsite takes key Excel topics and features, formula
design, Excel's data features, worksheet functions,
dashboards, charts and VBA macros and condenses them
into one course.
|
| Audience: |
Business Professionals |
| Duration: |
4-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
Onsites for Engineers & Scientists
View Onsite Details
Microsoft Excel Data
Analysis Onsite Information
| Overview: |
Our
1-day hands-on Excel data analysis onsite
training focuses entirely on data processing showing you how to turn Excel into an useful data processing system.
Our onsite shows you how to use Excel's data
processing features along with key formulas and worksheet functions in unique ways to solve
your data needs. It also discusses how to use
logic in not only formulas, but Excel's data tools as well to flag data. Our training also discusses how to use Excel's text file
features, pivot tables and power query to tie into data located in external text files, workbooks and databases.
Last our training also shows how to present your data in charts that respond to user inputs. Taught by an engineer.
|
| Audience: |
Engineers and Scientists |
| Duration: |
1-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
Choice of 2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
View Onsite Details
Advanced Excel
Company Onsite for Engineers and Scientists Information
| Overview: |
Our 1-day
hands-on advanced Excel onsite for engineers and
scientists training shows how to use Microsoft Excel from an
engineering and science perspective to build advanced data
processing tools, visual tools and modeling tools. In the areas
of both modeling and data processing it demonstrates how to
organize and transfer information using names; how to use key
worksheet functions to build advanced Excel formulas; how to
build advanced Excel array formulas; how to build advanced Excel
logical formulas and how to build advanced displays using
ActiveX controls, charts and graphics. Also demonstrated is how
to use advanced Excel data processing features like advanced
pivot tables, Microsoft Query and Excel tables. It also provides
an introduction to Excel VBA macros emphasizing how macros work
and how to create custom VBA worksheet functions. In addition
to presenting our Excel onsite at your company,
we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below
to view all the available public training dates. Taught by an engineer.
|
| Audience: |
Engineers and Scientists |
| Duration: |
1-day onsite |
| Type: |
hands-on, live in-person or via live-online, engineering instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Beginning Excel VBA
Company Onsite for Engineers and Scientists Information
| Overview: |
Our
2-day hands-on beginning Excel VBA onsite for engineers and scientists
training shows from an engineering and science perspective
how to use VBA to control key Excel features, format and process
technical data, perform engineering and science
calculations, create technical charts, create custom
worksheet functions that run from the worksheet, manage large models and
information, create report generation tools and much
more. This Microsoft Excel VBA onsite training begins with a
complete review of the Microsoft Excel VBA language and then
demonstrates the key Excel VBA capabilities that engineers and
scientists need to exploit to get the job done. In addition
to presenting our Excel VBA onsite at your company,
we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below
to view all the available public training dates. Taught by an engineer.
|
| Audience: |
Engineers and Scientists |
| Duration: |
2-day onsite |
| Type: |
hands-on, live in-person or via live-online, engineering instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Intermediate Excel VBA
Company Onsite for Engineers and Scientists Information
| Overview: |
Our
2-day hands-on Intermediate Excel VBA onsite
for engineers and scientists focuses on how to turn Excel into an innovative data processing,
data fusion and data visualization tool for engineering and
science data. Our Excel VBA onsite starts off with showing you
unique ways to control Excel cells, ranges and data tools in
Excel VBA and how these elements can be used together to create high end data fusion and data analysis
tools. Our Excel VBA onsite then focuses on how to
use various loops, Excel worksheet/VBA functions, arrays and logical
techniques to analyze technical data with a focus on reading
unconventional worksheet data layouts, re-sizing moving data areas and
locating hard to find information on the worksheet. Our onsite
then discusses sophisticated data fusion techniques using VBA loops and logic to
sift through data in multiple workbooks and
worksheets from multiple folders. The data fusion discussion
also covers methods for integrating data stored across multiple
mediums including text files, databases
and worksheets. How to access and control other programs is also discussed. Also covered is various data
visualization methods showing how to use
Excel VBA to visualize your collected engineering/science data in various worksheet
table configurations, colored cells, drawing shapes, pictures and charts. In addition
to presenting our Excel VBA onsite at your company,
we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below
to view all the available public training dates. Taught by an engineer.
|
| Audience: |
Engineers and Scientists |
| Duration: |
2-day onsite |
| Type: |
hands-on, live in-person or via live-online, engineering instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Advanced Excel VBA
Company Onsite for Engineers and Scientists Information
| Overview |
Our 3-day hands-on
advanced Excel VBA onsite for engineers and scientists training shows you from an
engineering and science perspective how to use VBA to
create advanced data tools; advanced modeling tools; advanced
database communication tools; advanced dashboards using
ActiveX controls, userforms, charts and shapes; interface with other
programming languages like VB.Net, C and FORTRAN; and
control other programs like Word and PowerPoint. This Microsoft
Excel VBA onsite starts with a complete review of the Excel and
VBA components that engineers and scientists need to develop
advanced tools, then demonstrates the strategies of how to
assemble them. In addition
to presenting our Excel VBA onsite at your company,
we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below to view all the available public training dates.
Taught by an engineer.
|
| Audience: |
Engineers and Scientists |
| Duration: |
3-day onsite |
| Type: |
hands-on, live in-person or via live-online, engineering instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Microsoft Excel-Aided Engineering and Science
Company Onsite Information
| Overview |
Our 4-day
hands-on Microsoft Excel onsite training shows you the steps
and strategies behind using Excel and VBA to craft powerful data
processing and modeling tools. Our Microsoft Excel onsite takes key Excel engineering
and science features, advanced formula design, Excel's
data features, key worksheet functions, dashboard construction basics, technical chart construction,
modeling and Excel VBA macros and condenses them into one
course. Our Microsoft Excel onsite for engineers and scientists
starts with important Microsoft Excel fundamentals like what
worksheet functions to use in Excel for engineering and science
purposes; advanced formula design and information management
covering data processing and modeling; data processing using
Excel 's built-in data tools; and high-end dashboard design
using Excel's built-in interface features like ActiveX controls,
data validation, conditional formatting, charts, pivot charts and
drawing shapes. It then progresses to using Excel VBA to control
these features automatically. Taught by an engineer.
|
| Audience: |
Engineers and Scientists |
| Duration: |
4-day onsite |
| Type: |
hands-on, live in-person or via live-online, engineering instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your examples into our onsite instruction |
View Onsite Details
Interfacing Excel VBA with FORTRAN
Company Onsite Information
| Overview |
Our 3-day
hands-on Microsoft Excel VBA onsite for engineers and scientists training
shows you how to link FORTRAN code with the power of
Excel VBA. Discussed in our Excel onsite is how to use Microsoft Excel VBA
as a front and rear end information processor for
FORTRAN programs and includes a full Excel VBA language
review stressing data processing. Our Excel VBA onsite also shows you how
to layout visual interfaces in Excel that communicate with your
FORTRAN code. Also stressed in our Excel VBA onsite is
how to create FORTRAN DLLs from legacy FORTRAN source
code and mix the two languages together to form a
solution. Taught by an engineer.
|
| Audience: |
Engineers and Scientists |
| Duration: |
3-day onsite |
| Type: |
hands-on, live in-person or via live-online, engineering instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your examples into our onsite instruction |
Combined Audience Onsite
View Onsite Details
Microsoft Excel Dashboards
Company Onsite Information
| Overview: |
Our 3-day hands-on
Excel Dashboards onsite training shows you the complete
mechanics of how to create advanced Microsoft Excel dashboards.
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. Our
onsite shows how to use all of Microsoft Excel's capabilities to
construct these sophisticated dashboards and most importantly
how to assemble them. Our Microsoft Excel onsite also
demonstrates how to build custom worksheet functions using VBA
which provide the ultimate formula construction. In addition
to presenting our Excel onsite at your company,
we also present it as a public training workshop and live online course as well.
You can see the upcoming date for the public training workshop and
live online course below. You can also click the
Date | Signup button below to view all the available public training dates.
|
| Audience: |
Business Professionals, Engineers and Scientists |
| Duration: |
3-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
Choice of 2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics or 2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10, Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
| Other Formats: |
Available also as
Public Training Workshop or
Live online course |
View Onsite Details
Introduction to Excel VBA Macros Onsite
Information
| Overview: |
Learn how to create macros in Excel VBA that will reduce
your troublesome Excel tasks from hours to seconds. Our
1-day hands-on onsite training shows you how to use the
VBA language to control basic Excel tasks like formatting,
copying, pasting, sorting, calculations, data entry, data
processing and automated chart construction.
|
| Audience: |
Business Professionals, Engineers and Scientists |
| Duration: |
1-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
Choice of 2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics or 2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
View Onsite Details
Microsoft Excel VBA Function Onsite
Information
| Overview: |
Our
2-day hands-on Microsoft Excel VBA
function onsite training shows you how to develop your own custom
worksheet functions using Visual Basic for Applications
or VBA. Custom VBA worksheet functions (UDFs) can be
used to replace worksheet formulas on the worksheet that
take up space and file size. They can also do
complicated tasks that regular formulas just cannot do.
From data processing to modeling, they are the ultimate
calculation building block to learn.
|
| Audience: |
Business Professionals, Engineers and Scientists |
| Duration: |
2-day onsite |
| Type: |
hands-on, live in-person or via live-online, instructor taught onsite training |
| Equipment: |
Computers can be supplied, contact EMAGENIT for details |
| Manual: |
Choice of 2000 + page Microsoft Excel-Aided Business
manual full of Excel tips and how-to-do topics or 2000 + page
Microsoft Excel-Aided Engineering and Science
manual full of Excel tips and how-to-do topics included with the onsite |
| Platform: |
Windows 7 - Windows 10,
Mac users welcome |
| Excel Versions: |
2007-2016, Windows and Mac |
| Free Repeats: |
Repeat your Excel onsite instruction in our public workshops, see
details |
| Examples: |
We analyze your company's needs and work your
examples into our onsite instruction |
