Skip to content
89 Results

  • Designing Online Instruction

    Learn how to develop a web course, the principals behind the adoption of technology innovation, and the nature of the online learning environment. Get tips for planning your online course, identifying resources and design guidelines. Discuss the phases of design and development, motivating student-to-student interaction and how to manage it. Get the latest information on copyright issues, assessment and evaluation. This course can be taken alone or as part of the 3 course Certificate in Online Teaching. Agenda 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 guidelines 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 discussions Class size Copyright For more information, visit our question and answer page - Click Here.
  • Developing Your Leadership Skills

    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.
  • Developing Your Professional Career

    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.
  • Early Riser Group Fitness Blend *NEW

    A group exercise class led by a Certified Strength and Conditioning Specialist and Personal Trainer. This class will incorporate strength training, mobility, flexibility and cardiorespiratory conditioning, utilizing circuit training, free-weights, medicine balls and bodyweight exercises. Class modified for all fitness levels.
  • Effective Copywriting

    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.
  • Entrepreneurial Marketing

    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
  • Extraordinary Customer Service

    Transform your customer service into something extraordinary. Extraordinary customer service comes from focusing on the few essential elements that yield big results. Discover how easy it is to tweak your customer service from the ordinary to the extraordinary. Create a customer service plan that focuses on the key elements to get you started on your pathway to success. This course can be taken alone or as part of the 2 course Certificate in Customer Service. Class Details: 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: Marking Customer Service Extraordinary Tweaking the customer's experience Telling the world how great you are Having fun For more information, visit our question and answer page - Click Here.
  • Financial Analysis and Planning for Non-Financial Managers

    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.
  • Fostering Online Discussion

    Being engaged with online learners is one of the biggest weaknesses of online teachers. Come discover how to continually engage students and build student success through your interaction, feedback and communication. You will get first hand experience as your instructor models great interaction and engagement, plus you will come away with practical, how-to tips to better engage your online learners. This course can be taken alone or as part of the 3 course Certificate in Online Teaching. Class Details 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 For more information, visit our question and answer page - Click Here.
  • General Ledger and Month End Procedures

    In this course, you will learn how to post journal entries to the correct general ledger accounts impacted by each transaction. This course will show you how to make sure your general ledger balances at the end of each month by preparing an unadjusted trial balance. You will learn how to look for errors when you don’t balance, and how to determine to correct entries. After posting correcting entries and/or adjusting entries, you will verify debits and credits equal with an adjusted trial balance. This course also goes through the steps of performing monthly bank reconciliations. This course can be taken alone or as part of the 3 course Bookkeeping Certificate. Class Details: Unit 1: The General Ledger What is the General Ledger Why must the general ledger balance Posting to the general ledger Activity ~ Posting to The General Ledger Unit 2: The Unadjusted Trial Balance What is the unadjusted trial balance Verify debit and credit balances Finding errors Activity ~ Find The Errors Unit 3: Correcting Entries and Adjusting Entries Determine correcting entries Adjusting entries and how to prepare them Posting correcting entries and adjusting entries to the general ledger Activity ~ Preparing Entries and Posting to General Ledger Unit 4: The Adjusted Trial Balance Verify the accuracy of the adjusted trial balance Prepare monthly bank reconciliations Activity ~ Prepare a Bank Reconciliation
  • HR Aspects of Good Leadership NEW

    Explore key workplace laws and leadership enhancement skills that are needed in today’s work environment. Acquire the best methods to solve difficult situations and disruptive employees. Learn how to use company policies to set employee boundaries. Acquire the ability to detect and address threatening behavior. Come away with an understanding of how to employ rules and positive responses to create a worker friendly supportive environment. Agenda Unit 1 The Doctrine of Employment-At-Will The difference between federal & state employment-at-will laws. How at-will employment works in conjunction with the employee hiring, firing, disciplinary action & suspension process. Understanding employment-at-will violations (covenant of public policy, covenant of implied contracts, and covenant of good-faith and fair dealing). EEOC regulations that offer protection for employees in the workplace. Leadership actions that can work for, or against, company leaders if an employee files a claim/lawsuit. Unit 2 Effectively Dealing with Disruptors & Difficult Employees How to stop bad employee behavior before it gets out of hand. How to use company policies & work rules to set employee boundaries. How to effectively deal with workplace gossip, blame, narcissistic behavior, and passive-aggressive workers. Easy to learn skills, techniques & guidelines for successfully managing and addressing the most difficult employee personalities. Unit 3 Preventing Employee Threats & Threatening Behavior What constitutes threatening behavior in the workplace (implicit & explicit words/actions, open racial/religious prejudice, bullying, etc.). How to detect and address threatening behavior (against management or between co-workers). When to get HR and/or law enforcement involved. Properly documenting threatening incidents. Unit 4 Avoiding Complaints of Harassment, Retaliation & Unfair Treatment Do’s & Don’ts for effectively handling employee complaints & dealing with HR investigations. Liability issues for harassment & hostile work environment by supervisors/managers. Inappropriate work relationships that can create personal & legal issues for company leaders. Interpersonal skills that promote good leadership in today’s hectic legal-prone work environment. For more information, visit our question and answer page - Click Here.
  • HTML Fundamentals

    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.
  • Heartsaver Adult, Child & Infant CPR, First Aid & AED

    Students will learn the critical lifesaving skills needed to care for someone until emergency help arrives. Instruction includes Adult, Child & Infant CPR, First Aid and AED. Perfect for childcare providers, security officers, law enforcement, health and fitness instructors, students, parents, grandparents and anyone who wants basic knowledge to help save someone’s life!
  • How to Make Extra Cash Pet Sitting (after school/work) - Live Online

    Do you love animals…especially dogs? Learn how to make extra money after school or work by watching dogs or other pets, usually in the pet’s home. You will learn about feeding, watering, and exercising pets, how to make a good impression as well as what questions to ask when interviewing for a pet sitting job, and what to do when a dog has behavioral issues. You will also discover other services you can offer to make more money, such as dog walking, grooming, puppy training, etc. Informative handouts for future use are included in class fee. This class is taught by a seasoned professional pet sitter and a longtime entrepreneur. Your Zoom login link will be sent the day before class. If you do not see it in your inbox, please check your spam folder first for an email from the instructor at LeeAnne@KrusemarkGrinnell.com and/or ceregister@c-ischools.org, and then call us for an update if you haven't received it. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.
  • How to Outline and Write an Irresistable Romance - Live Online

    Romance is the #1 selling fiction genre. Whether you're a new or experienced writer, this comprehensive session will help you sharpen your skills with practical step-by-step advice. You will discover the different romance sub-genres and understand the proven romance formula. You will also learn to create a unique setting, introduce your protagonist (lead character), percolate friction, and write relatable dialogue as well as intimate scenes. Publishing options will also be discussed. Informative handouts for future use are included in class fee. The instructor LeeAnne Krusemark is a former journalist, current author and editor, and a nationwide Professor of Publishing at higher learning institutions, including Harvard Adult Education. Your Zoom login link will be sent the day before class. If you do not see it in your inbox, please check your spam folder first for an email from the instructor at LeeAnne@KrusemarkGrinnell.com and/or ceregister@c-ischools.org, and then call us for an update if you haven't received it. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies. .
  • How to Start any Home Business + 250 Home-Based Business Ideas - Live Online

    MOST POPULAR Course!!! Tired of working for someone else? Do you need to make more money? Turn your talents and hobbies into profits by starting a home business. Taught by a Chamber of Commerce Past President and award winning business owner, this is probably the most comprehensive business start up workshop you will ever find. You will discover: * more than 250 legitimate home business ideas * mandatory legal documentation * many ways to market your product/service * how to take tax deductions (this workshop included!) Informative handouts for future use are included in class fee. The instructor LeeAnne Krusemark is a former journalist, current author and editor, and a nationwide Professor of Publishing at higher learning institutions, including Harvard Adult Education. Your Zoom login link will be sent the day before class. If you do not see it in your inbox, please check your spam folder first for an email from the instructor at LeeAnne@KrusemarkGrinnell.com and/or ceregister@c-ischools.org, and then call us for an update if you haven't received it. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.
  • How to Write Your Life Story - Live Online

    You don’t need to be famous to have a legacy to leave behind. Create an inspirational autobiography for family, friends, and others. Learn how to recall vivid memories, analyze events and people that shaped who you are, and bring your story to life. Your handout, included in the class fee, will have an outline to help you organize and write your memoir step-by-step. Printing/publishing options will also discussed. The instructor LeeAnne Krusemark is a former journalist, current author and editor, and a nationwide Professor of Publishing at higher learning institutions, including Harvard Adult Education. Your Zoom login link will be sent the day before class. If you do not see it in your inbox, please check your spam folder first for an email from the instructor at LeeAnne@KrusemarkGrinnell.com and/or ceregister@c-ischools.org, and then call us for an update if you haven't received it. Questions about our class policies, weather cancelations or accessing online classes? Click here for our Class Info & Policies.
  • Implementing Your Strategic Plan NEW

    Move your career up with the 21st Century leadership skills of Strategic Planning. Every organization needs to position itself differently for success in this century. And only leaders can both create a successful strategic plan and oversee its implementation. Create a new leadership skill that will last a lifetime, and outlast industry and career changes. Come away with both the conceptual tools and a new leadership approach to move from dreams to reality for your organization, and your career. Agenda Unit 1 Think differently What Strategic Planning Is, and Isn’t Strategic Planning is What Leaders Do How to think strategically - - it’s different Why strategic plans fail Unit 2 The 6 Components of Strategic Planning Building the approach Constructing objectives Forming strategies Assigning tactics Unit 3 Needs assessment, Market research, Environmental scanning Finding trends and industry directions Scanning the environment An 8 Stage Model for Needs Assessment and Marketing Research Scoping out your competition for strategic planning Unit 4 Your Vision as a Leader Matching the market with your vision Never have one idea (and why) When hunches work, when they don’t Where do you want to go For more information, visit our question and answer page - Click Here.
  • Indoor Walking

    Summer Indoor Walking Walk the hallways of Cambridge-Isanti High School or Isanti Middle School at your own pace! You can register for this FREE recreational activity online or in person at the Education Services Center. All walkers must pick up their Walking Badge at the Education Services Center. This gives you access to the building. FREE!!! CIHS Walking: Starting Tuesday, June 10- August 7th (No walking on June 19th, July 1, July 3) Tuesdays & Thursdays: 9-11 AM & 4-7 PM IMS Walking: Starting Wednesday, June 11 - August 6th (No walking July 2nd) Wednesdays: 4-7 PM
  • Integrated Marketing Best Practices

    Enter the fascinating and emerging field of integrated marketing. Explore how to move potential customers from one media to another, increasing their interest and purchasing. Take home an Integrated Marketing Model to help you choose what’s best for your business and industry. This course can be taken alone or as part of the 3 course Integrated Marketing Certificate. Agenda 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 For more information, visit our question and answer page - Click Here.
  • Integrating Social Media in your Organization

    Learn the top five considerations when starting a social network as well as tips to manage an online community. Identify how to manage this influx of information created by the new media revolution. Discover what you might be doing wrong in social media as well as essential policies to have in place for your employees and company. This course can be taken alone or as part of the 3 course Certificate in Social Media For Business. Class Details Unit 1: Running a Community and Creating Your Own Social Network Using Ning Online Communities and Creating Your Own Social Network with Ning Top 5 Considerations When Starting a Social Network What Goes into Build a Great Social Network What is an online community manager What is Ning and How to Use the Platform Examples of Companies Using Ning Unit 2: What Tools to Use for Your Organization What tools and platforms will help get content on the web Readings on top new tools to consider How to select which tool to use How video fits into online marketing Organizing and collaborating with Google products How to take advantage of mobile and local in applications and search Unit 3: Integrating Social Platforms into Your Web Site Discovering how web design has changed and what is needed for true integration Understanding elements on websites that increase interaction, engagement, search engines findability Learn best practices for website usability and landing page design Discuss how your sites compare and generate next steps that will improve your business Unit 4: Developing a Manageable Work Flow: Time, Resources, Policies, and Trends Developing a Manageable Work Flow Time and Resources: How do you know where to spend your time? Target Social Media Influencers to Boost Traffic and Sales Is Your Company Ready for Social Media or Are They Holding You Back? Trends - What's Next or Are We Still Working on Last Year's Trends? Social Media Policies and Planning For A Crisis For more information, visit our question and answer page - Click Here.
  • Intermediate AI NEW

    Dive deeper into the fascinating world of artificial intelligence. Explore machine learning algorithms, natural language processing, and neural networks, while gaining hands-on experience with popular AI frameworks and tools. Take your AI expertise to the next level. Agenda Unit 1 AI Agents Deploy agents that handle tasks across apps seamlessly Explore Zapier or Microsoft Power Automate Email: Use Boomerang AI or Superhuman to automate and craft smarter, personalized emails Meetings & Social: Simplify scheduling with Calendly AI Assistant and manage social media using Hootsuite Insights Unit 2 Workflow Automation Streamline entire processes with Monday.com Use Asana AI for a more efficient workday Routine Tasks: Harness tools like IFTTT Automate repetitive actions across platforms Unit 3 Professional-grade Content Unlock your creativity and produce professional-grade content effortlessly Written Content: Generate compelling blog posts Writing captions with ChatGPT or Writesonic. Graphics: Design stunning visuals using Canva’s Magic Design or Adobe Firefly AI. Unit 4 Video & Music Video: Transform concepts into videos Using eTools Lumen5 or enhance editing with Runway AI. Music: Compose original tracks with AIVA Remix audio with tools like Amper Music. For more information, visit our question and answer page - Click Here.
  • Intermediate Data Analysis

    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: 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 variables 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 For more information, visit our question and answer page - Click Here.
  • Intermediate Excel

    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.