INF121 Excel Intermediate
Learn the techniques for handling large spreadsheets such as freezing column and row headings so labels don't scroll off the screen. 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.
Prerequisite
Completion of Excel: Level 1 or equivalent experience.