Cambridge-Isanti Community Education

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.

Stay current with this class. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. Class Details 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 For more information, visit our question and answer page - Click Here.

InDesign allows you to create simple to complex multi-page documents such as brochures, flyers, books and magazines. Explore InDesign tools and capabilities to create professional documents. Learn how to manage the InDesign environment, create, setup, design, enhance and finalize multi-page documents. Access to Adobe InDesign software required This course can be taken alone or as part of the 3 course Graphic Design Software Essentials Certificate. Class Details Unit 1: Getting to Know the Interface and Setting up a Document Interface menus Tools Panels Starting and setting up a multi-page document in InDesign Unit 2: Working with Objects and Color Learning to work with color panels Creating, managing and applying color to elements Inserting and managing images and illustrations into an InDesign document Unit 3: Working with Text Learning about insert and flow text to multiple pages Managing long text documents Text editing in InDesign documents Unit 4: Typography Advance typography tools and menus Character and paragraph settings and styles Creating print-ready PDF files. For more information, visit our question and answer page - Click Here.

Learn Adobe Illustrator fundamentals to set up a print document and use various tools to draw, type and color all kinds of shapes and illustrations. Discover how to efficiently manage layers and artboards, and create print-ready PDF documents. Access to Adobe Illustrator software required. This course can be taken alone or as part of the 3 course Graphic Design Software Essentials Certificate. Class Details Unit 1: Getting to Know the Interface and Drawing Tools Interface menus, tools and panels. Working with various drawing and transformation tools Drawing anything from simple to complex shapes and illustrations. Unit 2: Working with Color and Text Working with color panels in the software Creating, managing and applying color and color groups Learning how to type and format text using various text formatting and styling tools and panels. Unit 3: Working with Layers and Pen tool Layers and layer management. Working with the Pen tool. Modifying a drawing using Pen tool options. Unit 4: Working with Artboards Creating and managing multiple Artboards Learning how to layout and design corporate package Business cards, letterhead and envelopes Creating print-ready PDF files 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

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.

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.

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.

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.

Games are increasingly recognized as a tool that can serve many business purposes beyond entertainment. Discover what goes into the design and development of both video and analog games, with a particular focus on the use of games outside of consumer entertainment. Take the first steps into understanding game design and how it can be applied in your field. This course can be taken alone or as part of the 2 course Certificate in Basic Game Design. Class Details: 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 For more information, visit our question and answer page - Click Here.