• Logical Functions: If nested ifs, complex if and or Functions
• Data Validation: Manage primary & secondary axis
• Lookup Functions: Vlookup / Hlookup, Index & match, Nested Vlookup
• Worksheet Linking using indirect
• Vlookupwith helper coloumn
• Pivot Tables: Creating, Advance value field settings, Grouping based on numbers and dates, Calculated Fields and items, Array functions, Using Array Formulas, Array with if, len and mid functions formulas, Array with lookup Functions
• Chart & Slicers: Pie Chart, Bar Chart & Line Chart etc., Filter Data using slicers, Manage primary & Secondary Axis.