Excel Superstar

You will learn those topics Uses of complex Lookup Formulas such as OFFSET, INDIRECT in a simplified fashion with multiple application Hidden Tricks & Settings – Compare 2 Excel files, Split Text to Rows, Unpivot Columns Projects for Finance, and Sales Use of Cell Referencing ($) in formulas Fill intermittent black cells using Go To special The common mistake of Vlookup users Using SUMIFS to find the sum of values between two dates A hidden trick of COUNTIFS to do VLOOKUP for duplicate values A hidden trick of Consolidation using SUM for multiple sheets Fuzzy Lookup can do what VLOOKUP can't Hide a sheet so that no one can unhide easily? Why does a Date in Excel look like a random number? Rectify dates format using Text to Columns TRIM formula to remove excess spaces in a sentence Use SUMIFS & COUNTIFS with 3 criteria Basics of Macro

Course Details

Highlights

• Easy and understandable Language
• Learn Anywhere Anytime
• Experience & Qualified Teachers
• 1000 + Satisfied Learners
• Student Discussion Forum