Excel

at school(s) in San Francisco or delivered online/live/on-site/by e-learning

Advanced Excel Automation Using VBA
Course Format: Classroom
School/Trainer: UC Berkeley Extension [All Courses]
Training Center(s)/Venue(s): Berkeley, San Francisco, Redwood City, Oakland, California, United States
Jobs & Resumes: Berkeley, San Francisco, Redwood City, Oakland
Houses & Roommates: Berkeley, San Francisco, Redwood City, Oakland

Learn the essentials of working in the VBA coding environment. You study major VBA program control structures, function and sub creation, object events, how to build forms and use controls on forms and worksheets, debugging, and the coding of error handling routines. You also learn how to build interfaces to relational databases such as Oracle or MySQL using ADO technology. Additional topics yo......

Course description>>
 

Getting Started Recording and running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Working with Procedures and Functions Understanding and Creating Modules Understanding Procedures Creating a Sub Procedures Calling Procedures Using the Immediate Window to Call Procedures Creating a Function Procedure ......

Course description>>
 

Getting Started Spreadsheets are an invaluable tool used to organize, manipulate and present data. Microsoft Excel 2007 provides the user with a wide variety of tools for creating and displaying spreadsheets in their traditional and more eye-catching graphical forms. First, we discuss: components of a spreadsheet and the particular terminology used to discuss them the components of the......

Course description>>
 

Using Multiple Worksheets and Workbooks Excel 2007 allows you to reference data from other worksheets, and even incorporate data from multiple Excel files into a single formula. In this part of the course you will learn: how to open and switch between multiple workbooks how to copy worksheets from one workbook to another how to insert 3D formulas to reference data in multiple workshe......

Course description>>
 

Though you are comfortable with a wide array of formulas in Excel 2007, you may find yourself having to write cumbersome or time consuming strings of functions to perform fundamental computations. There are a number of formulas available that can perform repeat, conditional or financial calculations with a much more simplified syntax and which can greatly streamline your process improving your ......

Course description>>
 

Excel is an excellent tool for data management and analysis. Training course attendees learn the core features and functionality in MS Excel. Students explore the standard display screen and gain hands-on instruction in toolbar, menu and task pane use. They also learn how to personalize their toolbar, simplifying access to frequently used commands. Students learn how to open an existing workboo......

Course description>>
 

Pages:- 1 2 3 4 5 6 7 8 9 10 11 ...
[ Workshops ] [ Online Courses ] [ Corporate Training ] [ Topics ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>