Basic Excel spreadsheet skills are a prerequisite to take this class. Students will learn how to use advanced functions and arguments as well as how to work with databases.
Use Function/Financial/Logical Functions Use Date Function/Revise Formulas Use Vlookup/Hlookup/If & Nested IF And/Or Condition with IF Round Function Use/Create/Modify a Database Data Validation Creating Subtotal in a List View a Data Form/Records
Define Criteria Enabling AutoFilter AutoFilter to Fliter a List Create a Custom AutoFilter Disabling AutoFilter Work with Data Series Create a Linear Series Create a Data Series Using a Stop Value
