Our Consulting History
EMAGENIT has been
providing consulting services in Microsoft Excel and Microsoft
Excel VBA for over 14 years. We have had the privilege of
working with companies like Verizon, Caterpillar, Dura
Automotive and with government agencies like NASA, the US Air
Force and the US Navy. We have a diverse background in both the
technical industries and business fields. We find that is a
tremendous bonus as we are able to mesh the two worlds together
applying high tech solutions we have learned in both to a
specific customers problem.
NASA Award for Microsoft
Excel Design
|
 |
EMAGENIT received a
NASA award for its
software design in Microsoft Excel and VBA for the Mars Rover. Click the
hyperlink above to see how we did it. |
Microsoft Excel Consulting Key Topics
(Non-Macro)
EMAGENIT provides Microsoft Excel consulting
in the areas of business, engineering and science. Our Microsoft Excel consulting
covers building projects in Excel,
consulting on how to build projects
in Excel or fixing problems in Excel
We can build, show you how to build or
fix:
-
Basic worksheet functions like VLOOKUP, INDIRECT, ROW, COLUMN,
INDEX, MATCH, COUNTIF, COUNTA
-
Basic and advanced table lookups
-
General worksheet
formulas and advanced worksheet formulas including array
formulas and nested worksheet functions
-
Dynamic
ranges that automatically adapt to changing data boundaries on the
worksheet
-
Pricing
spreadsheets, schedules and time lines
-
Formulas that detect start
and stop points in a row or column
-
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 array formulas
-
Tables in a
workbook so they can be utilized as a database and
accessed with such tools as Microsoft Query, Microsoft Access or SQL
Query
-
Text
functions like CLEAN, SUBSTITUTE, REPLACE, LEFT, RIGHT, MID, SEARCH,
LEN, LOWER and UPPER to clean worksheet data for analysis such as
comparisons
-
Large
models in Excel and organize their information for later use with
VBA (macros) and ActiveX controls
-
Large worksheet models that use SOLVER
-
Advanced Pivot Tables
In case you want to take a workshop on we just talked
about, the following workshops cover the same basic
material:
Microsoft Excel Macro (VBA) Consulting Key
Topics
EMAGENIT provides Microsoft Excel
Macro (VBA) 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 (VBA) consulting covers building
projects in Excel VBA, consulting on how
to build projects in Excel VBA or fixing projects in
Excel VBA.
We can build, show you how to build
or fix:
-
VBA macros that process worksheet data on a single
Microsoft Excel worksheet
-
Excel VBA macros that process data in multiple Microsoft Excel
workbooks and on multiple Excel worksheets
-
Macros that search for specific worksheets and
workbooks that are open in Excel and that lock onto their data
-
VBA macros that fill in complex tables and
forms from raw data
-
Macros that automatically create
workbooks and worksheets and automatically fill in the formulas on the
worksheets. Great for creating financial statements
-
Excel VBA macros that automatically create charts in Microsoft
Excel
-
Charting programs using Excel VBA, ActiveX
controls, userforms and events
-
VBA macros that query a database,
workbook or text file using SQL, ADO or DAO
-
Macros that integrate multiple data sources
(databases, text files, workbooks) together
-
Excel VBA macros that update and control databases
like Microsoft Access, SQL Server, Oracle...
-
Advanced dashboards using events, ActiveX controls, charts, drawing
shapes and the worksheet itself
-
VBA macros that control Microsoft Outlook
scanning for emails and downloading data
-
Advanced Excel VBA programs that
update and redraw themselves
-
Time driven dashboards that perform tasks at a
specific time and date
-
Macros that communicate with Google Gmail
and Google Spreadsheets
-
VBA macros that automate advanced Pivot Table creation
-
Report generation tools using Excel VBA
macros that control Microsoft Word and Microsoft PowerPoint
-
Excel VBA macros that compare tables on a worksheet
-
VBA macros that clean data for table comparisons removing
inconsistencies such as blanks, -, inc...
-
Macros that automatically open text files and
Microsoft Excel workbooks
-
Excel VBA macros that control the Windows folder
and file system
In case you want to learn how to do what we just talked about,
the following workshops cover the same basic material:
|
|
|
