Excel Intermediate 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. Flash drive required: Students must activate their My Northshore account prior to first class.

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 www.SHOPNSCC.com to order the required textbook. 4. Students must activate their My Northshore account prior to the first class.

Real-World Bookkeeping and Accounting Skills for Business and Career Success

This introductory course provides a foundational understanding of bookkeeping and accounting, focusing on the complete accounting cycle. You will learn how to analyze and record financial transactions using debits, credits, and T accounts. Key topics include posting transactions to the journal and ledger, preparing trial balances, making necessary adjustments, and generating financial statements. By the end of the course, you will have a working knowledge of essential accounting principles and be able to accurately track financial activities for a business. Instructor-led virtual or in-person classes are available. Please refer to the schedule for more details.

Course Requirements: 1. Basic computer and Windows knowledge is required. 2. Flash drive. 3. Textbook: Please visit www.SHOPNSCC.com to order the required textbook. 4. Students must activate their My Northshore account prior to the first class.

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.