EMAGENIT teaches
US Space Force.
EMAGENIT recently finished teaching our
Excel VBA > and
Excel VBA Data
Analysis > classes onsite at Vandenberg Space Force Base. We thank them
for the opportunity to provide Excel VBA training for their
personnel.
We were even onsite at 3:46 AM to see the SpaceX Falcon 9
successful launch of
S.W.O.T > and the landing of their first stage booster
which was awesome! Read below and see what we can do for your base
personnel.
US Military, DOD, and Contractor Discount.
EMAGENIT provides a 20% discount off all our Excel training products for the US military. This includes
active, retired, and DOD personnel. We provide a 15% discount for all US military contractors.
*Not applicable to other discount specials.
If purchasing an Excel product from us, you can call us directly at 1.805.498.7162 to
purchase the product and receive this discount. If using our checkout cart, just make a note of it in the comments section and we will refund the discount.
 |
|
US military training mission.
EMAGENIT's training mission is simple,
to provide innovative, cost effective Excel training that enables the US
Military to quickly solve problems using Microsoft Excel. Our training concepts can be applied at
any level from office to battlefield, from
repetitive reports to data
crunching to hi-tech apps.
Harnessing our 24+ years of Excel software design experience, EMAGENIT can show the US military how to exploit
Excel's "off the shelf" features quickly. These features can be rapidly combined to make tools that
help with common workplace tasks or sophisticated analysis,
visualization, and data processing tasks. Excel can also be used to develop
software in very short design cycles that rival or surpass industry
developed software at a fraction of the cost.
Click to enlarge.
The example above is a very simple technology demonstrator that displays test data or simulates threats like mines and ships based on GPS coordinates related to a ship's current position. The cell grid is left visible to let you know it is
Excel. The Excel app has the capability to update its data at a certain interval or could go real time if desired. It also uses multiple data sources and acts like a communications gateway fusing their data and transforming it into a simple
interactive click-on visual display. The app combines many features of Excel like the worksheet, shapes, charts (compasses), userforms, and VBA. It is knowing how to combine these "off the shelf" capabilities rapidly that is the trick, EMAGENIT can show how it is done.
|
|
Excel fundamentals training for all types of US Military tasks.
Learning the Excel fundamentals provides the US military with the
ability to quickly store and retrieve data; perform various
calculations; rapidly create charts and reports; process and fuse data;
model; create interactive displays and maps; and much more.
Our training
can be applied to tasks like finance, logistics, inventory, projects,
battlespace display and analysis, personnel, force levels, data
analysis, engineering / science...etc.
Our Excel classes can be taught as is (see
video on the class pages) or with a specific military
focus. Classes specifically for engineering and
science are abbreviated as eng /sci.
Military Examples >
Beginning Excel
Intermediate
Advanced Excel
Excel for Eng / Sci
Excel Data Eng / Sci
In our Excel fundamentals training, we demonstrate how to design worksheet
tables that automatically adapt to changing data. Tables are the key to effectively storing, processing, and calculating data and
analytics in Excel. Our training also shows how to build basic formulas and formulas that use important worksheet functions like MIN,
SUMIFS, VLOOKUP, and adjustable names to effortlessly track changing data on other sheets.
In our Excel fundamentals training, we demonstrate how to lookup information in tables using functions like VLOOKUP. Our training also demonstrates how to
implement logic on the worksheet using functions like IF, AND, and OR in formulas. We also show you how to lay problems out on the worksheet and use Conditional Formatting
to automatically flag cell values that do not meet limits or match a certain criterion like the type of leave being taken.
In our Excel fundamentals training, we demonstrate how to create basic to advanced charts for multiple disciplines. Our training shows you how to
design the tables that support the different chart types as well as the different formatting methods and chart settings needed to create military grade charts rapidly.
In our Excel fundamentals training, we demonstrate how to process data using formulas, logic, filters, and charts. Our training shows you how to rapidly process data
using these tools and also build reusable, scalable data tools which you just drop new data into and the rest adjusts. We also show how to link to, shape, and fuse external workbook, text file,
and database data using Power Query so your data updates automatically.
In our Excel fundamentals training, we demonstrate how to assemble simple to complex model and analysis problems on the worksheet using formulas, functions, and tables.
Our training can show you how to organize and lay them out, format them, and use names to rapidly connect multi worksheet and workbook based models together. We also show you how to use Data Validation to control model input
and Conditional Formatting to automatically color cell values that do not match requirements.
In our Excel fundamentals training, we demonstrate how to rapidly create dynamic displays that fuse data into easy to understand visuals. Our training shows you how to
organize the tables that feed them information and how to link and integrate the shapes, controls, pictures, Data Validation, Conditional Formatting, and charts used to construct them. All of our fundamental courses provide the pieces to build these type of displays quickly.
In our Excel fundamentals training, we demonstrate how to create adaptive reports using Excel tools like Pivot Tables and Power Query. Pivot Tables provide a way to rapidly
configure table data into different groupings summing and counting their data among other things. Our training also shows you how to assemble the data for these tables using functions like VLOOKUP, TEXT, COUNTIFS, INDEX… and
linking to different external data sources via Power Query. We also show how to use things like slicers and Pivot Charts to rapidly create interactive reports.
Scroll < > if hidden.
|
1 / 7 |
|
| < |
In our Excel fundamentals training, we demonstrate how to design worksheet tables that automatically adapt to changing data. Tables are the key to effectively storing, processing, and calculating data and
analytics in Excel. Our training also shows how to build basic formulas and formulas that use important worksheet functions like MIN, SUMIFS, VLOOKUP, and adjustable names to effortlessly track data on other sheets. |
> |
|
|
Tactical to practical Excel dashboard training
for the US Military.
Microsoft Excel's built-in dashboard abilities provide the US military with a flexible design environment to rapidly develop visual tools
that fuse, process, and present data in a variety of different ways. Our training covers how to quickly combine key Excel elements
like charts, formulas, tables, Pivot Tables, filters, Power Query... to fuse and process multiple data sources for visual
presentation.
We cover the major types of dashboards including operational, strategic, analytical, and tactical as well as anything the military can dream up.
Our Excel dashboard class can be taught as is (see
video on the training page) or with a specific military
focus. Microsoft Excel Dashboards >
Military Examples >
In our Excel dashboards training, we demonstrate how to rapidly assemble charts, shapes, and linked pictures to display a multitude of data. Our training will show you how
to layout the worksheet tables, crunch the data that the charts use, and format them. We will show you how to link shapes to cell values so they dynamically update when the cell data does and also create linked pictures to cell
ranges so when their color changes based on logic (Conditional Formatting), the pictures in the displays change color. Great for displaying threats, force levels...etc.
In our Excel dashboards training, we demonstrate how to quickly assemble charts and shapes to display test data in various formats. Our training will show you how to combine different
charts together to form unique displays that can read individual test points as well as data over a period of time. We will also show you how to construct the formulas that lookup or calculate the data being viewed and
how to store the charts for rapid use later.
In our Excel dashboards training, we demonstrate how to rapidly build various types of schedulers, Gantts, timelines... using Conditional Formatting. In these timelines, breakdowns
can be by the year, month, day, hour,...etc. Our 'training will also show you how to leverage the Group feature so parts of the worksheet can be expanded or hidden at the click of a button so key metrics can be displayed or hidden. We
will also show you how to combine Excel tables with Slicers so worksheet data can be rapidly filtered changing worksheet displays and charts.
In our Excel dashboards training, we demonstrate how to rapidly integrate various type of maps with drawing shapes, linked pictures, charts... to create dynamic moveable display
boards. Our training will also show you how to crunch and integrate the data necessary for these type displays and also develop the cells and Conditional Formatting that will be dynamically displayed over the map areas as linked pictures.
Since shapes, charts, and linked pictures can be easily moved by a simple drag, static displays can be developed like above as well as tactical and battlespace displays showing changing threats, positions, force levels...The data for these
displays can be linked to external sources and updated automatically.
In our Excel dashboards training, we demonstrate how to rapidly build dashboards using built-in tools like PivotTables, Pivot Charts, and Power Query. Our training will show you how
to link to external data in other workbooks, text files, databases, fuse that information together using tools like Power Query, Excel tables, and formulas, and then quickly organize that data into PivotTables. PivotTables are a great
tool to use when you want to rapidly summarize and count data among other things. We will also show you how to tie charts, shapes, and pictures with that data to create truly flexible displays.
Scroll < > if hidden.
|
1 / 5 |
|
| < |
In our Excel dashboards training, we demonstrate how to rapidly assemble charts, shapes, and linked pictures to display a multitude of data. Our training will
show you how to layout the worksheet tables, crunch the data that the charts use, and format them. We will show you how to link shapes to cell values so they dynamically update when the cell data does and also create linked
pictures to cell ranges so when their color changes based on logic (Conditional Formatting), the pictures in the displays change color. Great for displaying threats, force levels...etc. |
> |
|
|
Excel VBA macro training for tough US Military problems.
Our Excel VBA training provides the military with the ability to build scalable, adaptive, upgradeable Excel apps.
These apps
can not only automate calculations, but perform a variety of
hi-tech data tasks as well including reformatting, processing,
and fusing multiple data sources (gateway apps). They can
also visualize data in military style displays and much more.
Since VBA automates Excel's pre-built capabilities as well Word, PowerPoint, Outlook...,
robust apps can be built using "off the shelf" elements saving enormous amounts of time, effort, and money.
Our Excel VBA classes can be taught as is (see
video on the class pages) or with a specific military
focus. Classes specifically for engineering and
science are abbreviated as eng /sci.
Military Examples >
Beg Excel VBA
Excel VBA Data Process
Advanced Excel VBA
Excel VBA Eng / Sci
Excel VBA Data Eng / Sci
Adv Excel VBA Eng / Sci
In our Excel VBA training, we demonstrate how to process downloaded military data rapidly with VBA. Many times, military data downloads are not in the format that
is needed to be processed or arrive in several disconnected downloads that need to be combined . We will show you how to write VBA code that quickly performs lookups between multiple files, cleans data, builds formulas, formats, organizes data...reducing tasks that take hours to seconds at the click of a button.
In our Excel VBA training, we demonstrate how to perform from simple to complex calculations with VBA. Our training can show you not only how to perform calculations
internally in VBA, it also shows how to use VBA to create calculation fields and formulas on the worksheet that morph with control selections and changing data. Depending upon the circumstances, sometimes it is advantageous to have
formulas created directly on the worksheet. In addition to calculations, we also demonstrate how to tap into Excel's built-in drawing abilities using VBA to dynamically draw what is being calculated.
In our Excel VBA training, we demonstrate how to create advanced models with Excel VBA. Our training can show you how to build powerful VBA User Defined Worksheet Functions (UDF)
that can be used in a formula like a regular worksheet function, but offer calculation abilities that far surpass normal formulas. We also give you strategies of how to break models into multiple workbooks for group use but still retain their
link. Last we can show you how to use VBA to run model trade studies and automate Excel's built-in Solver tool to perform model optimization.
In our Excel VBA training, we demonstrate how to use VBA and Excel to rapidly process and fuse multiple data sources into reports, dashboards...etc. In today's military, many
different systems download information into hundreds files, data is also stored in multiple databases that do not download. Excel's built-in data processing features along with VBA automation and SQL allows powerful apps to be developed that
integrate hundreds even thousands of files along with multiple databases in ways not possible in other programming environments. Our training will show you our industry proven ways on how to quickly build these gateway apps and their interfaces
making them rapidly adaptable, upgradeable, scalable, and most of all affordable.
In our Excel VBA training, we demonstrate how to use VBA and Excel to rapidly create various types of high-end reporting tools. Automating Excel's reporting tools with VBA like
PivotTables, Filters, and Sort and Text tools, and then coupling that with VBA's own abilities, Excel can be turned into a report generation machine with very little time and effort expended. Our training can also show you how to use Excel VBA
to command Word, PowerPoint, and Outlook allowing those reports generated in Excel to be packaged and emailed automatically.
In our Excel VBA training, we demonstrate how to use Excel and VBA to create powerful charting tools for test analysis. Our training will show you how to use VBA to automate and format
various charts so then can be repeatedly created at the click of a button to military specifications. We will also show you how to develop the interfaces for these tools using VBA elements like ActiveX controls and userforms so you can rapidly select
various parameters and things like time and date ranges to chart. Last, we will also show you how to use VBA to process the data used by the charts and how to layout multiple charts on a worksheet automatically.
In our Excel VBA training, we demonstrate how to use Excel and VBA to create advanced military grade displays. Excel's built-in grid system, shapes, pictures, and worksheet cells coupled
with VBA can be utilized to rapidly create dynamic displays that adapt to incoming data. Our training will also show you how to design these style displays at minimum cost and time. In the simple technology demo above, the user can select a variety of
aircraft and metrics to read in the black boxes in any order (simulates an America class LHA). Below that area, a simple mission planner can be used to calculate mission duration to a specific GPS point. Data in the example is feed from multiple data
sources and apps like these can easily be converted to real time data.
|
1 / 7 |
|
| < |
In our Excel VBA training, we demonstrate how to process downloaded military data rapidly with VBA. Many times, military data downloads are not in the format that
is needed to be processed or arrive in several disconnected downloads that need to be combined . We will show you how to write VBA code that quickly performs lookups between multiple files, cleans data, builds formulas, formats,
organizes data...reducing tasks that take hours to seconds at the click of a button. |
> |
Our history with the United States Space Force.
EMAGENIT
has provided Excel VBA onsite training at Vandenberg Space Force
Base.
Our history with the United States Marine Corp.
EMAGENIT has provided Excel onsite training for the Marine Corps Base Camp Pendleton. We have also taught Excel to Marine Corp
personnel from the Marine Corp Base Quantico in our public courses.
Our history with the United States Navy.
EMAGENIT has provided Excel onsite training at Naval Base San Diego, Naval Air Weapons Station China Lake, and NSWC Panama City. We have also taught Excel for personnel from Naval Air Station Point Mugu, Naval Construction Battalion
Center Port Hueneme, Naval Air Station Patuxent River, and Naval Air Weapons Station China Lake in our public courses.
Our history with the United States Army.
EMAGENIT has taught Excel onsite to the DEVCOM Army Research Lab. We provided training support on how to analyze test data using Excel VBA.
Our history with the US Air Force.
EMAGENIT has provided Excel
onsite training for Edwards Air Force Base, Nellis Air Force
Base, Creech Air Force Base, Eglin Air Force Base. In addition to these bases, we have also provided
Excel training for various Air Force base personnel in our public courses.
_EMAGENIT_2019.png)
_EMAGENIT_2021.webp)
