Industry: Technology

Please mark your calendars for the culmination of OSU150, the celebration of Oregon State University’s 150th anniversary. An exciting symposium focused on the future will take place on October 23: “The Promise and the Peril of Artificial Intelligence and Robotics.”

Oregon State University will host this daylong symposium. OSU faculty and national experts will participate in this symposium and discuss the potential benefits, risks, ethics and uncertainties of the emerging technologies of artificial intelligence and robotics. These experts will contribute their insights into the potential for AI and robotics to transform agriculture, health care, natural resource management, transportation, arts and entertainment as well as consider possible impacts on jobs, the economy, our laws and privacy. The symposium is free and welcomes all members of the OSU community—students, faculty and staff—as well as the public. The day will engage academia, industry, policy makers and others. The symposium will take place in The LaSells Stewart Center and the CH2M HILL Alumni Center.

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.

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.

FOR FURTHER INFORMATION: PLEASE CONTACT US AT ibeafoundation@gmail.com.