Advanced Microsoft Excel

Duration: 2 days

• Excel Cell References

• Statistical Functions

• Logical Functions

• Date & Time Functions

• Advanced Conditional Formatting

• Advanced Sorting & Filter

• Data Validation

• Collaborating data from other applications

• What if Analysis

• Understanding error & Functions

• Lookup Functions

• Vlookup Functions

• Hlookup Functions

• Match Functions

• Index Functions

• Combining all these Functions

• Xlookup Function

• Filter Function

• Table, Pivot Table, Pivot Chart