Advanced Excel

Ms Excel

• Sum Ifs And Countifs
• Sum product
• Dsum, Dcount, Daverage
• Isnontext, Is blank, Is Text
• And, Or
• Flash Fill
• Arrange, Scale to fit,
• Sheet options, Page setup
• Formatting
• Index, Match Etc.
• Pivot Table And Pivot Chart, Various Methods and Options
• Subtotal & Grand total
• Vlook Up & Hlookup
• Data Validation , Creating Drop Down List
• Goal Seek
• Hyperlink
•  “If” Conditions
• Name Manager
• Advance Filter
• Scenario Manager
• Quick Access Tool Bar
• Formula Auditing
• Conditional Formatting
• Subtotal, Group, Ungroup
• Data Table
• Remove Duplicates
• Protect Work Sheet , Work Book
• Consolidation
• Watch Window
• Excel Options, Customizing the Quick Access Tool Bar
• Text To Columns
• Custom Views
• Illustrations
• Comment
• Paste Special
• Track Changes