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

08:30 am - 02/13/2018

@ Kinetic Technology Solutions

15495 SW Sequoia Parkway Suite 100
Portland OR  97224



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 the more advanced features of Microsoft Excel. For example, you will learn how to apply and use range names. You will learn how to use the VLOOKUP function to retrieve data from a list, and what to do if your formula returns an error. You will learn how to use auditing tools to track formulas, store scenarios for comparing options, and use problem solving tools such as the FV (Future Value) function and Goal Seek. You will learn how to create a simple form using Excel’s set of form controls. Also, you will learn how to record macros for automating repetitive tasks and procedures. You will learn how to link and consolidate multiple workbooks. You will learn how to turn a list into a Table to work with the list more easily. You will also learn to use Advanced Filters to find data in a list or copy it to another location. You will also learn how to create Pivot Tables to efficiently summarize and rearrange data. And finally, you will learn about the Excel Data Model, a feature that allows you to compile data from multiple data sources into Excel to perform powerful data analysis. You will learn how to add data to the Data Model, and then create PivotTables to summarize the collection of data. Course Preparation: Excel Level 2 or equivalent experience.

Feedback from our Clients

an employee from City of Portland wrote:
As an analyst I am often sifting through data, now I can be more efficient in how I analyze and present the information to others.


an employee from NW Natural wrote:
I'm so glad I learned how to combine multiple data sources into a single Excel Data Model to analyze the data using a Pivot Table.


an employee from Intel wrote:
I can't begin to quantify how much time this class will save me in my job, that's how great it was. PivotTables will change my life!

an employee from Nike wrote:
I am going to implement many of the methods I learned in this class such as Tables, PivotTables, and Advanced Filters, into my everyday tasks. I had only a very basic understanding of those topics before this class.



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

Show Map Tickets

Categories: Event

Report a Problem

Portland Tweets

Portland Jobs
Portland Jobs
Tualatin, #OR - Events Unlimited - Delivery Driver - Warehouse - Events Unlimited provides a wide variety of event… https://t.co/KmZS3AS1Cf

pdxreggae
pdxreggae
RT @theygavemeashow: Episode 28 of They Gave Me a Show? is available on demand now for those who missed! #radio #kpsu #pdx #portland #port…

MINHion
MINHion
I can go anywhere in the world but there can only be one home... #Portland

Chico's Careers
Chico's Careers
We're #hiring! Read about our latest #job opening here: Sales Lead - https://t.co/nY7RSIIUjU #Sales #Portland, OR

Portland Jobs
Portland Jobs
#Portland #OR #USA - Sales Account Manager - Paycom is looking for Sales Account Managers to join our team Love to… https://t.co/LPguXK1onJ

B.D. Philips
B.D. Philips
‘Out Of Time’ by B.D. Philips #np https://t.co/Orh5jO7CQp #pdx #music #originalsong #reverbnation #soundcloud… https://t.co/fZzecBuKch

Pocho's Chingaderas
Pocho's Chingaderas
Last Wednesday #DrumandBass #Photography adventure #OneWub Featuring @LarryCalyx & @DjTeeBee #PDXDNB… https://t.co/fxUhdgAlMU

Portland Tech Events
Portland Tech Events
The #Portland ReasonML meetup is hosting #Portland ReasonML Monthly Meeting tomorrow. Sign up here: https://t.co/gIErbQa3nI

Canopy Portland
Canopy Portland
Looking forward to the summer for so many reasons in #Portland - here's one! #craftbeer #travel. https://t.co/IiFE8DXFvv

CascadiaJobs
CascadiaJobs
This #job might be a great fit for you: Nursing Services Program Supervisor - https://t.co/yerI7T8s36 #mentalhealth… https://t.co/ALoTIepEOI