Workforce Development and Community Education: Fall 2021

Visit us online at www.sunywcc.edu/wdce | 16 CAREER & WORKFORCE TRAINING WORKSHOPS FOR TODAY’S WORKPLACE REMOTE Constructing Microsoft Excel Formulas Learn how to build complex formulas, use functions, and combine them in powerful ways. Covers using absolute and relative references in formulas and the order of precedence of operations. Prerequisite: MS Excel Introduction or equivalent experience. CE-COMP 2052, 2 Tues., Sept. 21 & 28, 6:00-9:00 pm, $155. #83871 REMOTE Excel Dashboards Excel Dashboards track complex data in one visual, dynamic, interactive, central, and compact sheet. Learn to build dashboards that simplify data analysis and enhance decision-making. Prerequisite: MS Excel Intermediate or equivalent experience. CE-COMP 2170, 2 Wed., Nov. 3 & 10, 6:00-9:00 pm, $155. #83872 IN-PERSON Using PivotTables in Excel A PivotTable is an interactive table that automatically extracts, organizes, and summarizes your data, making it easier to analyze. If you work with large data sets, PivotTables can help you make comparisons, detect patterns and relationships, and analyze trends with ease. Prerequisite: MS Excel Intermediate or equivalent experience. CE-COMP 2086WP, 1 Tues., Oct. 12, 9:00 am-1:00 pm, $88, Computer Lab. #83873 REMOTE Create a Powerful Profile with LinkedIn LinkedIn is the world’s largest professional networking site and is a valuable tool for creating and maintaining a list of contacts with others. Job seekers, employers, and those looking for business opportunities all benefit from the power of LinkedIn. Find out how to improve your profile to be most effective and how to navigate LinkedIn. CE-COMP 2099, 2 T/Th, Oct. 5 & 7, 6:00-8:00 pm, $88. #83874 REMOTE LinkedIn Individual Session LinkedIn, the world’s largest professional networking site, is a valuable tool for creating and maintaining a list of professional contacts. Job seekers, employers, and those looking for business opportunities all benefit from the power of LinkedIn. Work on your profile with our expert consultant. Email Michele.Maya@sunywcc.edu to schedule your individual 2-hour session for $180 or 3-hours at $260. REMOTE Zoom: Enhancing Your Online Experience As we continue to work remotely, and organizations integrate Zoom into everyday life, this workshop will combine how to use the technology with best practices for facilitators. This course will cover: installing the Zoom client for meetings, scheduling a meeting, configuring audio and video, meeting controls, such as muting all participants, using chat, breakout rooms and polls, sharing your screen, co-host controls, how to record your Zoom meeting, what to do with the recorded files, and more! CE-COMP 2237, 2 T/Th, Oct. 5 & 7, 6:00-9:00 pm, $155. #83875 ACCOUNTING & FINANCE Bookkeeping with QuickBooks and Excel Non-Credit Certificate Earn this non-credit certificate by completing our QuickBooks Fundamentals class, Microsoft Excel—Introduction, Intermediate, and Advanced classes (page 14), and Accounting & Bookkeeping 1 (page 3). Apply for the certificate upon completing all requirements. QuickBooks Fundamentals Debits, credits, journals, ledgers...having a working knowledge of the principles behind the bookkeeping capability of QuickBooks will simplify your mastering of this software. The goal is to understand the “behind the scenes” of how business transactions are correctly recorded and how QuickBooks handles them. Then learn how to handle accounts payable and receivable, customer info, inventory, and track your business’s financial health. These sections are open to all students but are particularly suitable for those who have some previous experience with bookkeeping. Prerequisite: File Management or equivalent experience. CE-COMP 2013, $595 (+ textbook). REMOTE Sec. A: QuickBooks Online (QBO) (PC & Mac Compatible) Version: 10 T/Th, Oct. 5-Nov. 4, 5:30-8:30 pm. #83876 IN-PERSON Sec. B: QuickBooks Desktop 2021 (PC Only) Version: 10 M/W, Oct. 18-Nov. 17, 9:00 am-12:00 noon, GTW-209. #83877 Professional Bookkeeping with QuickBooks Get full details at careertraining.ed2go.com/sunywcc COMPUTER PROGRAMMING REMOTE Computer Programming 101 Whether you’re new to the world of programming or you just need a refresher, this course is for you. The course will introduce programming and problem solving in a high-level language. Topics covered include basic data types, operators and expressions, control structures and loops. No previous programming experience required; basic typing and computer skills are required. CE-COMP 2217, 6 M/W, Sept. 20-Oct. 6, 6:00-9:00 pm, $403 (+textbook). #83879 REMOTE Introduction to Python Programming This course will give you an understanding of basic programming concepts as implemented in Python. Topics include data types, assignment and conditional statements, basics of flowcharts and analysis. No previous programming experience is required; basic typing and computer skills are required. CE-COMP 2140, 6 M/W, Oct. 11-27, 6:00-9:00 pm, $403 (+textbook). #83880