Cambridge-Isanti Community Education

Identify the architecture and protocols that keep networks secure. Understand the role of routers, switches, and firewalls in network security. Tackle network security fundamentals, implementing firewalls and VPNS, intrusion detection and prevention systems (IDPS) and securing wireless networks. For more information, visit our question and answer page - Click Here.

Data analysis is one of the most sought after skills in the workplace. Companies have vast amounts of data and need people with the ability to analyze it. Get an understanding of how to analyze data in a business setting. This course can be taken alone or as part of the 3 course Certificate in Data Analysis. Class Details 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 For more information, visit our question and answer page - Click Here.

Advanced Excel contains tools that can help you prepare your worksheets accurately, examine your data for authentication, and find answers to your most difficult questions. Learn required business functions along with tools required to analyze data efficiently within the workplace. Save time by protecting your valuable data. Discover how to attractively visualize your data into meaningful information with confidence. This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. Class Details 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 For more information, visit our question and answer page - Click Here.

Expand your knowledge of Power BI Desktop to the highest level. Explore the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results. This course can be taken alone or as part of the 3 course Power BI Certificate. Class Details Unit 1: Power Query Utilize Column profile, distribution, and quality Perform fuzzy match Duplicate versus Reference queries Debug errors Unit 2: Data Modeling What a Star Schema is Understand relationship types Manage relationships Unit 3: DAX Understand contexts CALCULATE function COALESCE function Compute visual totals accurately Unit 4: Reports Insert Objects Create Bookmarks For more information, visit our question and answer page - Click Here.

Learn to improve and control processes through hypothesis testing, design of experiments, and statistical process control. Apply the concepts learned in the Introduction and Intermediate Six Sigma Green Belt courses. Finish the course Six Sigma Green Belt Certified. This course can be taken alone or as part of the 3 course Certificate in Six Sigma Green Belt. Class Details Unit 1 Analyze Exploratory Data Analysis Correlation and Regression Hypothesis Testing Basic Concepts Point & Interval Estimation Unit 2 Major Tests Paired-comparison Tests Single-Factor ANOVA Chi-square Unit 3 Improvement Techniques Design of Experiments (DOE) Introduction Terminology Design Types Implement and Validate Solutions Response Surfaces EVOP DOE Improvement Analysis Unit 4 Control Concepts Statistical Process Control (SPC) Objectives and Benefits Rational Subgrouping Application of Control Charts Variable Charts Attribute Charts Analysis of Control Charts Control Plans For more information, visit our question and answer page - Click Here.

Discover how to create a worksheet used to adjust account balances and prepare financial statements. Use your financial statements to measure performance, make improvements and set goals. Finally, learn how to close your books and prepare them for the next accounting period; this is done by journalizing and posting closing entries. This course can be taken alone or as part of the 3 course Bookkeeping Certificate. Class Details: Unit 1: Prepare a Worksheet What is a worksheet Columns included in the worksheet Completing each column Unit 2: The Income Statement Review the worksheet columns for the Income Statement Prepare the income statement Determine a profit or loss Unit 3: The Balance Sheet Review the worksheet columns for the Balance Sheet Prepare the balance sheet Unit 4: Closing Entries and Statement of Changes in Owner’s Equity Prepare post-closing entries for revenue and expense accounts Prepare a statement of changes in owner’s equity Applying year-end steps monthly or quarterly For more information, visit our question and answer page - Click Here.

Identify those skills that all great leaders possess, while learning new skills that will help take you to the next level. Whether you are leading a department or an organization, gain the knowledge you need to be successful. Learn how to incorporate a developed image and communication skills that will rocket you to that next level. This course can be taken alone or as part of the 3 course Certificate in Leadership Development. Class Details 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 develop 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 For more information, visit our question and answer page - Click Here.

Entrepreneurs must know how to effectively market their product or service. Learn a step by step approach to attract and keep customers, all within a realistic budget. Discover how to build a strong brand, analyze which tactics to use, and implement your marketing plan. Take away practical marketing tips and tools that you can use to improve your marketing efforts. This course can be taken alone or as part of the 3 course Entrepreneurship Certificate. Class Details: Unit 1: The Customer as the Driver Marketing Decisions Framework Positioning Your Product or Service Marketing Strategies and Goals Unit 2: Communicating Value to Customers Key Selling Messages Creating Emotional Connections Personal Selling Networking: Your 30-Second Introduction Unit 3: Creating a Strong Brand Managing the Marketing Mix Marketing on a Shoestring Budget Your Marketing Calendar Implementing Your Plan Unit 4: Building Customer Relationships Tools to Meet Your Strategic Goals Online Opportunities and Social Media Checklist Generating Buzz: Word-of-Mouth Marketing Measuring Effectiveness

Designed for non-financial managers, business owners, entrepreneurs, and other decision-makers, this advanced course will take the mystery out of money matters. Learn to assess and analyze the financial information that drives your business. Be empowered to make smart decisions when it comes to budgeting, setting goals, and assessing performance within your own area of influence. This course can be taken alone or as part of the 3 course Certificate in Accounting and Finance For Non-Financial Managers.. Class Details Unit 1: Financial Strategies 1.1 Your Role in Financial Decision Making Who is responsible for the financial decisions in your company? The Goal of Business 1.2 Understand the Language of Finance Accounting as a Language Learn the Language Visual Activity – Accounting Process Accounting and Recordkeeping Systems Self Check – Account Categories 1.3 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 1.4 The Purpose of Financial Statements Unit 2: Financial Dashboard – Introduction to Financial Gauges 2.1 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 Accounting Methods*** ***Financial Concept: Cash vs. Profits*** ***Financial Concept: Debt vs. Equity (Optimum Capital Structure)*** 2.2 Financial Strategies Financial strategies stem from business goals Take a Look: Example Financial Strategies 2.3 Financial Gauges Introduction to Financial Gauges Your Financial Gauges Profitability-based gauges Performance-based gauges 2.4 Reading Your Financial Gauges The Story Financial Gauges Tell Research and Analysis Unit 3: Financial Gauges - Profitability 3.1 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 3.2 The Components of Profitability The Origin of Profits Sales and Expenses 3.3 Sales Sales Strategies Pricing Strategies 3.4 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 3.5 Expenses Budget vs. Actual Analysis Cost Management and Efficiency Unit 4: Financial Gauges - Performance 4.1 Making Money The Goal of Business Value Growth Company Resources 4.2 Taking Advantage of Assets Tangible vs. Intangible Assets Cash 4.3 Making the Most of Liabilities and Equity Liabilities Equity 4.4 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 4.5 Financial Analysis and Planning Summary Downtown Publishing Financial Performance Analysis Summary For more information, visit our question and answer page - Click Here.

Strengthen, stretch, relax and breathe in this yoga class for men and women. The combination of movement and breath work provides a well-rounded, healing practice for mind, body and spirit. Appropriate for all levels. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.