Excel for Beginners A basic, useable knowledge of Excel, including designing, creating and editing a spreadsheet to analyze and display data used to make business and/or personal decisions. Methods will include creating formulas, functions and charts to analyze and present information. Use relative and absolute cell references to speed up your work. Must have some experience with Windows and keyboard. Flash drive required: Students must activate their My Northshore account prior to first class.

Word for Beginners Learn to create, edit, and format professional looking documents that stand out and clearly state your ideas. Set margins and line spacing. Use the clipboard to cut, copy and paste text within a document or from one document to another. Learn how to use Font, Paragraph and Page Layout features to make your document look the way you want it and to add pictures, tables and text boxes to your document. Use the Spell Check and Auto-Correct tools to help make sure your document is free of errors. Must have some experience with Windows and keyboard. Flash drive required: Students must activate their My Northshore account prior to first class.

Computer: An Introduction 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.

PowerPoint Create professional looking overheads, slides, signs and on-screen presentations. Explore creating, viewing, editing and formatting through the use of fonts, color, clipart, and drawing tools. Review bar graphs, pie graphs, and organization charts. Flash drive required. Must have some experience with Windows and the keyboard. Students must activate their My Northshore account prior to first class.

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.

Word Intermediate Learn to align text in your document correctly using the Word Ruler to set tabs and indents. Create, sort, and modify tables, use format styles, work with section breaks to create multiple column and margin layouts within a document, insert and control pictures. Create headers and footers with auto page, numbering. Make and use Templates for documents you use regularly. Prerequisite: Completion of Word for Beginners or equivalent experience. Flash drive required: Students must activate their My Northshore account prior to 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.