Karmvir Sharma Excel Expert
No reviews yet

I am expert. I can work on excel Very fast and Accurate. Boost your career/knowledge by gaining high-level knowledge of Advance MS Excel, Dashboards, Macros, VBA that helps you be a master at your work.My focus is to keep it extremely simple as it makes more sense. Provide hands-on expertise to real corporate world examples. I have various types of course structures for different people depending on their grasping speed. My style of teaching is based on practical questions as excel is something we can learn from books until we practice them.

Become a master of excel which is a necessity in the corporate world.

Topics Covered (short brief):-

1. Introduction to Excel
2. Mathematical Functions - Countifs, Sumifs, Sumproduct, Averageifs, round, COS, Subtotal, etc.
3. Text Functions and Data Validation- Conditional Formatting, Substitute, Concatenate, Filters, etc
4. Logical Functions - IF, AND, OR, Nested IF, etc
5. Lookup and Reference Functions - Index, Vlook - up, Hlook - up, Match, Offset, XLookup, Indirect, etc
6. Pivot- MIS, Data Analytics & Dashboards, Graphs, etc
7. Macros - Buttons, Strings, Recording, FORM Controls, ActiveX,
8. Loop in, WhatIF - Analysis, Creating Forms through VBA
9. Automating work with help of MACROS

Subjects

  • English Typing Expert

  • Excel (Advanced) Expert


Experience

  • SENIOR COMPUTER OPERATOR (Apr, 2016Present) at HISAR BOVINE SPERM STATION AND RESEARCH CENTER
    Excel Expert. Working as a excel expert from last 8 year in same company.

Education

  • BACHLOR OF ARTS (Apr, 2009Mar, 2012) from Kurukshetra University

Fee details

    400500/hour (US$4.725.90/hour)


Reviews

No reviews yet. Be the first one to review this tutor.