NASA Award for Microsoft Excel Design
|
|
 |
|
EMAGENIT received an award
from
NASA for its
software design in Microsoft Excel and VBA for the Mars Rover. We provide
consulting
for customers like AMGEN and General
Dynamics. Read below to learn more about our Microsoft Excel
consulting.
Click here for our
software design. |
|
Microsoft Excel Consulting Key Topics
(Non-Macro)
|
|
EMAGENIT provides general Microsoft Excel consulting
in the areas of business, engineering and science. Our Microsoft Excel consulting
covers topics like:
-
How to use basic worksheet functions like VLOOKUP, INDIRECT, ROW, COLUMN,
INDEX, MATCH, COUNTIF, COUNTA
-
General worksheet
formula and advanced worksheet formula design including array
formulas and nesting functions
-
How to build dynamic
ranges that automatically adapt to changing range size
-
How to build pricing
spreadsheets, schedules and time lines
-
How to build formulas that detect start
and stop points in a row or column
-
How to implement logic
on the worksheet creating "thinking worksheets" using the IF, AND,
OR, NOT functions
-
Advanced dashboard
worksheets that utilize ActiveX controls, Data Validation,
Conditional Formatting, charts and advanced summary formulas
-
How to store data in a
workbook as an alternative to a database
-
How to store data in a
workbook so it can be utilized as a database and
accessed with such tools as Microsoft Query
-
How to use text
functions like CLEAN, SUBSTITUTE, REPLACE, LEFT, RIGHT, MID, SEARCH,
LEN, LOWER and UPPER to clean worksheet data for analysis such as
comparisons
-
How to construct large
models in Excel and organize their information for later use with
VBA (macros) and ActiveX controls
-
How to use Solver to drive
large models
-
How to construct advanced Pivot Tables
Our
Intermediate Microsoft Excel and Advanced Microsoft Excel
training cover the topics presented above and more.
|
Microsoft Excel Macro Consulting Key
Topics
|
EMAGENIT provides Microsoft Excel
Macro consulting in the areas of business, engineering and science.
Excel Macros are constructed in Visual Basic for Applications and are
also know as VBA procedures. Excel VBA comes free with Microsoft Excel. Our Microsoft Excel
macro consulting covers
topics like:
-
What
is VBA or a Macro?
-
How to process worksheet data on a single
Microsoft Excel worksheet
-
How to process data in multiple Microsoft Excel
workbooks and on multiple Excel worksheets using macros
-
How to search for specific worksheets and
workbooks open in Excel using VBA
-
How to automatically create charts in Microsoft
Excel using macros
-
How to create charting programs using ActiveX
controls, userforms and events
-
How to use an Excel macro to query a database,
workbook or text file using SQL and ADO
-
How to integrate multiple data sources
(databases, text files, workbooks) together using Excel macros
-
How to update a database using VBA
-
How to encrypt data on Microsoft Excel worksheets
using Excel VBA
-
How to use macros to create advanced event
driven dashboards on the worksheet using ActiveX controls, charts, drawing
shapes and the worksheet itself
-
How to create advanced Excel VBA programs that
update and redraw themselves
-
How to create advanced event driven
dashboards on userforms using ActiveX controls
-
How to automate advanced Pivot Table creation
using Excel VBA
-
How to automate report generation using Excel
macros, Word macros and PowerPoint macros
-
How compare tables on a worksheet using VBA
-
How to clean data for table comparisons removing
inconsistencies such as blanks, -, inc...
-
How to automatically open text files and
Microsoft Excel workbooks
-
How to scan Windows folders for specific files
and retrieve their data in an Excel macro
Our
Beginning Microsoft Excel VBA for
Business, Beginning
Microsoft Excel for Engineers and Scientists,
Advanced Microsoft Excel
VBA for Business and
Advanced Microsoft Excel VBA for Engineers and Scientists cover the topics presented above and more. |
|
Examples
(From Our Manuals)
|
|
We cannot show what we
do for clients, but we can show some
basic examples from our manuals that reflect
what we do for our clients. |
Remember, we consult
in engineering, science and business so the examples
rotate between them down the page.

1. Advanced array formula
design like a calendar that reads a table and fills itself
out

2. Advanced formula
design including numerical techniques like Runge Kutta 4th
Order

3. Dashboard design using
ActiveX controls and formulas (No Marco)

4. Dashboard design using
ActiveX controls, Conditional Formatting, Data Validation
and formulas (No Macro)

5. Automated chart, workbook and
worksheet creation using Excel and VBA (report generation).
We also automate Word and PowerPoint.

6. Advanced schedulers and
calendar systems using VBA, databases and worksheets

7. Advanced project management
interfaces using VBA, userforms, databases and worksheets

8. Interactive dashboards that
utilize ActiveX controls, VBA, charts and worksheets

9. Advanced engineering
interfaces that combine drawing shapes, charts, pictures,
VBA and a whole lot of math. The picture you see was drawn
by Excel using very small lines.

10. Advanced database
communication using VBA, VB. NET, DAO, ADO, ADO.NET and
Excel
|