Microsoft Excel II
This 8 hour class will reinforce the elements introduced in Excel Level I and expand upon that base to include more complex but necessary activities. Upon completion, students will be able to find a specific entry in a worksheet, paste a dialog box, format cells in a dialog box, use absolute cell references, use financial functions (i.e. PMT function), use logical functions (i.e. IF function, nesting IF functions), use date/time functions (i.e. DATE/NOW function), create/modify charts, sort/filter records, link worksheets.