Seasoned Microsoft Excel and PowerBI Trainer with a sound understanding of needed traits for workplace success and a strong ability to train employees in improving their skills.
Proven experience in training students from different streams with an eye on job readiness as they enter the corporate world
· Logical Functions – If, Nested If, Count If, Sum If, etc.
· Basic Formulas – Vlookup, Hlookup, Data Representation (Pivots & Charts), etc.
· Intermediate Formulas – Protecting/Unprotecting Sheets, Sumproduct, offset indirect, etc.
· Advanced – Lookup Method, Advanced Vlookup formulas – Index Match, Reverse/Dynamic/Nested Vlookup, etc.
· Macros – Basic Automation (Recording Macro, Assigning Macro Buttons, Basic VBA Codes, etc.
· Dashboard and Visualization in PowerBI
· Dashboard and Visualisation using POwerQuery, PowerPivot and PowerView for Excel