Workshop Details
Type: Business
Professionals
Platform: Windows
Versions: 97-2007
Training: Hands-On
Public Training:
Dates and Signup
Hotel: Thousand Oaks
Inn
Web Cast Information:
Details,
Signup
Onsite Training:
Details
*Our
Beginning VBA and
Advanced VBA
business workshops also cover dashboard construction while building
your Excel VBA skills.
Workshop and Manual Overview
In this Microsoft Excel
dashboard 3-day "hands-on"
business workshop, you will learn:
-
What
is VBA?
- A Microsoft Excel VBA language
review emphasizing dashboard construction
- General VBA programming
techniques for analyzing and organizing business data for use in
Microsoft Excel dashboards
- Advanced data analysis
calculations using VBA and worksheet functions
- How to fully command Excel's
visual interface including drawing shapes, pictures, cells
- How to align Excel's visual
elements on the worksheet and create timelines,
meters, performance diagrams, trees...etc using
VBA
- How to process data from
multiple workbooks / multiple worksheets and organize their charts on a
single worksheet using VBA
- How to open multiple workbook
files automatically using the Windows filing system and VBA
- How to open and read text file
downloads
- How to communicate with databases (SQL Server, Access, ...)
using DAO and ADO
- How to construct an interface
that controls your Excel dashboard application using ActiveX controls
and VBA
- How to create events
(automated procedures) for your Excel dashboard applications
- How to command Microsoft Word
and PowerPoint for dashboard report purposes
Microsoft Excel
Dashboards Overview
The capability exists within Microsoft Excel and
Excel VBA to construct
sophisticated dashboards that integrate seamlessly with data based in Microsoft
Excel or in other external data sources.
Using a combination of the Excel
worksheet, drawing shapes, pictures, ActiveX controls, cells and charts, sophisticated
dashboards can be constructed in minimal time providing a cost
effective way of a business to view its important data.
Many companies are turning to constructing dashboards
in Excel due to the lower cost, lower development time and
because of Excel's exceptional abilities.
Workshop
Topics (Every part of our workshop is hands-on)
Day-1
- General Microsoft Excel VBA language
review emphasizing Excel dashboard construction
- Overview on how to use
Excel as a dashboard for data
- New ways of using Excel components
- How to use VBA to command
worksheets (borders, fonts, cell colors, backgrounds...) drawing
shapes, charts, pictures and ActiveX controls
- How to create timelines,
meters, performance diagrams, trees...etc using Microsoft Excel and
VBA
- How to align Excel's visual
elements on the Excel worksheet
Day-2
- How to read text files and
command the Windows filing system (Open, Close, Delete..) using VBA
- How to process data from
multiple workbooks / multiple worksheets and organize their charts
on a single worksheet using VBA
- Advanced data analysis
calculations using VBA and worksheet functions
- How to create a look for
your dashboard application (graphics, headers, gradients...)
- How to construct an
interface that controls your Excel dashboard application using
ActiveX controls and VBA
- How to construct
navigation for your dashboard application using VBA
Day-3
- How to communicate with databases (SQL Server, Access, ...)
using DAO and ADO in VBA
- How to command Microsoft
Word and PowerPoint for dashboard report purposes
- Discussion on how to use VB
.Net and VB 6.0 to enhance your dashboards including examples.
Workshop Materials
- The
workshop manual contains helpful Microsoft Excel VBA programming topics and code in a user-friendly format.
-
The manual illustrates Microsoft Excel VBA topics using state of the art screen
shots and 3-D graphics.
- Each
workshop participant
receives a comprehensive CD-ROM that contains the workshop examples and
reading materials.
Who Should Attend
- Microsoft Excel VBA
users with a basic knowledge of Microsoft Excel and the VBA language.
- 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
Webcast Workshops |
 |
|
Microsoft Excel
Dashboards is being offered over the web via live
webcast (Details,
Signup). Our web cast workshops are:
-
Hands-on
-
Voice interactive
-
We use
GoToMeeting,
SKYPE and
conference calling for customer integration. We
can reach anywhere in the world that has an
internet connection.
-
Our class sizes are
limited to 10 attendees so you can discuss your particular
problems.
We also
provide on-site training using our web cast system. To
learn more about our webcast workshops
click here
or call us at 805.498.7162. |
|
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. |
|
|
