Minneapolis Public Schools

No other neighborhood in Minneapolis has impacted our city’s music and theater life, diverse demographics, higher education opportunities, and unique skyline as has the Cedar Riverside neighborhood. As we walk through the blocks centered on Cedar and Riverside Avenues, we’ll learn about the liquor patrol zone, immigrant homes, West Bank bars, the food co-op movement, Dania Hall, protests and rent strikes, mosques, markets, a settlement house and those colorful high rise buildings next to 35W. Bring your own stories to share with tour leader Maureen Trepp, lifetime Mpls. resident, historian and frequent Cedar Riverside visitor. Meet at the outdoor entry to the Humphrey Institute on 19th Ave. So. and 3rd St. E. at 10:00 a.m.. The tour lasts 1 ½ hours and is about a mile in length. There are 2 Blue line and 1 Green line light rail stops in the neighborhood and a parking ramp on 19th Ave. along with street parking. If tour is full, please enroll for the waitlist. We will contact you if a space becomes available.

Successful professionals in the workplace use financial information to aid effective decision making. The Certificate in Accounting and Finance for Non-Financial Managers explains financial concepts and accounting processes utilized in most businesses. It provides practical techniques that increase your effectiveness and career. Get a foundation to understand the seven steps in the accounting cycle, and use financial information in decision making. Analyze resource allocation, evaluate financial performance, and maximize cash flow. Learn how to assess and analyze business reports to make smart decisions about budgeting, setting goals, and assessing performance within your area of influence. Courses: Accounting and Finance for Non-Financial Managers Cash is King Financial Analysis and Planning for Non-Financial Managers Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Accounting & Finance for Non-Financial Managers Unit 1: Introduction to finance The Vocabulary of Finance The Four Basic Elements of Finance The Basic Financial Statements Unit 2: Introduction to accounting Basic Terminology The Purpose of Accounting The Accounting Cycle Preparing Financial Statements Unit 3: Managing liabilities Overview of Liabilities The Liabilities of a Business Short-Term Liabilities Long-Term Liabilities Unit 4: Financial planning Overview of Financial Planning The Importance of Financial Planning The Business Planning Process Cash is King Unit 1: Cash flow strategies Why cash is so important in business What are the cash-critical stages in business What internal sources of cash are possible What potential external sources of cash there are Unit 2: Reporting and evaluating cash flow Review of the Cash Flow Statement Review of Projected Cash Flow Report What the Cash Cycle communicates What improvements can be made to shorten the cash cycle Calculating cash cycle Unit 3: Projecting cash needs How much cash the business needs When cash injections are needed Which cash needs will internal sources be able to cover Which cash needs must be met through external sources Making comparisons with other businesses in the same industry Unit 4: Funding requests What debt sources of cash are possible What are the potential equity sources of cash What requirements different funding sources have Making a pitch to investors Approaching potential lenders for financing Financial Analysis & Planning Unit 1: Financial strategies Your Role in Financial Decision Making Who is responsible for the financial decisions in your company? The Goal of Business Understand the Language of Finance Accounting as a Language Learn the Language Visual Activity – Accounting Process Accounting and Recordkeeping Systems Self Check – Account Categories Read the Story A Word about Financial Concepts Financial Concept: The Accounting Equation Financial Concept: The Matching Principle The Common Financial Statements Income Statement The Balance Sheet Statement of Cash Flows The Purpose of Financial Statements Unit 2: Financial dashboard - introduction to financial gauges Understand Basic Financial Concepts Introduction The Story Statements Tell Financial Concept: The Accounting Equation Financial Concept: The Profit Matching Principle Financial Concept: The Fund Matching Principle Financial Concept: Cash Basis vs. Accrual Basis Financial Concept: Cash vs. Profits Financial Concept: Debt vs. Equity (Optimum Capital Structure) Financial Strategies Financial strategies stem from business goals Take a Look: Example Financial Strategies Financial Gauges Introduction to Financial Gauges Your Financial Gauges Profitability-based gauges Performance-based gauges Reading Your Financial Gauges The Story Financial Gauges Tell Research and Analysis Unit 3: Financial Gauges - Profitability Profitability Gauges Ratio Analysis Financial Gauge: Net Profit Margin (or) The Bottom Line Financial Gauge: Gross Profit Margin Financial Gauge: Operating Margin Using Profitability Ratios The Components of Profitability The Origin of Profits Sales and Expenses Sales Sales Strategies Pricing Strategies Cost of Goods Sold and Cost of Sales Cost of Goods Sold Gross Profit Margin Gross Profit Analysis and Planning Evaluate Profitability of Product or Service Lines Expenses Budget vs. Actual Analysis Cost Management and Efficiency Unit 4: Financial Gauges - Performance Making Money The Goal of Business Value Growth Company Resources Taking Advantage of Assets Tangible vs. Intangible Assets Cash Making the Most of Liabilities and Equity Liabilities Equity Performance Financial Gauges Financial Gauge: Current and Quick Ratio (Liquidity) Financial Gauge: Return on Assets Financial Gauge: Return on Equity Financial Gauge: Debt to Equity Ratio Financial Analysis and Planning Summary Downtown Publishing Financial Performance Analysis Summary

This Certificate offers you an introduction to the use of games for business purposes. Learn the basics of designing both video and analog games, with a focus on games beyond entertainment. In the first course, Explore game design resources, mechanics, and verbs used in different games. Develop game ideas and understand how to work with game developers. In the second course, discover the basics of the video game design process, main video game genres, and use a game development application to start creating games. Completing this Certificate in Basic Game Design will equip you with knowledge and skills to create games and understand game design. Courses must be taken in order: Introduction to Game Design Intermediate Video Game Design Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Introduction to Game Design Unit 1: What Makes a Game? Practical Definition for Game The Anatomy of a Game Games and Play Different Types of Games Unit 2: Essentials of Design Getting Beyond a Game Idea Game Verbs and Game Mechanics Documentation Test Early, Test Often Unit 3: Game Design: Solo and in Teams Defining Development Needs Roles in Game Design Finding Design and Development Partners Unit 4: Serious Games & Gamification Games Beyond Entertainment Designing "Serious" Games Gamification Designing Gamification Systems Intermediate Video Game Design Unit 1: A brief history of Video Game Development Arcades & Consoles From PCs to Multiplayer Play a Game -Game Analysis Game Maker Introduction Unit 2: Player Motivation Geographics, demographics, and psychographics Who Plays Why We Play Game Maker Making Art: About Sprites, Objects, Rooms Unit 3: Platforms, Genres and Story Elements Game Application: The Audience Platforms & Player Modes Story Elements: Premise, Backstory, Synopsis, Theme, & Setting Character Archetypes & Character Development Game Maker: Programming Events & Actions Unit 4: The Production Process Documentation: The Game Design Doc Creating the Team Production Phases Marketing Game Maker: Your First Game

Begin by understanding the format, construction, and successful techniques of writing good business reports and proposals. Improve your skills with editing and proofreading. Discover what good journalists know and learn how to write a news story, press release, or other publicity notice that stands out in the workplace. Enhance your career by mastering critical communication skills that will help you move forward and stand out in your organization. Courses (click link for details): Business Writing Effective Copywriting Writing News and Press Releases Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Business Writing Unit 1: Writing as a process Audience, Purpose, and Medium Outlining for Successful Writing Organization Models (Choosing a Model that Works) Principles of Business Communication Unit 2: Written communication in the workplace Writing Reports (formal and informal) Drafting and Revision Writing the First Draft Constructing Openings and Closings that Work Unit 3: Writing a proposal Writing for Your Readers Writing Effective Content Safeguarding Users Ethical Considerations Unit 4: Collaborative writing and research Research and Team Writing Collaborating Across Departments Working Through Conflict Effective Copywriting Unit 1: Copywriting essentials How to tell the difference between bad copy and good copy The art of the perfect sentence Developing your message Crafting your document roadmap Adapting your style to the audience and message Unit 2: Getting to the point Clarity and brevity: Less is more Active vs. Passive Voice Cutting the clutter Using concrete examples and avoiding unwarranted superlatives Unit 3: Self Editing Leaving yourself time for revisions Avoiding common grammar mistakes and punctuation pitfalls Subject, verb and object agreement Fact checking The benefits of having an in-house style guide Unit 4: Creating attention-grabbing press releases Writing benefit-driven copy Setting the right tone Language to use and language to avoid Writing a great headline Writing News and Press Releases Unit 1: The skills good journalists have What journalists know how to do How to think like your audience Kinds of publicity notices Keys to successful publicity notices Unit 2: Writing a good news story The inverted pyramid The 5 Ws and H How not to bury the lead Writing a good headline for your story Unit 3: Creating the successful press release The press release format Quotes, how many to use, who to quote and how How and where to highlight your organization and contact Avoiding the direct sales pitch Unit 4: Distributing your press release Targeting media, journalists and audiences Email press releases Print press releases Getting attention

In today's business world, customer service plays a crucial role in every organization's success. As technology advances, the need for human interaction with customers becomes even more critical. Whether it's retaining customers, serving your audience, or converting potential inquiries into sales, good customer service is now essential. Improve your customer service skills to advance your career, enhance productivity, and contribute to your organization's success. Discover exceptional techniques for customer service that are not found anywhere else. Courses (click link for course details): Keys to Customer Service Extraordinary Customer Service Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details Keys to Customer Service Unit 1: Understand Service Matters Longevity and Loyalty Cost of a Lost Customer Engage Your Customer Unit 2: Listen to Your Customer Active Listening Avoid Improper Listening The Power of Feedback Unit 3: Web Sites and Electronic Communication Web-Based Customer Service Disadvantages of Web-Based Customer Service Evaluate Your Web-Based Customer Service Unit 4: Customer Turnoffs Exceed customer expectations Recognize and categorize customer turnoffs Deal with customer expectations and turnoffs Extraordinary Customer Service Unit 1: Understanding your customer Why customer service is important Knowing your customer Customers are constantly evaluating you Basic customer service skills you may not have thought of Unit 2: Setting customer expectations Analyzing customer contacts Developing internal customer targets How to easily exceed your customers' expectations Unit 3: Developing effective processes What is working for your customers Re-engineering your process Ways to give the best information Handling complaints Unit 4: Making customer service extraordinary Tweaking the customer's experience Telling the world how great you are Having fun

Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. Add a whole new skill set to your portfolio, and make a big difference in the success of your organization by acquiring data analysis skills. Begin with getting a basic understanding of how to analyze data in a business setting. Then learn how many of your business decisions involve comparing groups for differences. You will know the statistics behind these group differences and relationships. Finally you will find out how to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Whether your business is home based or a large company, this certificate will take you to the next level where important decision-making is concerned. Students need to have an understanding of Microsoft Excel to complete this certificate. This Certificate is comprised of the following courses. (Scroll down for class details): Introduction Intermediate Advanced Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Introduction to Data Analysis Unit 1: Understanding Data Identify sources of Data Discover methods of Collecting Data Examine Quantitative Data Examine Qualitative Data Unit 2: Processing Data Introduction to Statistics Determine the Appropriate Statistical Method for use in various scenarios Identify methods of Sorting and Filtering Data Categorize Data Unit 3: Analyzing Data Discuss Probability and the Normal Distribution Perform Trend Analysis Perform Breakeven Analysis Understand basic Statistical Modelling Unit 4: Interpreting and Presenting Results Design Professional-looking Tables Generate Effective Charts Create Pivot Tables and Pivot Charts Compile a Dashboard for Management Intermediate Data Analysis Unit 1: Looking for Differences between Groups Two separate groups Two related groups Three or more groups Unit 2: Looking for Relationships Pairs of variables Clusters of variables Predicting one variable from one or more variable Unit 3: Looking at Ratings Tests of difference using ratings Tests of relationship using ratings Unit 4: Looking at How to Report the Results Visual displays How to draft the narrative How to engage your audience Advanced Data Analysis Unit 1: Developing a Survey Purposes of surveys Fundamentals of Survey Research Ethical Considerations Likert Scales Unit 2: Comparing Means Chi-Square Statistical Significance Communicating Results Graphically and Textually Practical Problems involving Means Comparisons Unit 3: Finding Differences between Groups ANOVA Post Hoc Comparisons Communicating Results Graphically and Textually Practical Problems Involving ANOVA Unit 4: Individual Research Inquiries Developing Research Questions Setting Up Study Communicating Results Graphically and Textually

Especially geared for future leaders in the Gen Y generation (born 1980-1999), the certificate provides how-to practical information on advancing your leadership potential and making a difference in both the workplace and in society. Find out what it takes to become an effective leader. Discover your style of leadership. Discuss task completion, building relationships with your subordinates, becoming socially perceptive to changes in the workplace, utilizing your emotions in a positive and effective manner, and addressing challenging goals. Then learn the unspoken secrets that leaders know and the strategies they employ/exhibit in for influencing others. Leadership skills are acquired and learned. You can become a leader if you know the do’s and don’ts; what to say, what not to say; what to do, what not to do. At the end of completing the three course certificate, come away with a new understanding, new toolbox of leadership skills, and the information to move your leadership development into high gear. Courses (click links for course details): Leadership Principles Developing Your Leadership Skills Developing Your Professional Career Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Leadership Principles Unit 1: What leaders do and believe What leaders do, and don’t do What Leaders Believe Attributes of leaders: what characteristics leaders have that others don’t What leadership experts say about leadership Unit 2: Recognizing your leadership style Leadership Traits The Philosophy of Leadership Leadership Models Leadership is made, not born Unit 3: The vision thing Leadership vision in the 21st Century Deciding where you want to go Creating your vision Making others believe in your vision Unit 4: The power of empowerment What empowerment is, and is not Why Gen Y and Z demand empowerment The risks and rewards of empowerment Ways to empower others Developing Your Leadership Skills Unit 1: Making leadership happen What leaders do, and don’t do What Leaders Believe Attributes of leaders: what characteristics leaders have that others don’t Making it happen: becoming a leader Leadership procedures and processes, how leaders work Unit 2: Attending meetings: Where the action is How to attend a meeting when you are not the leader The dynamics of meetings Recognizing the players in a meeting How to study. The unspoken cues of body language, silence, objections Studying/Reading the leader in a meeting Unit 3: The secrets of leading successful meetings Creating your meeting agenda and objective The 5 Secrets of leading an outcome oriented meeting Getting something passed Understanding meeting procedures: Bob’s Process Model Unit 4: Change: How to influence others Creating the argument Delivering the case Gaining support, before, during, and after meetings Taking leadership Developing Your Professional Career Unit 1: Mapping your career for success Defining where you want to be in your career in 5, 10, 15 years Setting and monitoring your career goals Establishing a mentor partnership as a start in your professional career Unit 2: Developing your professional career through non-verbal communication The difference between verbal and non-verbal communication Conveying the right message with your body language Writing what you think Haptics – Using touch to convey non-verbal communication How to understand others non-verbal communication Unit 3: Image is everything You are your brand What you wear can determine where you go How to determine if your image is headed in the right direction How your communication and your image should agree with each other Unit 4: Using social media to help developing your professional career The purpose of Social Media How to use Social Media to create a professional online presence How to avoid negative images trap that many people fall victim to on Social Media

Discover advanced and new best practices in Integrated Marketing, the growing field that integrates traditional print marketing with digital marketing for even greater marketing success. Young generations are embracing print as well as online media, creating this exciting new area of marketing. Find out the keys to success in the almost forgotten but still remarkably effective area of print, including catalogs, direct mail letters and post cards. Gain advanced marketing concepts and principles such as R, F, & M analysis; AIDA, and the 3-30-3 principle, that lead directly to practical marketing success. Acquire the understanding of how digital marketing and print complement and enhance each other, and how to integrate both kinds of marketing for even greater overall effectiveness. Courses: Advanced Marketing Concepts Writing Marketing Copy Integrated Marketing Best Practices Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Advanced Marketing Concepts Unit 1: Analyzing Customer Purchasing and Demographics R,F & M Analysis Calculating Customer Lifetime Value Key Demographics to collect, and why The 80/20, AIDA, and 3-30-3 Principles Unit 2: Pricing to Improve Profit Margins Market pricing, price points and listing prices Clustered versus diversified pricing Price increase, and decrease, impact on sales Raising prices: guidelines for when, and how Unit 3: Your Seven Primary Market Segments Boston Consulting Group’s Stars & Dogs Repeat customers versus new customers Determining your seven primary market segments Strategic marketing by market segment Unit 4: The Top 10 Advanced Marketing Concepts The 5 marketing experts you need to know, and why Researching marketing best practice The best marketing books The top ten advanced marketing concepts you must know Writing Marketing Copy Unit 1: Power Up Your Copy The two biggest motivators for your customers Appealing to the emotions Secrets of the masters in writing marketing copy Words, like “meaningful” and “interesting,” to avoid Unit 2: Writing Results-First Copy How-to tips on copy writing. Don’t bury the lead How to effectively use verbs The importance of using second person language Unit 3: Editing Your Copy Step by step editing process for marketing copy Sentence construction and pitfalls Copy length for various mediums Differences for email, website, print and other media Unit 4: Enhancing Copy with Testimonials & Images How to get testimonials The 3 things to look for in a testimonial How to edit a testimonial Complementing copy with images Integrated Marketing Best Practices Unit 1: Moving Inquiries to Customers The purpose and uniqueness of Integrated Marketing. Some 25 marketing options. Choosing the best for you. An Integrated Marketing Model All paths (almost) lead to your website Unit 2: Developing Inquiry Campaigns Choosing your methods Generating inquiries Following up with inquiries Hidden Engagement with ‘Contact Us’ Unit 3: Your Best 5 Digital Marketing Methods The hot 5, and why they work Picking your best 5 digital marketing methods Trending Up Why multiple channels can reach different audiences Unit 4: Integrating Digital with Print Following digital with print Using print to engage your website What goes in print; what goes online The 3 most effective engagement techniques

Become a Microsoft Office Pro! Master Word, Excel, and PowerPoint to create stunning documents, analyze data, and captivate audiences. This hands-on course will boost your career and digital skills. Courses: Mastering Microsoft Excel Mastering Microsoft Word Mastering Microsoft PowerPoint Software requirement: Microsoft Excel, Microsoft Word, and Microsoft PowerPoint Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Excel Unit 1: Excel From The Ground Up Why businesses use Excel for spreadsheet management Technical requirements to use Excel (and all Office modules) Launch Excel and create your first Excel worksheet Discover how to protect and save your document Set your document’s Properties and Attributes including Subject, Title and Author Unit 2: Excel Document Creation Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup Learn how to populate, format and merge cells Create multiple worksheet “workbooks” Learn how to insert comments and check spelling Unit 3: Advanced Features and Functionality Create and manage formulas and functions Filter and sort tables and data Create “live” connections between multiple worksheets Create effective and informative table and charts Unit 4: Excel Management and Sharing Create meaningful file names and understand filing systems to manage Excel documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including setting print areas Learn how to export Excel tables and charts to PowerPoint presentations and Word documents Use Outlook to send Excel worksheets and workbooks to other users Word Unit 1: Getting Started with Word Why businesses use Word for document creation Launch Word and create your first Word document Discover how to protect and save your documents. Set your document’s Properties and Attributes including Subject, Title, and Author Unit 2: Word Document Creation Explore the different features and functionality of Word Understand documents and their makeup Learn how to create, format, and present documents Create multiple documents and templates Learn how to insert comments and professionally edit Unit 3: Advanced Features and Functionality Create and manage documents Learn to organize documents into chapters and sections Create “live” connections between documents and Excel worksheets Create effective and informative documents with tables and charts Unit 4: Word Management and Sharing Create meaningful file names and understand filing systems to manage Word documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including print settings PowerPoint Unit 1: PowerPoint Overview Why businesses use PowerPoint for presentations Launch PowerPoint and create your first PowerPoint presentation Discover how to protect and save your slides. Set your document’s Properties and Attributes including Subject, Title, and Author Unit 2: PowerPoint Document Creation Explore the different parts of the PowerPoint slide navigation Understand slides and templates, and their makeup Learn how to populate, format, and present slides Create multiple slides and templates Learn how to insert comments and professionally edit Unit 3: Advanced Features and Functionality Create and manage slides Learn to organize slides into sections Create “live” connections between slides and Excel worksheets Create effective and informative slides with tables and charts Unit 4: PowerPoint Management and Sharing Create meaningful file names and understand filing systems to manage PowerPoint documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including print settings

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world.Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence. Students must have Microsoft Excel installed to complete this certificate. Courses must be taken in order: Mastering Microsoft Excel Intermediate Excel Advanced Excel Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Mastering Microsoft Excel Unit 1: Excel From The Ground Up Why businesses use Excel for spreadsheet management Technical requirements to use Excel (and all Office modules) Launch Excel and create your first Excel worksheet Discover how to protect and save your document Set your document’s Properties and Attributes including Subject, Title and Author Unit 2: Excel Document Creation Explore the different parts of the Excel worksheet and document navigation Understand cells and their makeup Learn how to populate, format and merge cells Create multiple worksheet “workbooks” Learn how to insert comments and check spelling Unit 3: Advanced Features and Functionality Create and manage formulas and functions Filter and sort tables and data Create “live” connections between multiple worksheets Create effective and informative table and charts Unit 4: Excel Management and Sharing Create meaningful file names and understand filing systems to manage Excel documents Organize your documents on your hard drive and learn how to copy and move documents Manage track changes when co-authoring documents Printing and PDF file creation including setting print areas Learn how to export Excel tables and charts to PowerPoint presentations and Word documents Use Outlook to send Excel worksheets and workbooks to other users Intermediate Excel Unit 1: Organizing Worksheet and Table Data Introduction to tables Formatting tables using table styles Using formulas in tables Sorting and Filtering table data Unit 2: Understanding Popular Excel Functions Understanding Named Ranges Applying business functions Creating functions that handle text Performing basic lookup functions Creating functions that work with dates and times Unit 3: Improving Worksheet Appearance Formatting cells in worksheets Correcting common function errors Creating and using templates Customizing Excel toolbar Unit 4: Analyzing Data Using Data Validation and Pivot Tables Understanding how to convert text to columns Understanding how to analyze spreadsheet data Understanding the basic pivot table layout and key terms Creating and formatting simple pivot tables Advanced Excel Unit 1: Advanced Functions Used To Make Business Decisions Applying multiple criteria to functions Using And criteria Using Or criteria Using And and Or and Not criteria Advanced Logical functions Using If -Then control statements Implementing If functions with Aggregate functions Unit 2: Functions Used to Make Financial Decisions Learning basic financial functions Applying functions to perform loan calculations Computing loan payments Computing interest rate Computing number of payment periods Computing present value of a loan Working with additional functions Unit 3: Applying Different Scenarios Using Excel Data Tools Understanding Different What-If Analysis Tools Performing What-If Analysis to see how data changes outcomes in formulas Using Scenario Manager Using Data Tables Using Goal Seek Applying rules to manage cell data Implement validation rules to avoid invalid entries Entering validation rules Avoiding duplicate data entries Unit 4: Powerful Tools Used to Complete Data Implementation and Analysis Exporting and Importing Data into Workbook Protecting a workbook Making improved business decisions using pivot tables Creating an Excel Dashboard to visually display relevant data

Non-profits today need to be run like a business in many respects. You have competition, a need to generate income and a surplus, and staff need to be even more productive. Get the best training on revenue generation for nonprofits, and program evaluation for nonprofits, with our Certificate in Nonprofit Administration. Come away with the latest best information from instructors who train people in nonprofits. Courses: Revenue Generation for Nonprofits Program Evaluation for Nonprofits Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Revenue Generation for Nonprofits Unit 1: Introduction to Revenue Generation Setting and using revenue generation benchmarks Determining annual objectives How to best use this course information Unit 2: Understanding Your Audience The benefits of knowing your audience better What to ask your audience How to get the best information Collecting and using the best data Where to find the new ideas Unit 3: Developing Programs and Services The right questions for the best success Natural life cycles of programs and services Determining which ones to continue Creating successful new programs and services Unit 4: Analyzing Programs and Services Analyzing the past performance Determining future productivity Analysis tools Simple analysis technique Unit 5: Setting the Right Price How price affects attendance Price breaks that determine the price to set Setting the best price Pricing strategies Unit 6: Marketing Effectively Building your identify Developing market segments Determining who to market to Unit 7: Developing Promotions Making promotions that work Creating the best layouts Making promotions that sell Unit 8: Distributing Promotions Print, social media, and eMarketing techniques Knowing what promotions work The most effective promotion methods Program Evaluation for Nonprofits Unit 1: Introduction to Nonprofit Evaluation & the Logic Model What evaluation is and is not Why evaluation is important to nonprofit organizations and why your funders are asking you for it Planning for evaluation begins when you apply for the grant Types of evaluation, and the approaches best suited to nonprofit programs Planning tools for evaluation – introduction to the logic model Crafting accurate, concise outcome statements Unit 2: Creating an Evaluation Plan What an evaluation plan is and why you need one Using outcomes from our logic model to create your evaluation plan Setting priorities for your evaluation (navigating barriers based on budget, funder requirements, staff time and staff capacity) Creating indicators for your outcomes Defining benchmarks and targets where appropriate Unit 3: Collecting the Data Taking stock of the data you already use Making data collection systematic Choosing and/or creating data collection tools – output information, surveys, interviews, focus groups Unit 4: Analysis, Reporting and Use – Putting it All Together Appropriate analysis of the common data collection tools covered in Unit 3 Common analysis mistakes and how to avoid them Reporting to various stakeholders (funders, donors, Board of Directors and the community) Using data for program improvement

For those new to teaching online, or those already teaching online. Get the best instruction from the foremost authorities in online learning. From building to improving an online course, from fostering online discussion to encouraging student interaction, from traditional assessment to online tests, the program will give you both the fundamentals of teaching online, as well as the most advanced tips and techniques in the business. Your instructors are authors, speakers and consultants in online learning and teaching. Courses: Advanced Online Teaching Designing Online Instruction Fostering Online Discussion Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Advanced Online Teaching Unit 1: How the internet is changing how we learn To 10 reasons cognitive information is delivered better online Learning online What you cannot do online How young people learn online The brain and learning online Unit 2: Building your online course The 10 step model How knowledge is organized online Building online content Creating audio and video presentations Development time and cost Unit 3: Teaching your online course Facilitating online discussions Creating a safe online learning environment Responding to student questions and needs How much time you should spend online Evaluating your online course Unit 4: Creating assessment and measuring online learning Designing online assessment Multiple assessments Assessment as a learning tool Grading in the 21st century Best practices in online teaching Designing Online Instruction Unit 1: Overview of the online instructional environment Internet basics Principles behind the adoption of technology innovation The nature of the online learning environment Unit 2: Envisioning your online course Types of web courses Preparing for the move to the web Analyzing your current course Planning your web course Identifying resources Design guides Unit 3: Developing a web course Team vs individual approach to development Phases of design and development Models of web courses Unit 4: Online Interaction Online collaboration Creating an interactive environment Motivating student-student interaction Managing interaction Unit 5: Issues in the web environment Managing email Facilitating discussion Class size Copyright Fostering Online Discussion Unit 1: How continual engagement helps you foster effective online discussions What is continual engagement? Why is continual engagement important? Breaking down the barriers to effective continual engagement in your discussion interaction Unit 2: Building your students' success through your interaction Why continual engagement in online discussion is important to your students' success Choosing your words carefully in discussion interaction Strategies to use at the beginning of your term Strategies to use as the term gets underway Strategies to use when things get hectic Unit 3: Assessing your students' performance Giving effective feedback Communicating with students about grades Some special challenges of group work and how to overcome them Unit 4: Keeping your communication skills sharp How networking with your peers can build your skills Using break times effectively Working with an assistant How online interaction enhances your face-to-face instruction

In today’s business environment, there is a need for good project management. Project management provides visibility of project health to the business and the customer. Through continuous monitoring, early detection of variations to plan, schedule, and budget can be communicated to stakeholders for quick resolution, including project cancelation. Project management is one of the fastest paths to promotion by increasing your network through greater exposure. First, gain the skills, tools and templates to confidently develop and maintain a project. An overview of salaries, certification costs, education and experience requirements are provided. Then acquire a well-rounded knowledge of the five Project Management Processes relating to the Project Management Body of Knowledge Guide. This basic information will assist you in learning the beginnings of Project Management, whether you are interested in project management, in a project management field, or in any line of work. Finally, learn the ten Project management Knowledge Areas and their support role and relationships to the five Project Management Processes. Classes must be taken in the following order: Introduction to Project Management Project Management Processes Project Management Knowledge Areas Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Introduction to Project Management Unit 1: Project management overview Project Manager’s Responsibilities & Commitment Certification Requirements & Costs Compensation Project Framework Preview Unit 2: Tools & templates Project Process Checklist Project Charter Template Project Plan Template Communications Templates Unit 3: Creating a project Creating a project plan and schedule in MS Project Creating charter and team/stakeholder matrices Creating Change Log Creating a Risk Plan Unit 4: Managing the project - prepare a project status deck Creating status deck (format, content, operating rhythm, etc.) Collecting Detail Status Presenting Summary Status Simulating project close-out & celebrate Project Management Processes Unit 1: Project management process welcome & initiating process group What is Project Management What is a Process Initiating Process Group Unit 2: Planning process group Developing the Project Management Plan Planning strategy Planning for desired project objectives Unit 3: Executing process group and monitoring & controlling process group What differs between Executing and Monitoring & Controlling process groups Analysis and risks When to make changes and how Unit 4: Closing process group & farewell How to be aware of what should be thought of when closing a project Review of lessons learned and why it is important Review acknowledgement of all five process groups Project Management Knowledge Areas Unit 1: Project integration & scope management Integration Management Direct & Manage Project Work Perform Integrated Change Control Scope Management Control Scope Unit 2: Project time & cost management Time Management Sequence Activities Control Schedule Cost Management Plan Cost Management Unit 3: Project quality, human resources & communications management Quality Management Human Resources Management Communications Management Unit 4: Project risk, procurement & stakeholder management Risk Management Plan Risk Responses Procurement Management Stakeholder Management

Save time, track money, and get important insights with Quickbooks Online. As a small business manager, owner, bookkeeper, or accounting professional, Quickbooks Online is the preferred choice. Benefit from the patches and regular automatic upgrades to the software. Gain a comprehensive understanding of QuickBooks Online and learn how to work with more advanced topics to maximize the benefits of the platform. Courses must be taken in order: Level 1 Level 2 Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class Details: Level 1: Unit 1: Introduction to QuickBooks Online Use the interface Edit the Chart of Accounts Make General Journal Entries Memorized Transactions Find and Adjust General Journal Entries Create Journal Reports Create Inventory Items Create Service Items Inventory Report Unit 2: Create and modify supplier records Enter Bills for purchases Enter Checks Find and modify Supplier Bills Midterm Project Unit 3: Create Memorized Transactions Purchase Orders Supplier Reports Payments Supplier Credit Unit 4: Create and modify Customer records Enter Sales Receipts Record Sales Estimates Enter Invoices in Accounts Receivable View, adjust and delete sales Receive Customer Payments Run Customer Reports Final Project Level 2: Unit 1: Company Setup, Banking and Credit Cards Setting up and Customizing Settings Entering Balances – B/L, Customer, Vendor and Inventory Bank Reconciliation Using Credit Card Unit 2: Budgets and Inventory Budgets Tags Adjusting bundles Midterm Project Unit 3: Multiple Currencies Setting up Foreign Currency Updating the Exchange Rate Setting up a Foreign Currency Bank Account Setting up a Foreign Vendor Setting up a Foreign Customer Purchases and Sales using foreign currency Unit 4: Statements, NSF Checks and Bad Debts Preparing Customer Statements NSF cheques Using Projects Final Project

This is your invitation to teach others in-person and join in one of the more important functions in life - passing on knowledge and skills. It is both an opportunity and a responsibility. Whether you want to teach others or currently teach others, in any setting, either formally or informally, this course is for you. We will give you both the fundamental and advanced information to improve your teaching. Your lead instructor is author of How to Teach Adults, the best-selling book on the subject. The ebook version is included in the course. Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Unit 1: How adults learn Emotional characteristics, self-image as key Physical characteristics and your physical surroundings Mental characteristics, adults display a readiness to learn Social characteristics, learners’ experiences, schooling, and prior experience Keys to helping adults learn Unit 2: Tackling learning styles Sensory learning styles Gender learning styles Neurological learning styles Unit 3: Generational learning styles The cohort experience Understanding generational differences How Baby Boomers learn How Gen X and Gen Y learn Unit 4: How to prepare for your course Preparing the Course Goals, objectives, and end results Amount of material to cover Slant or approach, a range of ways to approach your subject Materials preparation Unit 5: Discovering and involving your participants Finding out more about your participants The First Class, why this meeting is critical, ice breakers How to involve your participants The Teachable Moment, a special time when you let go for awhile Unit 6: Ways to vary your teaching techniques Modes of teaching, different formats for various situations Tips on how to lead a good discussion How to ask a good question - one of the most overlooked skills Making small group activities successful Energizing your physical learning environment Unit 7: Great presentation techniques Surprising do’s and don’ts of presenting Advanced presentation techniques Teaching tools, including audio-visuals Handouts that really zing Learning mediums, extra special touches to enhance learning Unit 8: Improving your teaching Measuring results and learning Using the web in face-to-face courses Improving your course, every time Learning and teaching in the 21st century

Online users say a website’s design is the number one criteria for deciding whether a company is credible or not, according to recent research. Understanding what it takes to produce effective web design is essential in today’s market of highly saturated digital competition. First discover the basics of web design using HTML and CSS. No prior knowledge of HTML or web design is required. After the first course you will have the info you need to plan and design effective web pages. Then find out how to create effective and dynamic websites/applications. Take away a functioning web application hosted on a web server that is both accessible and Search Engine Optimized. Finally, learn about responsive design process, advanced layout and design features. Plus explore industry standard technologies and frameworks. This Certificate must be taken in the following order: Introduction Intermediate Advanced Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Introduction Unit 1: The Principles of Web Design Plan the Structure of a Website / File Management Target your audience Designing Effective Web Layout and Navigation Unit 2: Structure vs Presentation Introduction to HTML5 Basic Markup Introduction to CSS3 - Linking and Embedding Stylesheets Unit 3: Web Graphics and Content Understanding web graphics Acquiring images / Copyright law and graphics on the web Optimizing images Adding images to your web page Unit 4: Publishing Your Site Domain Name Registration / Hosting Services Finding the appropriate Hosting space Publishing Website Using FTP-Client Intermediate Unit 1: Javascript Expressions and Control Flow Functions, Objects, and Arrays Form Validation and Error Handling Accessing CSS from JavaScript Unit 2: MySQL Install a local testing server Use phpMyAdmin to create MySQL databases and manage users Create MySQL database tables with common field types and options Gain a working knowledge of most common MySQL statements Unit 3: PHP Structure Expressions and functions Objects and arrays Practical use Unit 4: Accessibility and Search Engine Optimization Accessibility Guidelines Accessibility Conformance Search Engine Optimization Advanced Unit 1: Responsive Web Design Planning your layout Creating HTML containers, content, and links Unit 2: Responsive Web Design - Styling Creating and styling the layout with CSS Creating a menu system Styling headings, body text, and footers Unit 3: Responsive Web Design – Styling the Navigation & Making Adjustments Making layout adjustments for different screen sizes Swapping high-resolution graphics for Retina displays Making sure content is printable Where to go for more information Unit 4: Responsive Web Design / Additional Frameworks What is Bootstrap Creating a basic template Reviewing basic styles and typography Where to go for more information

Improve your workplace communication skills and increase your chances of career success with a comprehensive and intensive training program. Gain valuable skills and techniques that you can start implementing on Monday morning. Learn a workable conflict management model, successful conflict management strategies, and how to improve your negotiation skills for a win-win outcome. Discover more about yourself and others using personality profiles for better work performance. Learn from our popular instructors and take away practical how-to skills that really work. Courses: Conflict Management Management in the 21st Century Using Personality Profiles for Better Work Performance Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Class details: Conflict Management Unit 1: Understanding Conflict Definition of conflict. The up side of conflict. Describe performance expectations related to conflict. Unit 2: Understanding the Conflict Management Model Using the model Dialog for a conflict conversation When to take action and address a conflict situation Unit 3: Conflict Management Case Studies Review of real world cases Analyze and evaluate the cases Unit 4: Strategies for success Creating a standard of performance Creating your own dialog Applying the model Management in the 21st Century Unit 1: Principles of collaboration in management Defining principles of collaboration Emotions, self-mastery and collaboration Redirecting teams and group collaboration Conflict management and facilitation Unit 2: Relationship building Building relationships fundamentals Renegotiating failed relationships Managing collaborative potentials Unit 3: Strategies to tap into group collaborative potential Harnessing collaborative energy Responsible communication Managing collaboration for performance Unit 4: Your action plan for collaborative management Setting your management goals Identify and utilize collaborative resources Creating a collaborative management action plan Using Personality Profiles for Better Work Performance Unit 1: Understanding the DiSC Profile Getting to know the four styles of the DiSC profile Dominance Influence Steadiness Compliance Unit 2: Communicating effectively with each style Understanding preferences for communicating The most effective and influential communicators Knowing how to reach and be understood by others Insights into barriers that each style has, Clarifying detractors and enhancements for each style Unit 3: Increasing your Success Part 1 In depth analysis of the D and I behavioral styles from the DiSC profile Creating action plans for D and I styles Unit 4: Increasing your Success Part 2 Analyzing the other two behavioral styles from the DiSC profile: S and C Developing action plans for S and C styles

Join us at Cheng Heng Restaurant, a vibrant culinary haven that brings the flavors and traditions of Cambodia to your plate through an authentic Cambodian dining experience. Enjoy a five-course meal of some of Cheng Heng's favorite dishes, while owner and refugee Kumrath Lam shares stories of her journey from Cambodia to owning a restaurant in the Twin Cities. Historian Dave Bredemus will join us. Celebrate the magic of Cambodia, brought to life through the dedication of a woman-owned, family-run establishment. Please note that to maintain the cultural integrity and authenticity of the cuisine, we regretfully cannot accommodate any dietary restrictions or allergies. Hot tea is included. Includes tax and gratuity. Limited capacity event. Cheng Heng is located at 448 University Ave W, St Paul, MN 55103. If event is sold out, please add your names to the waitlist. We will contact you if tickets becomes available.

Learn to play the banjo in a fun and supportive class designed for adults. Old time Clawhammer Banjo is played by hitting down on the strings with the back of the fingernail usually followed by a strum of all the strings and a pluck on the fifth with the thumb. This class will introduce the basic bum-ditty stroke, hammer ons, pull offs and slides. No experience necessary. Bring your banjo and let’s make music!

Coding is becoming one of the most in-demand skills in the workplace today. As a result, coding has become a core skill that bolsters one’s chances of becoming a higher value to organizations. The highest demand is for programming languages with broad applicability. Begin by getting introduced to the basics of computer programming and various programming languages. Then go to the next level and acquire all the basics of HTML and CSS. You will learn the relationship between these two industry-standard web page coding languages and the step by step process of hand coding and building web pages. Finally, discover the advanced features of CSS and learn how to use this very powerful language. Students must take the Coding Certificate classes in the below order: Introduction to Coding HTML Fundamentals CSS Fundamentals Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ Introduction to Coding Unit 1: Introduction to Programming Types of programming languages Practical Uses of Programing Text Editors Unit 2: Basic HTML/CSS Introduction to HTML Introduction to CSS Making a Simple Web Page Unit 3: Drawing and Coloring using Code Elements of Java Script Basic Drawing Using Code Basic Coloring Using Code Unit 4: Basic Animation using Code Uses of Animation Animation Basics Making a Simple Animation HTML Fundamentals Unit 1: HTML Basic Tags naming convention, tags: h, p, b, i, u, hr,br, attributes Unit 2: More HTML Tags links, lists, tables Unit 3 Images, directory structure Unit 4 Creating a multipage website, domains, hosting, pointing, FTP CSS Fundamentals Unit 1: Getting to Know CSS about CSS, CSS syntax, CSS types, working with internal CSS, styling text, styling links, styling lists, and styling tables. Unit 2: Using External CSS working with external CSS sheets, styling a multi-page website, Google fonts, and Web colors. Unit 3: div Elements id Selectors, introduction to elements, floating elements, Clearing Unwanted Floated Elements, web page layout using elements Unit 4: More about div Elements centering a web page, CSS box model, resetting margins and paddings, class selectors, inline CSS, tag

Created during an era when parks and gardens were all the rage, Como Park has delighted visitors from every walk of life since it first opened in 1873 and it continues to be one of the most beloved public parks in the Twin Cities. Designed by noted landscape architect Horace Cleveland, Como famously features distinct gardens, ponds, plazas, a conservatory, a zoo and a world class pavilion. It also quietly features countless memorials and statues that are tucked into the folds of its arresting grounds. This tour unveils the park’s hidden gems on a lovely morning walk that is sure to fascinate and inspire listeners of every age. Come and walk the trail less traveled and hear the stories of the park’s colorful history and development. Pack a lunch and make a day of it! Or stop for refreshments at the Pavilion at tours end! Tour is 1.5 miles If event is full, please enroll for the waitlist. We will contact you if a space becomes available.

Join us on the river with Colleen O'Connor Toberman, Land Use & Planning Program Director for Friends of the Mississippi. On this boat cruise, you'll enjoy autumn views of the Mississippi River's only gorge while learning about how we engineered the locks and dams to tame the river for industry. Is it time to change our vision for the future? Studies are underway right now to consider changing or removing the dams. This tour will cover the history, current state, and complex future possibilities for our metro Mississippi. River conditions permitting, our boat will travel up and down through Lock and Dam 1. Meet at the Watergate Marina, 2500 Crosby Farm Road, Saint Paul Minnesota, 55116. Crosby Farm Road is at the intersection of Shepherd Road and Gannon Road. Transportation to the Watergate Marina is on your own. Beverages will be available to purchase on board the boat. You may bring your own food. Ages 21+. If the cruise is sold out, please add your name to the waitist. We will let you know if tickets become available.

Equip yourself with the foundational knowledge and advanced skills needed to safeguard networks, data, and systems from cyber attacks. Conquer the core principles of cybersecurity, develop strategies to protect networks, and gain hands-on experience in identifying and mitigating cyber threats. Come away with the essential tools and knowledge to succeed in the ever-evolving field of cybersecurity. Courses in this certificate must be taken in the following order: Introduction to Cybersecurity Network Security and Defense Strategies Advanced Cyber Threat Analysis and Mitigation Courses are online and asynchronous, meaning students may login to the classroom anytime during the course session, day or night, 24/7. For more information, go to our Online Professional Development Certificates & Courses FAQ