Excel Superstar

The Excel Mastery Program Bundle is a powerful combination of the Excel Mastery and VBA Mastery Program designed to equip with you perfect knowledge and actual application in daily aspects of Excel business usage. You will learn those topics and methods which others do not teach. For example: 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 Examples of why we need VBA Macros How can you get started with minimal coding and see results? Then, gradually, we move towards the essential theory, which is explained in a day to day language.

Course Details

Highlights

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