|
Workshop Details
Type: Business
Professionals
Offering Types: On-Site, Public, Self-Study Manual
Platform: Windows and
Mac
Versions: 97-2007
Training: Hands-On
Workshop Manual:
Price and Buy
Public Training:
Dates and Signup
Hotel: Thousand Oaks
Inn
Onsite Training:
Details
What is Included in the Workshop
-
Our Excel Aided Business manual
containing over 1600 pages of Excel and VBA instruction
and hundreds of examples
-
If signup for the on-site or public
holding of the workshop, you can retake the public offering of
the workshop as many times as you wish, no date or repeat limit
*Detailed outline below
Workshop and Manual Overview
In our Advanced Microsoft Excel
business 1-day "hands-on" workshop, EMAGENIT covers:
- Advanced Microsoft Excel
communication strategies with databases using Microsoft Query
- Worksheet techniques for
constructing business forms using ActiveX controls and form controls
- Dashboard construction
- Advanced Microsoft Excel
skills for linking separate workbooks and worksheets
- Advanced Excel skills for linking with other applications (OLE)
- Advanced Microsoft Excel
skills for importing text files
- Advanced Excel skills for sharing workbooks
- Advanced Microsoft Excel
skills for constructing time formulas on the worksheet
- Advanced
Excel pivot table construction
- Advanced Microsoft Excel use
of the Macro Recorder and VBA Editor
- Advanced use
of Goal Seek and Solver
*We review personal problems in
our workshops.
* If you are looking for
advanced formula design, try our
Intermediate Microsoft Excel workshop
Workshop Outline
(Every part of our workshop is
hands-on)
- Time Formulas: Working with time formulas
on the Microsoft Excel worksheet
- Workbook Templates /
Worksheet Templates: How to create and use
Microsoft Excel workbook and worksheet templates
- Business Forms: How to use ActiveX
controls and form
controls to create advanced business forms on the Microsoft Excel worksheet
- Dashboards: How to
create dashboards using charts, array formulas (SumProduct,SumIF,Index,CountIF...etc)
- Linking Workbooks: Link workbooks and worksheets together including team and network issues
- Sharing Workbooks: How to share Microsoft Excel
workbooks over a network
- OLE Automation: How to link
Microsoft Excel with other applications
- Importing Text Files: Importing text files into
Microsoft Excel using various file formats
- Pivot Tables: How to
create and build advanced pivot tables
- Microsoft Query: How to access databases from
Microsoft Excel using Microsoft Query and ODBC
- Microsoft Access: How to update Microsoft
Access tables directly from Microsoft Excel
- Microsoft Excel Security: Microsoft Excel workbook and
worksheet security issues
- Macro Recorder: Introduction to Microsoft
Excel VBA code using the Macro recorder
Who Should Attend
- Intermediate
Excel users with a basic knowledge of Excel.
- It is
intended for all types of business professionals.
EMAGENIT's
Public Training Location
Hotel: Thousand Oaks
Inn
EMAGENIT is based in Thousand Oaks,
California 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
on-site courses nation wide.
Our public workshops are a short commute for those living in the Santa
Barbara, San
Fernando Valley, Santa Clarita, Newbury Park, Camarillo, Calabasas,
Sherman Oaks, Reseda, Woodland Hills, Hollywood, Fillmore, Ventura,
Moorpark, Simi Valley, Santa Monica and Oxnard areas. For more information about our public workshops,
visit our public workshops page our call us at the
number above.
|
|
EMAGENIT
NASA Award |
 |
|
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 |
|
Call Us |
|
Call EMAGENIT between the hours of 8:00 A.M. and 5 P.M. PST at
1.805.498.7162 or 805.728.5681 for more information about this
workshop. |
|
|
