Become an Excel Master! With features such as tracing and fixing errors, conditional formatting, and removing duplicative data, you can put your data to work for you instead of working for your data! You will learn how to:
    • Import external data, convert text to columns, remove duplicate rows of data, link and embed objects, export data and publish your worksheet or workbook to the web
    • Format your numbers with custom number formatting, apply conditional formatting based on rules or specialized conditional formatting, or create your own formatting rules
    • Use, name and manage ranges, and use the VLOOKUP function
    • Create, run, edit, and save Macros
    • Use data analysis tools to trace cell dependents, and trace and fix errors
    • Create, rearrange, and format a PivotTable, filter PivotTables with Slicers, and create a PivotChart
    • Summarize your data with list subtotals, nesting, advanced filters and data validation
    • Analyze your data with Goal Seek, Solver, creating and displaying scenarios, data tables and forecasting future values
    • Continue workgroup collaboration with features such as locking and unlocking cells, protecting a worksheet, tracking changes, encryption, and checking document compatibility and accessibility Lesson summaries and chapter review allow for quick review of concepts covered. Chapter quizzes are available to check your knowledge at the end of each chapter. Class ends with a project to use knowledge and skills gained throughout the day.

Additional Info:

Are you working with clients who have experienced trauma? Do you understand the cause of trauma and the long-term consequences but wonder what is next or what you should do now? This workshop will explore stages of healing, client self-care, interventions that work well with trauma survivors, and explore some of the popular trauma treatments. You will:
    • Identify the stages of healing and their meaning
    • Assess if a client is ready to reprocess trauma
    • Learn several interventions to use with trauma survivors
    • Engage the client in healing through incorporating self-care practices
    • Be introduced to the basics of several popular evidenced-based trauma treatments

Prerequisites: Course provides 4 contact hours for NYS Licensed Marriage and Family Therapists and Licensed Mental Health Counselors. Course provides 4 hours of continuing education credits for NYS Licensed Clinical and Master Social Workers.

You will review the D.A.S.A. act, look at the causes and effects of bullying on students and schools, and present ways to work with bullies and victims. Several models will be used to explain the needs of children who are bullied and what happens when these needs are not met. You will be challenged to look at your own backgrounds and assumptions about bullying and come up with strategies to prevent bullying in your classrooms, schools, and teams. Harassment, discrimination, and cyberbullying will also be highlighted. Please note: Sessions fill well before the registration deadline. Register early to guarantee your seat in a workshop. This course meets the six-hour DASA training requirements for teachers, school professionals, and coaches in New York State seeking certification.

Prerequisites: Where a license number is requested, please enter the last 5-digits of your Social Security number. It is required for the TEACH upload.

The six hour training is designed to meet the DASA requirements for teachers in New York State. The course reviews the DASA act, looks at the causes and effects of bullying on students and schools, and presents ways to work with bullies and victims. Several models will be used to explain the needs of children who are bullied and what happens when these needs are not met. Participants will be challenged to look at their own backgrounds and assumptions about bullying and come up with strategies to prevent bullying in their classrooms and schools. Cyber bullying will also be highlighted.

Additional Info:

Do you work with numbers and could use an extra hand? Excel is just the extra hand that you need! Through lessons and hands-on labs, you will learn the many shortcuts and tricks Excel has to offer to make quick time of your work. You will learn to:
    • Create, save, and navigate worksheets and workbooks
    • Enter and change data (text and number) and simple formulas
    • Use the sum feature, undo/redo, find and replace, and smart lookup
    • Edit your worksheet using ranges, flash fill, copy and paste, clipboard, drag and drop, insert and delete columns and rows, and change column width and row height
    • Format your worksheet with alignment and text wrapping, cell borders, cell shades, cell colors, merge and center cells, hiding and unhide rows and columns, and freeze and unfreeze rows and columns
    • Setup your worksheet for printing with defining print area, adjusting margins, setting page orientation and size, and inserting headers and footers
    • Insert formulas such as relative, absolute, and mixed references, copy formulas, and insert functions
    • Modify your workbook by adding, deleting, copying, renaming, repositioning, and grouping worksheets Lesson summaries and chapter review allow for quick review of concepts covered. Chapter quizzes are available to check your knowledge at the end of each chapter. Class ends with a project to use knowledge and skills gained throughout the day.

Additional Info:

Now that you’ve mastered the basics of putting to Excel to work for you, join us to discover how to visually display your data with graphs, charts, and graphics, and work collaboratively through workbook collaboration. You will learn how to:
    • Create and modify tables and charts
    • Add pictures, shapes, WordArt and SmartArt, and format drawing objects
    • Work collaboratively with others through emailing a workbook, converting worksheets to web pages, inserting hyperlinks, and viewing and editing comments
    • Use functions such as IF, Nested, PMT, FV and autocalculate
    • Understand date and time function, add date and date interval, subtract dates, and calculate time intervals
    • Create a workbook through a template, create and edit a template, and use and customize sparklines Lesson summaries and chapter review allow for quick review of concepts covered. Chapter quizzes are available to check your knowledge at the end of each chapter. Class ends with a project to use knowledge and skills gained throughout the day.

Additional Info:

Are you interested in the Certified Nursing Assistant training program, but in need of tuition support? Attend this Zoom info session to hear directly from organizations like CAPCO, Guthrie Cortland Medical Center, and Tompkins Workforce NY how you can apply for funding to cover your tuition!

Additional Info:

Are you interested in the Certified Nursing Assistant training program, but in need of tuition support? Attend this Zoom info session to hear directly from organizations like CAPCO, Guthrie Cortland Medical Center, and Tompkins Workforce NY how you can apply for funding to cover your tuition!

Additional Info:

Sexual violence is a pervasive problem, which remains hidden. Sexual violence is still often viewed as an individual problem, only being perpetrated by a handful of “bad people.” The reality is something quite different—sexual violence remains a pervasive problem mainly because we still hold on to stereotypes, attitudes, and belief systems that allow a culture of sexual violence to thrive. Sexual violence is not a problem to be dealt with only by victims and perpetrators, but by all of us if we are ever going to take real steps to end it. This workshop will define sexual violence as a community issue and demonstrate the impact on all of us, paying particular attention to our classrooms, workplaces, and communities at large. You will:
    • Define sexual violence
    • Learn the definition of consent
    • Recognize signs and symptoms of sexual violence
    • Understand how sexual violence hides in plain sight
    • Know how to intervene on behalf of survivors of sexual violence
    • Be able to identify and walk away with specific tools to intervene on behalf of victims

Prerequisites: Course provides 4 contact hours for NYS Licensed Marriage and Family Therapists and Licensed Mental Health Counselors. Course provides 4 hours of continuing education credits for NYS Licensed Clinical and Master Social Workers.

This is a short course on the key concepts of micro and nanofabrication. This course instructs students on the key concepts they need to understand in order to begin to fabricate semiconductor devices. The course includes in-person fabrication of practical devices.

Additional Info:

An increased use of technology in social work practice has led to some new emerging ethical challenges. Through critical thinking exercises, review of case studies/ethical dilemmas, and self-reflection activities, you will develop a deeper understanding of ethics in social work practice, and challenges and ethical guidelines for the use of technology. You will:
    • Identify key terms associated with professional ethics, NASW core values, technology standards, and ethical decision making
    • Increase your self-awareness by examining the relationship between personal/professional values, ethical use of technology, and professional role expectations
    • Identify the key ethical decision-making models, and discuss how these might be used in professional practice
    • Consider the existing socio-political context, and identify some of the predominant challenges that currently require attention in professional practice
    • Think about issues of diversity, social justice, and human rights in the context of ethical use of technology in practice

Prerequisites: Course provides 6 contact hours for NYS Licensed Marriage and Family Therapists and Licensed Mental Health Counselors. Course provides 6 hours of continuing education credits for NYS Licensed Clinical and Master Social Workers.

New York State law mandates many licensed professionals, teachers, and school administrators to complete a two-hour course regarding the identification and reporting of child abuse and maltreatment. You will learn: -how to identify and report child abuse/maltreatment -the statutory reporting requirements You must attend the full two hours of this workshop to fulfill NYS requirements for your certificate of completion.

Additional Info:

This workshop helps you prepare for the NYS test, and provides a comprehensive understanding of the role of the notary public. Confusing laws, concepts, and procedures are clarified in plain English. Examples are provided to illustrate situations the officer is likely to encounter, such as avoiding conflict of interest, maintaining professional ethics, charging proper fees, handling special situations, minimizing legal liability, and much more. Attendance at this seminar is a must for a notary public candidate to become fully aware of the authority, duties, and responsibilities involved. A common misconception is that merely passing the required exam adequately prepares an officer candidate to competently execute all duties. You also have access to a web page to post your notary related questions after the course.

Additional Info:

This workshop helps you prepare for the NYS test, and provides a comprehensive understanding of the role of the notary public. Confusing laws, concepts, and procedures are clarified in plain English. Examples are provided to illustrate situations the officer is likely to encounter, such as avoiding conflict of interest, maintaining professional ethics, charging proper fees, handling special situations, minimizing legal liability, and much more. Attendance at this seminar is a must for a notary public candidate to become fully aware of the authority, duties, and responsibilities involved. A common misconception is that merely passing the required exam adequately prepares an officer candidate to competently execute all duties. You also have access to a web page to post your notary related questions after the course.

Additional Info:

A primary role of supervisors is to help establish a workplace environment in which employees are engaged, motivated, and supported. A “coaching” approach to supervision allows for individual growth, while enhancing a teamwork ethic. In this training, we will explore valuable techniques such as motivational interviewing, courageous communication, emotional intelligence, and “learning on the edge,” among others. The format of the training will allow for large and small group discussions, case scenarios, and activities reflective of the most common workplace challenges. You will:
    • Become familiarized with the technique of motivational interviewing as it pertains to employee efficiency and productivity
    • Learn strategies for effective communication, particularly in regards to confronting problematic issues
    • Learn how what were once believed to be “soft skills” like emotional intelligence are, in fact, critical components of the workplace environment
    • Employ support strategies designed to challenge and promote growth