Excel Advanced This course covers Excel Database and Table Features including importing data, sorting and filtering, Excel Table features, Input Forms, creating and using a PivotTable Report, counting functions, conditional counting and summing, financial functions PMT and PV and Editing a macro in the Visual Basic Editor. Flashdrive required. .Students must activate their My Northshore account prior to first class.

Bookeeping & Payroll Manager: ed2go GES2050 Master QuickBooks Online to prepare for an entry-level position as a full-charge bookkeeper. Learn to balance books, track finances, and administer pay for small businesses. Learn how to utilize QuickBooks Online for everyday bookkeeping; general ledger, chart of accts, inventory mgt. Then learn principles of payroll management; classifying workers, calculating overtime pay, and overseeing payroll functions, and year end forms. Once you complete this course, you will understand how to get your finances in order and be prepared for the QuickBooks Certified User Exam. You will also be ready to pass the Fundamental Payroll Certification exam, developed by the American Payroll Association.

Professional Bookeeping with Quickbooks Online ed2go GES2046 Master QuickBooks Online to prepare for a rewarding career in the booking field. Learn basic bookkeeping and accounting principles, including the types of accounting information you, the business owner, manager, bookkeeper, or accountant, need to monitor. Use QuickBooks Online to enter and track your finances, your files will be available to you virtually anytime, anywhere. Hands-on experience recording income and expenses to entering checks and bank transfers to setting up a chart of accounts. Reconcile your acct., manage cc and loan payments, create and print invoices, receipts, and statements, create estimates, generate reports, more. Prepare for the QB certified user exam.

Project Management Professional Exam Prep with Organizational Leadership Online This course will provide experienced project managers with the knowledge and skills necessary to successfully complete the Project Management Institute’s nationally recognized Project Management Professional (PMP) exam. This credential is considered the standard of excellence in the field of project management and is often a required credential in the field. This comprehensive course will use learning activities, practice exams, and assignments to help students prepare for, and successfully complete, the PMP exam. https://nscc.theknowledgebase.org/search/catalog/course-description/Project-Management-Professional-Exam-Prep-with-Organizational-Leadership/910/146

About This Course
Designed to provide knowledge and understanding of real estate principles and practices necessary to qualify for a position as a real estate salesperson. Prepare for the Massachusetts Real Estate Salesperson's Examination. Learn state required content including property, contracts, closing, financing, brokerage, housing, zoning, appraisal, Massachusetts license law, and real estate math. This course is taught by a Massachusetts certified instructor.

Attendance Requirements
Students must attend all 40 hours of class to receive their certificate of completion to sit for the exam.

Required Textbooks
Please purchase both of these texts prior to the first class meeting from the retailer/bookseller of your choice.

• Dearborn Modern Real Estate Practice, 21st Edition, Comprehensive Guide on Real Estate Principles, Practice, Law, and Regulations (Dearborn Real Estate Education)
• Massachusetts Real Estate Practice & Law, 11th Edition: Includes updated MA Laws & Regulations

Microsoft Office Associate Learn to use the Microsoft Office Suite (Word, Excel, PowerPoint, Outlook) from beginner to advanced level. Build expertise through hands-on exercises, in-depth materials, supplemental video demonstrations, and quizzes and exams. Must be familiar with a PC, Windows, and able to launch and close programs, and manage digital files and folders. Must be taken on a PC with MS Office 365 or 2021, Macs and Chromebooks are not compatible, access to email. Prerequisites: Familiarity with a PC and in a Windows environment. You must also be able to launch and close programs, navigate to information stored on the computer and manage electronic files and folders. https://careertraining.ed2go.com/northshorecc/training-programs/microsoft-office-specialist-associate-certification-training/

Certified Payroll Professional (CPP) Test Prep The Certified Payroll Professional (CPP) Test Prep is designed to help payroll professionals prepare with confidence for the Certified Payroll Professional (CPP) Exam the industry’s premier credential for experienced payroll practitioners. Whether you're a seasoned payroll expert or a manager seeking to validate your knowledge, this course provides the comprehensive instruction, tools, and strategies you need to succeed. This course offers expert guidance, in-depth review sessions, and targeted practice materials to strengthen your understanding of complex payroll topics. You will gain the confidence and knowledge to approach your exam with assurance. By the end of this course, participants will be able to: 1. Perform advanced payroll calculations to ensure accuracy and compliance 2. Interpret and apply complex payroll laws and regulations 3. Navigate challenging topics such as benefits administration, third-party sick pay, and involuntary deductions 4. Understand federal taxation, withholding, and reporting requirements 5. Prepare strategically for the CPP exam using proven study and testing techniques Designed for experienced payroll professionals preparing for the CPP exam, payroll or HR managers and supervisors seeking to validate their expertise. and professionals aiming to advance their careers in payroll management. Course fee covers textbook and materials.

QuickBooks for Small Business Success and Career Advancement 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: 1. Basic computer and Windows knowledge is required. 2. Flash drive. 3. Textbook: Please visit https://www.lablearning.com/QBO-Comp-2024-2025-Print.html to order textbook. 4. Students must activate their My Northshore account prior to the first class.