Advanced Excel

•If Function

•If with Calculations

•Excel COUNTIF

•How to use the COUNT,COUNTIF & COUNTIFS function.

Excel SUMIF

•How to use the SUMIF & SUMIFS function.

•Excel Macros

•How to access Macros

•How to record a Macro

•How to run/execute a Macro

•Excel VLOOKUP

•How to Use the VLOOKUP function

• Pivot Table