Excel Intermediate

About This Course
Learn the techniques for handling large spreadsheets. Use the Solver Add-In analysis tool, the conditional IF function, cell references linking formulas between worksheets, cell and range naming and using named ranges in functions, formatting and customizing charts, the VLOOKUP function and creating a basic macro to automate a regularly used process.

Course Requirements

• Flash drive required
• Students must activate their myNorthshore account prior to first class

Computers for Beginners

An ideal beginner's class from learning computer hardware basics to exploring Windows and Microsoft Office (including Word). Learn through hands-on sessions to open, close, size and switch between windows; create, edit, format, save and print a document. Build the necessary foundation for further study in computers. Knowledge of the keyboard is necessary. Students must activate their My Northshore account prior to first class. Please email professional@northshore.edu for directions or call (978) 236-1200.

QuickBooks for Small Business Success and Career Advancement

About This Course
This introductory course provides hands-on experience with the latest version of QuickBooks, focusing on essential skills for managing small business finances. Topics include setting up and managing a chart of accounts, creating and maintaining vendor, item, and customer lists, recording cash sales, invoicing, managing payments and deposits, performing bank reconciliations, and processing bill payments. You will also learn to generate reports and create graphs to visualize financial data. This course is ideal for those aiming to build foundational QuickBooks skills for professional or personal bookkeeping needs.

Course Requirements

• Basic computer and Windows knowledge
• Flash drive
• Textbook: QuickBooks Online by Patricia Hartley, MBA
• Students must activate their My Northshore account prior to the first class

CompTIA Certification Training: Network+, Security+ Get certified with CompTIA Network+ and Security+ through this all-in-one training course designed to build in-demand IT skills. Learn networking fundamentals like hardware, topologies, protocols, and the OSI model, along with key concepts such as TCP/IP, wireless, cloud computing, security, and troubleshooting—preparing you to build, manage, and maintain networks. The Security+ portion covers essential cybersecurity skills, including risk assessment, threat management, access control, and cryptography, helping you identify and mitigate modern security threats while earning a widely recognized certification. Prerequisites: A+ Certification and a minimum of 9-12 months of hands-on experience working in a junior network admin/network support tech job role. https://careertraining.ed2go.com/northshorecc/training-programs/comptia-certification-training-network-plus-security-plus-vouchers-included/

CompTIA TECH+ and A+ Designed for entry-level, this CompTIA Tech+ program covers core IT fundamentals, including hardware, operating systems, networking, programming, databases, applications, and security—providing a strong foundation for starting a career in IT. Prepare for the CompTIA A+ exams and boost your resume with a globally recognized certification that opens doors to entry-level IT roles like technical support and help desk positions. Gain hands-on skills in diagnosing and troubleshooting hardware, software, and connectivity issues, along with a strong foundation in networking and practical experience working with computer components. https://careertraining.ed2go.com/northshorecc/training-programs/comptia-certification-training-itf-a-plus-vouchers-included/

CISCO CCNA Routing and Switching The Cisco Certified Network Associate (CCNA) certification is the top associate-level certification for IT professionals. Each section of the Cisco CCNA certification training will help you master certification-based topics for Cisco networking, including network, switch, and routing fundamentals, IPv4 addressing and advanced routing, VLANs and Trunks, and spanning tree protocol. You will also gain expertise in security, wireless, and automation fundamentals. Not only will this CCNA course help you prepare for the CCNA 200-301 exam, but you will also be able to provide networking solutions to real-world applications. With your enrollment in this CCNA course, you will receive a CCNA exam voucher, which covers the cost to sit for the Cisco CCNA certification exam upon eligibility.

CompTIA Security+ with Exam Voucher Do your job responsibilities include securing network services, devices and traffic in your organization? If so, build on your knowledge and skills with CompTIA Security+ Certification to keep up with what today's job market demands. Learn security fundamentals, networks, and organizational security as you acquire the specific skills required to implement basic security services on any type of computer network. Course prepares you to take the CompTIA Security+ Certification Exam SY0-701 . Prerequisite: The exam is intended for candidates who possess Network+ certification and two years of experience in IT administration with a security focus. Course includes textbooks and exam voucher.

CompTIA TECH+ and A+: New! Designed for entry-level, this CompTIA Tech+ program covers core IT fundamentals, including hardware, operating systems, networking, programming, databases, applications, and security—providing a strong foundation for starting a career in IT. Prepare for the CompTIA A+ exams and boost your resume with a globally recognized certification that opens doors to entry-level IT roles like technical support and help desk positions. Gain hands-on skills in diagnosing and troubleshooting hardware, software, and connectivity issues, along with a strong foundation in networking and practical experience working with computer components.