ADVANCED EXCEL

V Lookup and H Lookup Formulas

V Lookup & H Lookup Sheet to Sheet V Lookup & H Lookup Book to Book Match and Index Formulas

Match and Index Sheet to Sheet Match and Index Book to Book Auto Filter and Advanced Filter Sum if and Count if Formulas Count A & Count Blank Formulas Subtotal Functions and Formulas Creation of Pivot Table, Charts Refresh Data & Database Formulas Cell Conditional Formatting

Import Data from Access, Notepad Export Tables from Excel to Word Creation Customs List for Text

Text to Columns, Remove Duplicates Data Validation, Consolidate Tables Scenario Manager, Data Table

Goal Seek, Macros, Freeze Panes

Data and Number Series FillingDuration 30 DaysCreating Object, Creating Payrolls