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
-
1-day workshop
-
Personal
examples: Covered
in-class
-
Excel Versions:
2000-2007
-
Type: Business
Professionals
-
Platform: Windows or Mac
-
Training Materials:
Included, 1600+ page manual including our Excel
Add-Ins
-
Training Method: Hands-on
|
Workshop Outline and Self-Study
Manual Content |
In this Intermediate Microsoft
Excel 1-day "hands-on" business workshop or self-study
manual, EMAGENIT covers:
-
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
|
Training Options, Signup and Self-Study |
-
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 |
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.
|
|
EMAGENIT
NASA Award for Excel |
 |
|
EMAGENIT received an
award for its involvement with NASA JPL in helping
redesign and integrate their conceptual Rover
mission software in Microsoft Excel. Click the
picture above for more detail about our Rover
involvement. To learn more about the NASA mission to
mars
click here. |
|
Awards &
Customers |
|