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.

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.

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