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 training for
customers like AMGEN, General Dynamics and Caterpillar. Read
below to learn more about our Intermediate Excel Training. |
|
- Onsite, Self-Study,
Public, Webinar
Intermediate Excel Training Focus
|
Our "hands-on"
intermediate Excel training focuses on
useful formula design for data processing
and modeling, using Excel's built-in range
features like Data Validation, useful
worksheet functions like VLookup and
applying Excel's built-in data processing
tools and worksheet functions to analyze and
clean text files and worksheet tables. We
teach you how to develop analysis and data
processing problems on the worksheet then
how to determine the proper Excel tools to
create a unique solution. In all of our
workshops, we evaluate our clienteles'
knowledge level, their problems and adjust
our curriculum to their specific needs.
What You Learn at a Glance
|
-
Intermediate Microsoft Excel skills for
constructing business charts and formatting them
-
How to use logical, reference, lookup and
information Microsoft Excel worksheet functions to build "smart"
business worksheets including VLookup, SumProduct, Index, Match,
CountIf, SumIf, If, And, Or, Round, IS functions and Indirect
-
How to construct array formulas and
summary worksheets
-
How to construct dynamic ranges in
formulas that adjust to table size
-
How to use the text Microsoft Excel
worksheet functions to parse text in cells including Right, Mid, Left,
Substitute and Replace
-
Intermediate Excel skills for returning
arrays from Microsoft Excel worksheet functions
-
How to use Text Wizard and Text to Columns
to parse text into the worksheet
-
Intermediate Microsoft Excel skills for
using the data validation and conditional formatting worksheet
features
-
How to use Microsoft Excel's built-in
analysis tools (sort, Advanced Filter, AutoFilter) for analyzing
worksheet data using
-
Intermediate Excel skills for drawing and
importing pictures on the worksheet
-
How to create simple worksheet based
business forms and questionnaires
-
How to create and use basic Microsoft
Excel pivot tables
-
How to link Microsoft Excel to Word and
PowerPoint for report generation
* If you are looking for advanced formula design
and dashboards, try our
Advanced Microsoft Excel workshop
-
1-day workshop
-
Personal examples:
Covered in-class
-
Excel Versions:
2000-2010
-
Type: Business
Professionals
-
Platform: Windows or
Mac
-
Training Materials: Included, 1800+ page manual
-
Training Method:
Hands-on
In this 1-day "hands-on" workshop you will
learn:
-
Basic formula and cell name review
-
Conditional Formatting / Data
Validation: How to use the conditional formatting and data
validation Microsoft Excel worksheet features
-
Smart Worksheets: How to construct
"smart" Microsoft Excel worksheets using Excel's logic, information,
lookup and reference worksheet functions including VLookup, Match,
SumProduct, CountIF, SumIf, Index, If, And and Or
-
Text Functions: How to use the text
Microsoft Excel worksheet functions including Right, Mid, Left,
Substitute and Replace
-
Nesting Worksheet Functions: How to
nest Microsoft Excel worksheet functions to create smart worksheets
-
Concatenation: How to perform
concatenation in Microsoft Excel worksheet formulas
-
Databases / Lists:
How to create and manage
databases in Microsoft Excel
-
Sort / AutoFilter /
Advanced Filter Tools: How to use Microsoft Excel's database
management tools like the sort, form, AutoFilter and Advanced Filter
tools
-
Text Wizard and Text to Columns:
How to use with text files and Microsoft Word
-
Using Ranges: How to use ranges in
Microsoft Excel worksheet functions
-
Array Formulas: How to use array
formulas to build summary sheets and dashboards
-
Dynamic ranges: Learn how to build
ranges in formulas that adjust to table size
-
Drawing / Pictures /
Flow Charts: How to use Microsoft Excel's drawing tools to create
graphics on the worksheet including business flow charts
-
Business Report
Generation: How to use Microsoft Excel as a daily or weekly
business report generator
-
Forms / Questionnaires: How to
construct business forms and questionnaires in Microsoft Excel
-
Pivot Tables: How to create and use
basic Microsoft Excel pivot tables
-
Link Excel to Word and PowerPoint:
Learn the basics of linking Microsoft Excel to Word and PowerPoint for
report generation
Click here for
Schedule, Pricing, Enrollment
-
Microsoft Excel users that understand basic worksheet skills (typed
in a cell, used a formula before, opened a workbook...etc).
-
It is intended for all types of professionals.
EMAGENIT's Training Location (Public Workshops)
|
Hotel: Thousand Oaks
Inn
EMAGENIT is based in Thousand Oaks,
CA which is in the vicinity of Los Angeles county (LA County),
Ventura county, Santa Barbara county and San Diego county. We
hold all of our courses
on-site
nation wide. We also webcast (webinar) our public workshops, consult
our
webcast page for more information.
Our
public workshops are a short commute for those living in:
-
Los Angeles, CA
-
Palmdale, CA
-
Westwood, CA
-
Santa Barbara,
CA
-
San Fernando
Valley, CA
-
Santa Clarita,
CA
-
Newbury Park, CA
-
Westlake
Village, CA
-
Camarillo, CA
-
Calabasas, CA
-
Sherman Oaks, CA
|
-
Reseda, CA
-
Woodland Hills,
CA
-
Hollywood, CA
-
Fillmore, CA
-
Ventura, CA
-
Moorpark, CA
-
Simi Valley, CA
-
Santa Monica, CA
-
Oxnard, CA
-
Pasadena, CA
-
Agoura, CA
|
For more information about
our public workshops, visit our public
workshops page our call us at 805.498.7162.
Submit a question to us via email at
intexcel@emagenit.com
Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at
1.805.498.7162 or 805.558.9277 for more information about this
workshop.
|
|
Training Schedule, Enrollment,
Self-Study |
-
Training manual
(1800+ pages) included with workshop
-
Repeat the workshop
as many times a
you like.
Click here for details
-
Our
webinar (webcast) is
broadcast live
exactly when the workshop is being taught. You
can talk directly to the teacher and see the
teacher's computer screen. It is hands-on
instruction
-
Read about
EMAGENIT
and our Customers

|