$595

Microsoft Excel 2016/2013 Level 4 Training in Portland, Oregon

Event Information

Share this event

Date and Time

Location

Location

Kinetic Technology Solutions

15495 SW Sequoia Parkway

Suite 100

Portland, OR 97224

View Map

Friends Who Are Going
Event description

Description

This 2-day hands-on, instructor-led course will be held in our brand new, expanded, computer training facility in Portland, Oregon.

In this course, you will learn how to use the Visual Basic for Applications (VBA) programming language in Excel. Specifically, you will learn about objects, events, properties, and methods. You will also write sub procedures and functions to perform custom processes. Additionally, you will learn how to write IF statements and Select Case statements which enable your code to make decisions. You will use For Next and Do loops to perform a process multiple times. You will also learn how to declare and use variables to store information that changes every time your code runs. Additionally, you will learn how to write error-handling code so your processes end gracefully if there is a problem. This is a programming class for the experienced Excel user who is not a programmer.

Course Preparation: Excel Level 2 or equivalent experience. You should come to this class with a working knowledge of creating basic worksheets, entering and editing data in cells, formatting text and numbers, copying and moving data, inserting and deleting columns and rows, creating formulas, applying formulas, using functions, and using absolute and relative cell references in formulas.

Feedback from our Clients

an employee from US Forest Service wrote:
The pace of the class was excellent and the instructor is well versed in the subject matter. I'm looking forward to building new report functionality.

an employee from Clackamas County wrote:
I work in many Excel spreadsheets where, because of my unfamiliarity with VBA, I was only able to utilize Excel functions which can be long and cumbersome for some of the more complicated functions. This class was VERY helpful. Thank you!

an employee from Portland General Electric wrote:
This class was very helpful. I plan to review the existing VBA code in spreadsheets that others created to get a better understanding of the current code and also add code to improve efficiency.

FAQs

What are my transportation/parking options for getting to and from the event?

Kinetic is located just off I-5's Carman Drive exit in SW Portland, a 10 minute drive from downtown. FREE parking. Go to kinetictraining.com/customer_resources/locations.asp for driving instructions and a map of the area.

What can I bring into the event?

You do not need to bring anything. Computers are provided in the classroom as well as participant course manuals.

When should I arrvive, what can I expect the day of class, are there refreshments?

Please arrive approximately 15 minutes prior to class to check in and get situated in your classroom. Starbucks coffee, tea, juice and sodas will be available throughout the day. Snacks will be provided before class and at breaks. Restaurant maps are available to help you plan your lunch break. If you prefer to bring your lunch, a refrigerator is available as well as a place to eat and relax. Dress is casual and comfortable to allow for the optimum learning environment. Please bring a jacket or sweater as room temperatures may vary.

How can I contact the organizer with any questions?

Please call 503.520.0555 or email Register@KineticTraining.com with any questions. Additional information about our course offerings is also available on our website, KineticTraining.com

Share with friends

Date and Time

Location

Kinetic Technology Solutions

15495 SW Sequoia Parkway

Suite 100

Portland, OR 97224

View Map

Save This Event

Event Saved