Introduction of MS Office

• Sum Series
• Count Series
• Average Series
• How to Activate Fill and Drag Option
• Rand and Rand Between Formula
• Transpose Function
• Payroll
• Logical Function
• Lookup
• Vlookup
• Hlookup
• Index Formula
• Match Formula
• Vlookup with Match
• Hlookup with Match
• Index with Match Function
• Image Lookup
• First Name and Last Name
• Concatenate Formula
• Loan Emi by using PMT Formula
• Drop Down List
• Pivot Chart and Pivot Table
• Double Vlookup
• Freeze panes
• Sort and Filter
• Salary Slip
• Conditional Formatting
• How to Protect Worksheet (password)
• Absolute and Relative Reference In Excel
• What If Analysis – scenario manager, goal seek, data table
• Xlookup Formula