Cambridge-Isanti Community Education

Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports. This course can be taken alone or as part of the 3 course Power BI Certificate. Class Details Unit 1: Power Query Review the ETL Process Insert columns using different methods Group, Summarize, Pivot, and UnPivot data Merge and Append queries Unit 2: Data Modeling What Data Modeling is Modeling Options Create and manage relationships Create Date table Unit 3: DAX Introduction to DAX Calculate columns and measures Time Intelligence functions Quick Measures Unit 4: Reports Filters versus Slicers Visual Hierarchies and Drill downs Drillthrough Define visual interactions Apply conditional formatting For more information, visit our question and answer page - Click Here.

Six Sigma professionals are in demand by organizations around the world. Our Green Belt training teaches participants problem-solving skills, using the DMAIC (Define, Measure, Analyze, Improve and Control) model. After completing this challenging course, Six Sigma Green Belts serve their organizations as a trained specialist able to work on Six Sigma projects that benefit the organization. This course can be taken alone or as part of the 3 course Certificate in Six Sigma Green Belt. Class Details Unit 1 Measure - Data & Process Analysis Process Analysis and Documentation Process Modeling Process Inputs and Outputs Collecting and Summarizing Data Data Types Data Collection Methods Data Accuracy and Integrity Graphical Methods Unit 2 Measure - Probability Probability and Statistics Valid Statistical Conclusions Central Limit Theorem Basic Probability Concepts Unit 3 Probability Distributions Binomial Distribution Poisson Distribution Normal Distribution Chi-square Distribution Student’s t Distribution Unit 4 Measure - Capability & Measurement Measurement System Analysis Process Capability and Performance Process Capability Studies Process Performance vs. Spec Process Capability Indices Short-term vs. Long-term Capability Process Capability for Attributes For more information, visit our question and answer page - Click Here.

Acquire the fundamentals of the most popular Web 2.0 technologies. Take away a functioning web application hosted on a web server that is both accessible and Search Engine Optimized. This course can be taken alone or as part of the 3 course Certificate in Web Design. Class Details 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 For more information, visit our question and answer page - Click Here.

Learn how to organize, display and calculate your data. Find out how to consolidate data proficiently. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Discover how easily pivot tables can be created to quickly summarize large amounts of data. This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. Class Details 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 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.

No one should be blind to their finances! Learn where the numbers go, and why. Understand, and know how to record, every penny that comes into and that goes out of your business. Learn how to create a chart of accounts that meet your needs. Discover bookkeeping terminology as well as what it means to keep track of the numbers. Class Details: Unit 1: The Accounting Equation and Chart of Accounts The accounting equation The chart of accounts for a business Temporary accounts (Revenue and Expenses) Where the accounts fall under the accounting equation Unit 2: Journals and the General Ledger Special Journals General Journal The General Ledger Accounts Unit 3: Recording Transactions The Rules Debits and Credits T-Accounts Using journals to record transactions Unit 4: Month End Closing Adjusting Entries Posting to the General Ledger End of month account balances

Begin by exploring the basics of computer programming and various programming languages. Acquire all the basics of HTML and CSS. 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. Discover the advanced features of CSS and learn how to use this very powerful language. Students must take the Coding Certificate classes in order: Spring 2024 Dates Summer 2024 Dates 1st Course Introduction to Coding 04/01/24-04/26/24 06/03/24-06/28/24 2nd Course HTML Fundamentals 05/06/24-05/31/24 07/01/24-07/26/24 3rd Course CSS Fundamentals 06/03/24-06/28/24 08/05/24-08/30/24 For more information, visit our question and answer page - Click Here.

Get the info you need to plan and design effective web pages. Come away knowing how to implement web pages by writing HTML and CSS code. Discover ways to enhance web pages with the use of page layout techniques, text formatting, graphics, and images. This course can be taken alone or as part of the 3 course Certificate in Web Design. Class Details 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 For more information, visit our question and answer page - Click Here.

Whether starting a business or growing the one you have, a business plan serves as a roadmap and can help secure needed funding. Evaluate the many aspects and potential hurdles of the business and build the Business Plan, one step at a time. Uncover hidden risks and assess the business from a marketing, management, and financial vantage point. This course can be taken alone or as part of the 3 course Entrepreneurship Certificate. Agenda Unit 1 Getting Started—Refine your concept and begin your plan Prepare your concept statement—What, Who, Why, When, and How. Identify product/service features and benefits. Identify limitation, liabilities, and regulations. Write your Business Description and evaluate it against a Business Description checklist. Unit 2 Prepare the Marketing Plan Conduct an industry and competitive analysis. Perform a market analysis and identify target markets and a market penetration strategy. Identify your pricing strategy. Write your Marketing Plan and evaluate it against a Marketing Plan checklist. Unit 3 Prepare the Management and Financial Plans Identify key people and positions, duties and responsibilities. Determine funding needs and sources. Create sales and expense estimates. Write your Management and Financial Plans and evaluate them against checklists. Unit 4 Complete the Business Plan and Assess Business Feasibility Polish the plan and add final elements—Cover Page, Executive Summary, Table of Contents. Evaluate business plan against checklist and identify items in need of additional work. Assess business against feasibility checklist. Identify next steps. For more information, visit our question and answer page - Click Here.

Whether you are sending out a press release, communicating internally with a memo or promoting your own skills on LinkedIn, strong writing skills are the key to success. Come away with the tools and techniques you need to improve your copywriting skills and learn how to avoid the common writing mistakes that can hold you back. This course can be taken alone or as part of the 3 course Certificate in Business Writing. Class Details 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 For more information, visit our question and answer page - Click Here.

For future and emerging leaders in Gen Y, discover the key concepts of being a leader and the best strategies for developing your leadership skills and influence. Learn the unspoken secrets leaders know and the strategies they employ/exhibit in for influencing others. This course can be taken alone or as part of the 3 course Certificate in Leadership Development. Class Details 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 For more information, visit our question and answer page - Click Here.

Understand the basics of HTML coding language. Learn to build simple web pages by hand coding, use HTML tags to create paragraphs, heading, lists, links, insert images and tables and more. Discover how to create a simple multi-page website with images, text and a navigation bar. This course can be taken alone or as part of the 3 course Coding Certificate. Class Details 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 For more information, visit our question and answer page - Click Here.

One of the most turbulent periods in brain development occurs during adolescence. The teen brain actually functions very differently from the adult brain. Understanding these complex changes can help calm the rough seas of the teen years, but also provide your teen with critical support and understanding that will promote better decision-making, better mental health, and better outcomes at school. Class Details Unit 1: Brain Development The BrainUnder Construction Hormones The Evolutionary Advantage Unit 2: How the Teen Brain is Different from The Adult Brain The pre-frontal cortex The Amygdala Risk-taking Unit 3: How Teens Make Decisions The Need for stimulation Emotions Problem-solving Behavior Unit 4: Your Teen at School Learning Strategies Technology Exercise Gender Differences 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.

Learn how to improve your communication with others, convey your ideas effectively, and improve your ability to understand what is important to those who don’t share your same style. Fee includes your own DiSC Behavioral Personality Profile assessment and review. This course can be taken alone or as part of the 3 course Certificate in Workplace Communication. Class Details: 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

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.

Whether you are an entrepreneur, running a family business, or just looking to advance your career and add to your skill set, this certificate will provide you with the knowledge needed to measure, and manage, the financial health of your business. Gain an understanding of cash basis accounting. This is a series of 3 courses: Spring 2024 Dates Summer 2024 Dates Understanding Debits and Credits 4/1/24-4/26/24 06/03/24-06/28/24 General Ledger and Month End Procedures 05/06/24-05/31/24 07/01/24-07/26/24 Closing Procedures and Financial Statements 06/03/24-06/28/24 08/05/24-08/30/24 For more information, visit our question and answer page - Click Here.

Discover what motivates each generation at work, what incentives they respond to, and what messages they value. Explore the current motivations of Boomers, Gen Xers and Gen Yers and what messages they value. Then identify practical, how-to tips and techniques for managing Boomers, Gen Xers, and Gen Yers in the workplace. This course can be taken alone or as part of the 3 course Management Certificate. Class Details Unit 1: What makes these generations different The transition from the Industrial Age to the Internet Age How society shapes us Who are the Boomers? Who are Xers? Who is Gen Y? Unit 2: Evolving standards of hard work and success Knowledge work and the value of time Time as key to profitability The focus on outcomes The problem with meetings A new type of leadership Unit 3: What motivates generations at work Monetary and non-monetary rewards Key role of the “boss” A balanced life Lateral career moves Second careers Supporting social causes Retirement reservations Unit 4: Work styles and technology Customizing work styles and processes Peak work time and place A new role for technology and work Working collaboratively Modern recruitment For more information, visit our question and answer page - Click Here.

Six Sigma professionals are in demand by organizations around the world. Our Green Belt training teaches participants problem-solving skills, using the DMAIC (Define, Measure, Analyze, Improve and Control) model. After completing this challenging course, Six Sigma Green Belts serve their organizations as a trained specialist able to work on Six Sigma projects that benefit the organization. This is a series of 3 courses. Spring 2024 Dates Summer 2024 Dates Introduction to Six Sigma Green Belt 4/3/23-4/28/23 06/03/24-06/28/24 Intermediate Six Sigma Green Belt 05/06/24-05/31/24 07/01/24-07/26/24 Advanced Six Sigma Green Belt 06/03/24-06/28/24 08/05/24-08/30/24 For more information, visit our question and answer page - Click Here.

Build revenue streams for your non-profit organization. Discover how to increase revenue from your current activities. Develop strategies for building new ones. Know how to effectively set prices or fees. Understand the 20% that generates 80% of your revenue. These basic concepts yield greater results. This course can be taken alone or as part of the 2 course Certificate in Nonprofit Administration. Class Details 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 For more information, visit our question and answer page - Click Here.

Designed for beginners, you will be speaking and reading Spanish in no time. Practice the basic building blocks of the language and common idiomatic expressions. Gain enough vocabulary and grammar for simple conversations, and learn how to ask and answer questions. Class Details Unit 1: The Alphabet: Vowels and Consonants Ser and Estar How to Ask Questions Vocabulary Unit 2: Colors, Countries and Numbers Colors Countries and Nationalities Numbers Unit 3: More Vocabulary Telling Time The Calendar More Vocabulary Unit 4: Expressions Tener: To have Vocabulary and expressions with tener Estar: To Be Unit 5: Conjugation Conjugation of Regular Verbs AR Verbs ER Verbs IR Verbs Unit 6: Irregular Verbs Hay Irregular Verbs Present Tense Stem-Changing Verbs Unit 7: The Near Future The Near Future Vocabulary Unit 8: Present Progressive More Ar Verbs Vocabulary Present Progressive For more information, visit our question and answer page - Click Here.

Discover Adobe Illustrator illustration software. Explore Adobe InDesign, the industry standard page-layout program that works with Adobe Illustrator and Photoshop seamlessly. Master Adobe Photoshop to effectively work with images. Software Requirements: Access to Adobe software tools required. For all online Adobe classes, students are responsible for purchasing their own software for their course. Trial versions of Adobe software are sometimes available on the Adobe company website. If you're taking the entire “Graphic Design certificate” you'll need Adobe Illustrator, Adobe Photoshop and Adobe InDesign. Otherwise you may sign up for a single software. More information on Adobe Creative Cloud software can be found at adobe.com This is a series of three classes: Spring 2024 Dates Summer 2024 Dates Adobe Illustrator Essentials 04/01/24-04/26/24 06/03/24-06/28/24 Adobe Photoshop Essentials 05/06/24-05/31/24 07/01/24-07/26/24 Adobe InDesign Essentials 06/03/24-06/28/24 08/05/24-08/30/24 For more information, visit our question and answer page - Click Here.