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

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.

Computers for Beginners: About This Course An ideal beginner's class from learning computer hardware basics to exploring Windows and Microsoft Office. 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. Entry Requirements Knowledge of the keyboard is necessary to be successful in class. Students must activate their My Northshore account prior to first class. Please email professional@northshore.edu for directions or call (978) 236-1200.

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.

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