Advanced Excel Trainer

About the work from home job/internship

Selected intern's day-to-day responsibilities include

1. Conduct engaging training sessions on Advanced Excel.

1. Teach practical Excel applications using real-world business scenarios.

1. Develop lectures and projects.

1. Guide learners on data analysis and reporting techniques.

1. Update course content based on industry best practices and latest Excel features.

Topics to be covered:

1. Advanced Formulas and Functions (VLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, etc.)

1. Pivot Tables and Pivot Charts

1. Data Validation and Conditional Formatting

1. Dashboard Creation and Data Visualization

1. Power Query

1. Power Pivot

1. Lookup and Reference Functions

1. Data Cleaning and Transformation

1. What-If Analysis

1. Excel Automation and Macros (VBA preferred)

1. MIS Reporting and Business Analytics

Skill(s) required

Advanced Excel Data Analysis Data Visualization Effective Communication MIS MS-Office Power Query Presentation skills Teaching

Who can apply