Region: Portland Metro

“The Intangibles: Just because you can’t touch it doesn’t mean it won’t bite you in the ass.”

A team of intellectual property attorneys from Miller Nash Graham & Dunn will present a 3.5 hour workshop for cannabis-industry entrepreneurs. Alicia Bell, Carla Quisenberry, and Brian Sniffen are particularly passionate about helping entrepreneurs identify, monetize, and protect their intellectual property rights. Alicia and Carla handle all aspects of IP law, including trademark, copyright, patents, and trade secrets while Brian’s practice focuses on data privacy and protection.

HAVE SOME EXPERIENCE WITH EXCEL AND WANT TO IMPROVE YOUR SKILLS?
Practical, Hands-on Training for Advanced Excel Formulas & Functions

Do you have an intermediate understanding of Excel but are keen to break through to real mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user? Take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more.

WHY EXCEL MATTERS
We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit. 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.”

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

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 professionals 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.

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
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!

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 ibeafoundation@gmail.com.

SOLD OUT?
This is one of our high demand classes. In the case, we sale out; email us at ibeafoundation@gmail.com and ask when our next course will be in.

Consistent content is crucial in order to gain followers and subscribers. Jen Price from Much will show you how to plan out your weekly content for the rest of the year, with social media and blog posts that your audience can’t wait to see and read. Save time and stop wondering what the heck to post! Materials with templates and examples included.

Learn the 5 different types of persuasive content you need.
Write compelling hooks that keep them engaged and eager to read more.
Determine your brand’s main 6-9 topics, so you never worry about what to write in a post ever again.
Get sooo fast at writing each post, you could do them in under 15 minutes each. We’ll write the first 4 together during the workshop!

Tickets
RSVP Required
$397 Guests / $197 Members
Includes Bootcamp Private Training Session

—
Jennifer Price is a Creative Strategist and Pregame Coach who helps visionary businesses and entrepreneurs sell more online by profiling their Ideal Client using the StoryJuice Formula. Through workshops at Pregame, and her consulting and writing business Much, Jen guides your marketing strategy and messaging to inspire your customers to feel something and take action. More at yousomuch.com

Our financial systems are setup to fail us by focusing on the wrong key performance indicators. They focus our efforts on short-term profits, as opposed to serving us in providing the best possible service or product to our end-customers.

In the 1950’s a system known at the time as the “respect for humanity” system, and decades laters as “lean” changed the way companies look at their financials. In lean people are no longer seen as an expense to be cut to serve short-term profits. Instead, lean sees our investments in hiring, training and retaining people, as well as the continuous improvement work they do, as the single most important long-term asset any organization has. Lean whole systems thinking changes our economic intent from one focused on the bottom line profits to one focused on a more efficient use of cash and time, driven by people, for people, with a goal of providing more value-add for the end-customer. A side-benefit to looking at financials through the lens of lean is that our efforts also have a positive environmental impact.

This workshop provides an overview of how we can change the way we look at our profit and loss statement (aka income statement) and balance sheet to one more aligned with our values, our people, our planet, and our long-term profits. We do so by delving into the past and exploring the future. We look at the history of our financial systems in order to understand how we got to the current state. Along the way we learn a little double enty bookkeeping through collaborative exercises. Then we work together to find solutions for a more holistic future model.

What do others think of this workshop?

“Loved the history of finances and how to think of people and knowledge as assets”

“Innovative thinking around our financial system”

“Love that the focus is on the balance sheet”

“Great breakdown of the financial systems we use on a daily basis”

KJELL VAN ZOEN

SEM Coach & Operations Coach
Energy 350, Portland, Oregon
www.vanzoen.com | https://www.linkedin.com/in/kvanzoen/

Kjell is an operations super-nerd. He currently works as a Strategic Energy Management (SEM) & Operations Coach at Energy 350, helping Industrial clients in the Pacific Northwest realize energy efficiency and reductions using continuous improvement practices. He’s also a lean operations educator and super-nerd with over 20 years of entrepreneurial & consulting experience in the United States and Western Europe, Kjell has worked with businesses in the manufacturing, IT, hospitality, municipal and non-profit sectors. He has developed and delivered over 100 workshops & events focused on continuous improvement & whole systems thinking. He is the educational and events lead for Lean Portland, a professional non-profit organization focused on supporting continuous improvement and whole systems organizational thinking in the Portland area. When Kjell is not coaching and nerding out on operations he’s a science-fiction fan, biker, hiker, swimmer, yoga practitioner, and drives his wife crazy by taking the doors off of the kitchen cabinets for optimum efficiency.

SEMpdx is hosting our annual Holiday Party!

Join SEMpdx and our local partners pdxMindShare, Mac’s List, IABC, OEN, and AMA after work on Thursday, December 13, 2018 to celebrate the holiday season by eating, drinking, and partaking in good conversation. Light appetizers will be provided, and there will be a no-host bar.

This workshop series includes instruction, discussion, resource referrals and templates that will help you develop, communicate, and execute your existing business or new business idea.

Five week series (once a week). Open to the community.

Sessions include:

Intro to the PSU Business Outreach Program and the roles of an entrepreneur
Understanding your target market, market research and advertising
Building a new or revised business plan
Budgeting, recordkeeping and financing your business
Legal issues, entity selection, employment overview and local resource referrals
To register:

Step 1: Complete our Inquiry Questionnaire
Step 2: Submit payment of $175 (Non Refundable)

Note: If your income does not support the full fee, please complete Step 1, then contact us.

Questions: Contact us at psubop@pdx.edu or (503) 725-9820

A HOLISTIC HEALTH BRUNCH FOR SMALL BUSINESS OWNERS AND MANAGERS

Start the new year by taking care of your health and managing your stress. Do you spend too much time taking care of your clients, your family, and your friends, but not taking care of yourself? Does this leave you feeling burned out and depleted? Join us and learn new tools to make your life and business run more smoothly. We will look at your health holistically and check in to see what areas you need the most support in.

Network with other small business owners and managers

Yummy healthy brunch

Goal setting & time management

Breathing techniques

Looking at your health holistically

Getting business processes in order

Minimizing conflict-conflict resolution/creative problem solving*

Taking care of legal formalities for better piece of mind

Prioritize your health and self-care to continue to thrive in your business for years to come.

PRESENTED/SPONSORED BY:

Kerry Mann Wellness www.kerrymannwellness.com

Rational Unicorn Legal Services www.rationalunicornlegalservices.com

This workshop series includes instruction, discussion, resource referrals and templates that will help you develop, communicate, and execute your existing business or new business idea.

Five week series (once a week). Open to the community.

Sessions include:

Intro to the PSU Business Outreach Program and the roles of an entrepreneur
Understanding your target market, market research and advertising
Building a new or revised business plan
Budgeting, recordkeeping and financing your business
Legal issues, entity selection, employment overview and local resource referrals
To register:

Step 1: Complete our Inquiry Questionnaire
Step 2: Submit payment of $175 (Non Refundable)

Note: If your income does not support the full fee, please complete Step 1, then contact us.

Questions: Contact us at psubop@pdx.edu or (503) 725-9820

This workshop series includes instruction, discussion, resource referrals and templates that will help you develop, communicate, and execute your existing business or new business idea.

Five week series (once a week). Open to the community.

Sessions include:

Intro to the PSU Business Outreach Program and the roles of an entrepreneur
Understanding your target market, market research and advertising
Building a new or revised business plan
Budgeting, recordkeeping and financing your business
Legal issues, entity selection, employment overview and local resource referrals
To register:

Step 1: Complete our Inquiry Questionnaire
Step 2: Submit payment of $175 (Non Refundable)

Note: If your income does not support the full fee, please complete Step 1, then contact us.

Questions: Contact us at psubop@pdx.edu or (503) 725-9820

This workshop series includes instruction, discussion, resource referrals and templates that will help you develop, communicate, and execute your existing business or new business idea.

Five week series (once a week). Open to the community.

Sessions include:

Intro to the PSU Business Outreach Program and the roles of an entrepreneur
Understanding your target market, market research and advertising
Building a new or revised business plan
Budgeting, recordkeeping and financing your business
Legal issues, entity selection, employment overview and local resource referrals
To register:

Step 1: Complete our Inquiry Questionnaire
Step 2: Submit payment of $175 (Non Refundable)

Note: If your income does not support the full fee, please complete Step 1, then contact us.

Questions: Contact us at psubop@pdx.edu or (503) 725-9820

This workshop series includes instruction, discussion, resource referrals and templates that will help you develop, communicate, and execute your existing business or new business idea.

Five week series (once a week). Open to the community.

Sessions include:

Intro to the PSU Business Outreach Program and the roles of an entrepreneur
Understanding your target market, market research and advertising
Building a new or revised business plan
Budgeting, recordkeeping and financing your business
Legal issues, entity selection, employment overview and local resource referrals
To register:

Step 1: Complete our Inquiry Questionnaire
Step 2: Submit payment of $175 (Non Refundable)

Note: If your income does not support the full fee, please complete Step 1, then contact us.

Questions: Contact us at psubop@pdx.edu or (503) 725-9820

Now in its eighth year, the Symposium is heralded as one of the best values for wine education with more than 25 sessions over two days, including a number of comprehensive Oregon producer wine trial tastings. As in years past, the two-day show will be divided into four distinct “tracks” to best target participants’ fields of interest: Viticulture, Enology, Executive Business and DTC Business. As well as full access to seminars, lectures and panel discussions, the all-access pass also offers networking and meeting opportunities with vendors, a festive happy hour called the Oregon Wine Soirée featuring Oregon wine pours, appetizers and desserts, and wines from across the state.

For a limited time, ticket prices are reduced 30% with the Early Bird discount offered until Jan. 15, 2019. After the show, attendees can gain early access to PowerPoint presentations and recordings of sessions; last year’s recorded sessions are now publicly available.

As well as perennial favorites such as the Oregon Wine Soirée, the Climatology Report by Dr. Greg Jones, and the Oregon Wine Industry Awards, the 2019 show features a keynote address by Sandra Taylor, international expert on environmental, social and agricultural supply chain sustainability and author of The Business of Sustainable Wine. Taylor will speak on global trends and local opportunities in brand equity building and sustainability in the wine industry. After opening ceremonies, the breakout seminars begin featuring key sessions:

Viticulture

Day one will feature OSU researchers discussing several pressing vineyard topics, such as the latest findings around Red Blotch and new clean plant certifications with The Road to Clean Nursery Stock and Solutions for Red Blotch. Vineyard managers will learn about Farming for Quality: Alternative Farming Techniques for Dry Farmed Vineyards in a Changing Climate. Spanish interpretation across the viticulture seminars beginning with Understanding the Microbiome.

Enology

The enology track will open with a seminar and tasting dedicated to Exploring and Understanding Wildfire Impacts on Winemaking and Wine. Oxygen management will also be discussed later on the first day.

On the second day, the morning’s enology track will be comprised of a panel discussion on effective selling with winemakers in the trade in a seminar entitled Three Tiers for Fears; Get out of the Cellar and be a Seller. The day finishes with a tasting at the Managing Microbes from Crush to Bottle session.

Executive and DTC Wine Business

Multiple sessions will be geared toward executive and DTC management as well as tasting room staff on driving quality visitation, implementing best practices in hospitality, and measuring results with the Outlook on the Wine Sector: Managing the Changing Generational Demographic and Market Dynamics, with panelists Metis CEO Erik McLaughlin, Dr. Damien Wilson, and Tony Correia. Executive business tracks on the second day will explore The Bottom Line: How Understanding COGS Can Increase Your Profitability: A Case Study.

In the DTC business track, Best Practices for DTC Management will be discussed, along with Metrics that Matter; How to Leverage 2018 Data to Drive 2019 Success. Decisions surrounding salary and HR best practices will be explored along with understanding all the decision points that contribute to profitability across the vineyard, cellar and sales channels.

This workshop series includes instruction, discussion, resource referrals and templates that will help you develop, communicate, and execute your existing business or new business idea.

Five week series (once a week). Open to the community.

Sessions include:

Intro to the PSU Business Outreach Program and the roles of an entrepreneur
Understanding your target market, market research and advertising
Building a new or revised business plan
Budgeting, recordkeeping and financing your business
Legal issues, entity selection, employment overview and local resource referrals
To register:

Step 1: Complete our Inquiry Questionnaire
Step 2: Submit payment of $175 (Non Refundable)

Note: If your income does not support the full fee, please complete Step 1, then contact us.

Questions: Contact us at psubop@pdx.edu or (503) 725-9820

Middle School students in Beaverton, OR will present their business plans to a panel of mentors, teachers, board members and community investors. Students are part of a one year Entrepreneurship program that helps them create business and non-profit ideas. They spend 36 weeks writing business plans, seeking investors and executing sales at community events, retail outlets and online. INVESTOR SPOTS STILL OPEN: Six investor opportunities are available to “judge” students in a “Shark Tank” style event on February 28th, 2019. After reviewing their Business plans and hearing a 3 minute Elevator Pitch, the “Sharks” will determine how much investment each Young Entrepreneur receives. Investments can be as little as $250 and qualify as a tax deductible donation into our schools Global Education Initiative which provides learning tools for students in Korea, Haiti & The Philippines.