Our 3-day hands-on live advanced Excel VBA training for scientists
and engineers shows you from an engineering
and science perspective how to build powerful data analysis,
data integration, dashboard and modeling tools using Excel VBA. Our VBA training
starts off with a complete review of how to use objects in VBA and how to
create them using Class modules. Next it discusses advanced command and control of ranges, cells,
worksheets and workbooks using Excel VBA and how these methods can
be used to build sophisticated data analysis, modeling and dashboard tools.
Using VBA to automate pivot tables and queries is also covered. Our training
then explores how to control the file and folder system
of Windows and loop through folders looking for various files. Also covered are
advanced data processing methods for reading technical data this is
arranged in non-standard, adjustable, or stacked formats on the
worksheet. Scanning for hard to find information such as
non-standard, double rowed data headers is also covered. In addition to
scanning worksheet data, our VBA training also covers how to read and write to
databases and text files integrating their data with information
stored on worksheets. Advanced table lookups between worksheets is
also covered. After discussing data control, our VBA training provides an in depth
review of how to use and control ActiveX controls on userforms and
worksheets using VBA and events. It then shows
how to put it all together and design, build and program advanced dashboards on worksheets,
charts and userforms with a full review of using events that apply
to those elements. Last, how to control other programs like
PowerPoint, Word and interface with other languages like VB.Net,
FORTRAN and C is covered. Taught by an engineer.
Our Advanced Excel VBA training public
event location is
Thousand Oaks, CA. Our classes
start at 8:30 AM PT and run to 4:30 PM PT. Thousand Oaks is in the vicinity of Simi Valley, CA;
Oxnard, CA; Ventura, CA; Santa Barbara, CA; Carpentaria, CA;
Calabasas, CA; Agoura Hills, CA; Studio City, CA; Sherman Oaks, CA;
Encino, CA; Woodland Hills, CA; Westwood, CA, Santa Paula, CA;
Valencia, CA; Santa Monica, CA and Los Angeles, CA. Thousand Oaks is
in Ventura county, other CA counties within commute are Santa Barbara
county, Los Angeles county and Orange county. Anything farther, it is recommended you stay the night before.
Along with our public events, our Advanced Excel
VBA training is also held live online and broadcast all over the US, Canada, Mexico and the Caribbean.
We can also broadcast to your company over the web as an onsite. We
can also travel to your company for an onsite, our onsites are
conducted all over the US, Canada and Europe.
