IIT Jodhpur graduate with 2+ years Excel experience and certified in "Excel Skills for Business specialization" from Macquarie University.
Technical Skills –
• Data entry, cleaning, organization, basic functions, filtering, sorting, conditional formatting, named ranges
• Print Preview, Orientation, Margins and Scale, Page Breaks, Print Titles, Headers and Footers
• Multiple Worksheets, 3D Formulas, Linking Workbooks, Consolidating by Position and Category (Reference).
• Logical Functions: IF, AND, OR, Nested Ifs, IFERROR, IFNA, COUNTIFS, SUMIFS, Sparklines, Advanced Charting, Trendlines.
• Pivot Table, Pivoting Charts, Pivoting Slicers, Pie, Column and Line Charts
• Data Validation, Drop-down Lists, Advanced Conditional Formatting.
• CHOOSE, Range VLOOKUP, Exact Match VLOOKUP, Dynamic Lookups: INDEX, MATCH.
• Error Checking, Evaluate Formula, Watch Window, Trace Precedents and Dependents.
• Modelling Functions: SUMPRODUCT, Data Tables, Goal Seek, Scenario Manager, Solver.
• Macros, VBA.
Soft skills you can expect from an IITian –
• Critical thinking, problem-solving, analytical skills.
• Detail oriented, accuracy and precision.
• Statistics
• Business communication