Workshop Details
Type: Business
Professionals
Platform: Windows
Versions: 97-2007
Workshop Manual:
Price and Buy
Public Training*:
Dates and Signup
Hotel: Thousand Oaks
Inn
Onsite Training:
Details
Web Cast Information
(New): Details,
Signup
*Our beginning VBA public
and web cast workshops deal primarily with data processing issues.
Workshop and Manual Overview
This 2-day "hands-on"
workshop focuses
entirely on automating data analysis in Microsoft Excel using Excel VBA. Topics discussed include:
- Microsoft Excel
data analysis tool review (autofilter, advanced filter, sort, Microsoft
Query, pivot tables)
- Review of Microsoft Excel
data analysis worksheet functions
- Review of key VBA
language elements concentrating on data analysis
- Review of key
Microsoft Excel objects used in
data analysis in Excel
- How to program key
Excel data analysis tools in VBA
- How to use key
Excel data analysis worksheet functions in VBA
- How to automate
report construction in Microsoft Word and PowerPoint
- How to access the
Windows file system to open multiple files at once
- How to process
data on multiple worksheets and create summary sheets
- VBA data analysis
programming techniques for data
sorting, parsing and labeling
- VBA data analysis
programming techniques for analyzing data by daily, weekly, monthly,
quarterly and yearly groupings
- VBA programming
techniques for opening and scanning text files
- How to use
VBA to automate construction of Excel charts
- How to use Microsoft
Query and VBA DAO to query a business database
- How to automate
a Microsoft Query connection and pivot table refresh
The Benefits
of Using Microsoft Excel VBA
Data Analysis for Business
Visual Basic for Applications (VBA)
can be used in conjunction with Microsoft Excel to automate data
analysis tasks. In particular, VBA can be used to lock in on and parse
business data then automatically engage Excel's data processing tools
to perform the analysis tasks you want. When the analysis is completed,
VBA can then be used to automatically create reports on Excel worksheets
or in other applications such as Word and PowerPoint. VBA can also be used to create your own
custom data analysis tools.
Workshop
Topics
Day-1
- Review of Microsoft Excel data analysis tools
- Review of Microsoft Excel data analysis worksheet functions
- How to automate Microsoft
Excel data analysis tools using VBA
- How to use Microsoft Excel
data
analysis worksheet functions in VBA
- How to automate Excel chart
construction using VBA
- How to process data on
multiple worksheets and create summary sheets
- How to access the Windows
file system to open multiple Excel files at once
Day-2
- VBA data analysis programming techniques
for parsing, labeling, extracting and sorting business data on the
worksheet
- VBA data analysis
programming techniques for automating report generation in Word and
PowerPoint
- How automate queries and
database access using ADO and DAO
Workshop Materials
- The
workshop manual contains helpful Excel VBA programming topics and code in a user-friendly format.
- The
workshop manual illustrates 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
- Business
professionals with beginning Excel VBA experience and a solid
understanding of how Microsoft Excel works.
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
Microsoft Excel VBA courses nation wide.
Our public workshops are a short commute for those living in the 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. |
|
|
