Viewing 1 current event matching “students” by Date.

Sort By: Date Event Name, Location , Default
Saturday
Nov 3
Practical, Hands-on Training for Advanced Excel Formulas & Functions
NedSpace

Want to take your career to the next level?

Practical, Hands-on Training for Advanced Excel Formulas & Functions

Microsoft Excel is perhaps the most important computer software program used in business today. That's why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace. Unfortunately many college students, recent grads, and professionals haven’t mastered Excel or have the adequate Excel skills employers are seeking. According to Payscale, “ 80 percent of job openings require spreadsheet and word-processing software skills. Yet so many people never even give Excel a chance because it has an intimidating stigma around it.”

If you walk through the finance or accounting department at any major corporate office, you will see computer screens filled with Excel spreadsheets outlining financial results, budgets, forecasts, and plans used to make big business decisions. Marketing and Product profesionals using Excel to list customer and sales targets; managing thier sales force and planning future marketing plans based on past results. Pivot tables to quickly and easily summarize customer and sales data by category with a quick drag-and drop. HR professionals using giant spreadsheets full of employee data and understand exactly where the costs are coming from and how to best plan and control them for the future. Supply logistic professional to manage inventory and forecasts demand.In essence, you can turn an entire department around just because you know how to manipulate data in order to get an aggregate view.

STRUCTURE OF COURSE

Advanced functions and formulas

 *Logical functions
 *Conditional functions
 *Financial functions
 *Text functions
 *Date functions
 *Array formulas

Lookups and data tables

 *Using lookup functions
 *Using MATCH and INDEX
 *Creating data tables

Advanced data management

 *Validating cell entries
 *Advanced filtering

Advanced charting

 *Chart formatting options
 *Combination charts
 *Graphical objects

PivotTables and PivotCharts

 *Working with PivotTables
 *Rearranging PivotTables
 *Formatting PivotTables
 *PivotCharts

Exporting and Importing Data

 *Exporting and importing text files
 *Getting external data

Analytical Tools

 *Goal Seek
 *Scenarios

Macros and Visual Basic

 *Running and recording a macro
 *Working with VBA code

ABOUT THE INSTRUCTOR

Martin Jetton has 30+ years of advanced supply chain analytics, predictive analytics, and statistical consulting experience. He's currently a Principal at the Liberty Advisor Group, where he works in advanced supply chain analytics. In his previous role, he was the Senior Predictive Consultant at Corios; where he developed predictive models and scorecards, forecast trends, identify uncertainties, and assign the ideal strategies to maximize performance. The firm’s clients are in the banking, brokerage, credit, utilities and healthcare industries.

BENEFITS

Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

MAKE YOUR RESUME STAND OUT

They are NOT seeing if you simply have Excel as a skill. They are diving deeping when it comes to determining which candidate to interview and hire. They look for Pivot Table, VLOOKUP, Macros, VBA, Conditional Formatting, Charting and Filtering…These are far more telling of your ability to an employer then writing Excel. Someone who writes VLOOKUP, Pivot Table, Filtering demonstrates an ability to analyse data and so has eliminated a potential barrier in the mind of the hiring manager reviewing your resume. In essence, use actual Excel functions in your Resume!

INCREASE YOUR EARNING POTENTIAL

Did you know that Excel know-how can instantly increase your job prospects as well as your starting salary? Excel is a transferrable skill that any hiring manager understands is critical. Research shows job applicants who know MS Excel make $22.66 per hour on average compared to the $20.14 per hour their peers make who don’t know the program. That’s roughly an extra $20 per eight-hour workday and $100 per work week, simply for knowing how to use a single computer program. Moreover, full-time employees in certain industries can see a starting salary bump of anywhere from $1,000 to $7,000 per year based on their Excel skills. That’s not chump change you can ignore.

INSPIRING ENTREPRENEUR?

A majority 63 percent of twenty-somethings want to start their own business. How will you stay organized, track data, or forecast your finances if you’re not spreadsheet-savvy? Many millennials simply want their first job. But, what about your performance once someone hires you? The biggest complaint employers have about millennials is that they lack basic hard and soft skills.These skills include things like teamwork and problem solving, but also basic administrative skills like MS Word and Powerpoint. Once you’re hired, you want to meet the basic requirements of your role without stressing.

WHO SHOULD COME?

People whose work is completed through MS Excel; Software Engineers, Finance Professionals, HR Professionals, Marketing Professionals, Project Managers, Technology Professionals.

ADDITIONAL BENEFITS?

FOR FURTHER INFORMATION: PLEASE CONTACT US AT [email protected].

SOLD OUT?

This is one of our high demand classes. In the case, we sale out; email us at [email protected] and ask when our next course will be in

Website

Viewing 11 past events matching “students” by Date.

Sort By: Date Event Name, Location , Default
Monday
Jun 22, 2009
Saturday Academy's Engineering: Electronics, Robotics & Programming for 9th-12th grade students
through Tualatin High School

Engineering: Electronics, Robotics & Programming

Experience some of the many exciting projects that engineers work on as you explore the fields of electrical, mechanical, and computer engineering.

You will design, code, and debug computer programs, create computer games, design and simulate basic digital and analog electrical circuits, build and program lego robots, and custom build a computer from the motherboard up. Learn to think through and solve problems using professional methods and communication tools, just as engineers do in the workplace.

Instructor: Stephanie Viaene

Stephanie Viaene, with a BS in mathematics and an MS in Interdisciplinary Mathematics from the University of Oregon, has taught mathematics and computer programming, web design, and tech support at the junior high and high school level. In 2007 she was awarded the Technology Teacher of the Year award from the Software Association of Oregon.

Instructor: Jill Hubbard

Jill Hubbard teaches pre-engineering classes at Tualatin High School. She has a masters in education and a bachelor's in computer engineering. Before teaching, she was an engineer at Intel Corporation.

Website
Saturday
Nov 3, 2012
CodeDay Portland
through Cloudability

An intense, 24-hour hackathon where students can team up to create innovative new apps and games. At the end of the 24 hour session, students will present what they built to a panel of judges.

CodeDay Portland welcomes student developers of any level. Whether you have been coding since you were in a diaper or you have nothing more than an interest in the field, CodeDay Portland is an event for you.

Schedule will be posted to the website as the event nears.

Buy tickets at Eventbrite:

http://codedayportland.eventbrite.com

Website
Saturday
May 18, 2013
Oregon Innovation Academy Launch and Unconference
Franklin High School

The Innovation Academy is bringing together students, teachers, and working professionals from the Northwest’s technology industries to empower students with new skills sets of the digital age.

Teams will work collaboratively to build software applications and other technology-­‐based solutions that solve real world problems that exist within our community. The solutions that will emerge from these teams will be known as "Innovation for the Common Good."

The region’s first "Innovation Academy will be launching at Franklin High School Saturday, May 18 from 2-­‐5pm. The launch will offer students the opportunity to form project teams that will meet over the summer to work on their projects with industry mentors. New solutions in areas such as education, the environment, energy and public safety will be explored.

Attendees at the launch event will preview a new community safety mobile app that is being developed by a team of Franklin and Wilson students working with industry experts and the Portland Police Bureau. Designed to improve communication and collaboration between district police officers and the neighborhoods that they serve, the new mobile app is an example of the kind of impact student-­‐based innovation can bring to Oregon.

All students, teachers and technology industry professionals are welcome to participate in the launch event. Once teams have been formed and projects are begun, their solutions will be demonstrated in a large community celebration when the school year resumes next fall.

Website
Thursday
Jul 31, 2014
JavaScript Immersion meet-and-greet!
Portland Code School

Meet Portland's FIRST EVER JavaScript Immersion graduates! Meet the students, the instructor, and the PCS staff. See the immersion students' projects and discover what they've been up to for the last 12 weeks. Here's a list of some of the things they've been doing and learning:

  • Nearly 500 hours of object-oriented programming in JavaScript
  • EmberJS on the front end
  • NodeJS on the backend
  • PostgreSQL for database
  • GitHub for version control
  • Problem Solving like a programmer
  • Test Driven Development

Pretty amazing! These students are extremely excited to share with the community what they've been up to. Check out the class website, and come in to discover Portland's FIRST EVER full-stack JavaScript Immersion program!

Website
Friday
Oct 17, 2014
CrowdSource Summit: A conference for emerging web professionals
through Red Lion Hotel on the River, Jantzen Beach

CrowdSource Summit, presented by the Higher Education Web Professionals Association, is a new conference for college and university students who want to explore the many possibilities that "working on the Web" encompasses.

We'll focus on the multidisciplinary nature of Web work, moving beyond the tools and the technology to look at the human side of creating online experiences. We'll look at the WHY.

Strong speakers

Session topics include accessibility, usability, user experience, mobile interfaces, content strategy and how the web is being used to conquer the digital divide.

Registration

Registration is only $50 and includes a t-shirt, a keynote, several really amazing sessions, and great networking opportunities. There are hotel rooms available to make attending the Saturday sessions easier!

Discounts available

Group discounts are available; email [email protected] for details.

Website
Thursday
Nov 12, 2015
Portland Campus: How to go from [Your Seemingly-Unrelated career] to Developer
Code Fellows

Wondering how to move from your current job into a tech career? Want to hear how your current skills translate into the tech world? Already a developer and need to learn a new stack or level up your skills?

Join us for a beer (or ginger ale!) to explore career paths in tech and how to get there. You'll hear from professional developers about how they found their way into their current roles. Bring all your questions about the tech industry and how you can change your career.

Website
Tuesday
May 30, 2017
Open Source Bridge Volunteer Meetup
Lucky Labrador Brew Pub

Open Source Bridge is in just a few weeks — June 20-23. Come find out about volunteering positions, including Session Monitor, Hacker Lounge volunteer, Logistics assistant, Party volunteer, and more! Working just 8 hours (spread over 4 days of conference and load-in day) gets you a free ticket.

Open source Bridge is the best regional open source tech conference around! A language-agnostic conference created by developers, designers, hardware hackers, and community leaders for the greater tech industry, OSBridge focuses on the intersection of activism, tech, and culture. Students and those looking for internships and work are always welcome — we have a job board on-site to connect you with companies looking to fill positions.

Website
Monday
Jun 19, 2017
Volunteer Orientation #1 for Open Source Bridge volunteers
The Eliot Center (Buchan Building)

If you volunteer for 8 hours, you'll get a free ticket to Open Source Bridge! Come to orientation to get details! And sign up for your shift hours at http://volunteer.opensourcebridge.org/welcome/.

OSBridge organizers will show you around the facility, go through roles and some conference best practices, and teach you how to respond to a Code of Conduct report.

Website
Volunteer Orientation #2 for Open Source Bridge volunteers
The Eliot Center (Buchan Building)

If you volunteer for 8 hours, you'll get a free ticket to Open Source Bridge! Come to orientation to get details! And sign up for your shift hours at http://volunteer.opensourcebridge.org/welcome/.

OSBridge organizers will show you around the facility, go through roles and some conference best practices, and teach you how to respond to a Code of Conduct report.

Website
Thursday
Sep 14, 2017
BEST FEST, The Pacific NW's Premier Cleantech Innovation Conference
World Trade Center

Innovations on the frontiers of science and technology can help address the environmental challenges we face. The 2017 BEST FEST will explore how cutting edge innovations in Advanced Manufacturing, Energy, Water, Natural Resources, IoT, Agriculture and Food can make a positive impact on the planet while also growing the Oregon economy. Experts from across industries in Oregon and outside the state along with entrepreneurs and university researchers will expose exciting innovations in an informative and fascinating program.

Now in its ninth year, BEST FEST brings together the doers, thinkers, and innovators working in clean technology across the region. Our signature event – known as the Pacific Northwest’s premier cleantech innovation conference – is about learning, inspiring, networking, sharing ideas, and shaping a better, more sustainable future. BEST FEST convenes a diverse audience of entrepreneurs, investors, partners, corporates, university researchers, students, and scientists – all of whom share the common goal of accelerating solutions to environmental challenges and want to create opportunities to engage.

Early bird tickets on sale now at: https://tinyurl.com/y7mc2a28

Website
Saturday
Sep 15
MS EXCEL - ADVANCED EXCEL FORMULAS & FUNCTIONS
NedSpace

Want to take your career to the next level?

Practical, Hands-on Training for Advanced Excel Formulas & Functions

Microsoft Excel is perhaps the most important computer software program used in business today. That's why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace. Unfortunately many college students, recent grads, and professionals haven’t mastered Excel or have the adequate Excel skills employers are seeking. According to Payscale, “ 80 percent of job openings require spreadsheet and word-processing software skills. Yet so many people never even give Excel a chance because it has an intimidating stigma around it.”

If you walk through the finance or accounting department at any major corporate office, you will see computer screens filled with Excel spreadsheets outlining financial results, budgets, forecasts, and plans used to make big business decisions. Marketing and Product profesionals using Excel to list customer and sales targets; managing thier sales force and planning future marketing plans based on past results. Pivot tables to quickly and easily summarize customer and sales data by category with a quick drag-and drop. HR professionals using giant spreadsheets full of employee data and understand exactly where the costs are coming from and how to best plan and control them for the future. Supply logistic professional to manage inventory and forecasts demand.

In essence, you can turn an entire department around just because you know how to manipulate data in order to get an aggregate view.

STRUCTURE OF COURSE

Advanced functions and formulas

 * Logical functions
 * Conditional functions
 * Financial functions
 * Text functions
 * Date functions
 * Array formulas

Lookups and data tables

 * Using lookup functions
 * Using MATCH and INDEX
 * Creating data tables

Advanced data management

 * Validating cell entries
 * Advanced filtering

Advanced charting

 * Chart formatting options
 * Combination charts
 * Graphical objects

PivotTables and PivotCharts

 * Working with PivotTables
 * Rearranging PivotTables
 * Formatting PivotTables
 * PivotCharts

Exporting and Importing Data

 * Exporting and importing text files
 * Getting external data

Analytical Tools

 * Goal Seek
 * Scenarios

Macros and Visual Basic

 * Running and recording a macro
 * Working with VBA code

BENEFITS

Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.

MAKE YOUR RESUME STAND OUT

They are NOT seeing if you simply have Excel as a skill. They are diving deeping when it comes to determining which candidate to interview and hire. They look for Pivot Table, VLOOKUP, Macros, VBA, Conditional Formatting, Charting and Filtering…These are far more telling of your ability to an employer then writing Excel. Someone who writes VLOOKUP, Pivot Table, Filtering demonstrates an ability to analyse data and so has eliminated a potential barrier in the mind of the hiring manager reviewing your resume. In essence, use actual Excel functions in your Resume!

INCREASE YOUR EARNING POTENTIAL

Did you know that Excel know-how can instantly increase your job prospects as well as your starting salary? Excel is a transferrable skill that any hiring manager understands is critical. Research shows job applicants who know MS Excel make $22.66 per hour on average compared to the $20.14 per hour their peers make who don’t know the program. That’s roughly an extra $20 per eight-hour workday and $100 per work week, simply for knowing how to use a single computer program. Moreover, full-time employees in certain industries can see a starting salary bump of anywhere from $1,000 to $7,000 per year based on their Excel skills. That’s not chump change you can ignore.

INSPIRING ENTREPRENEUR?

A majority 63 percent of twenty-somethings want to start their own business. How will you stay organized, track data, or forecast your finances if you’re not spreadsheet-savvy? Many millennials simply want their first job. But, what about your performance once someone hires you? The biggest complaint employers have about millennials is that they lack basic hard and soft skills.These skills include things like teamwork and problem solving, but also basic administrative skills like MS Word and Powerpoint. Once you’re hired, you want to meet the basic requirements of your role without stressing.

ABOUT THE INSTRUCTOR

Martin Jetton has 30+ years of advanced supply chain analytics, predictive analytics, and statistical consulting experience. He's currently a Principal at the Liberty Advisor Group, where he works in advanced supply chain analytics. In his previous role, he was the Senior Predictive Consultant at Corios; where he developed predictive models and scorecards, forecast trends, identify uncertainties, and assign the ideal strategies to maximize performance. The firm’s clients are in the banking, brokerage, credit, utilities and healthcare industries.

WHO SHOULD COME?

People whose work is completed through MS Excel; Software Engineers, Finance Professionals, HR Professionals, Marketing Professionals, Project Managers, Technology Professionals.

ADDITIONAL BENEFITS?

FOR FURTHER INFORMATION: PLEASE CONTACT US AT [email protected].

Website