Ankur Sharma MS Excel Basic, MS Excel Advanced, Power Query
No reviews yet

✅ I am a 5 STAR RATED . . CERTIFIED MS Excel Trainer.

Please contact Me for Assignments in MS Excel:
• Training - Online & Offline - excluding VBA
• Macro/Automation - includes Excel, VBA, Power Query
• Dashboard/Report
• Modelling
• Templates
• Formula

✅ I assure . . You will be thoroughly satisfied:
✓ With My Efforts
✓ With My Commitment to Excellence

✅
✓ My Training is completely practical.
You solve questions . . to learn the concepts.
✓ Especially in Advanced Excel Training . . I have an impressive question bank.
✓ I am available all days of the week . . from IST 8:30 a.m. to IST 10:30 p.m.
*IST = Indian Standard Time
✓ (if You have the latest Microsoft 365 Version) Includes the latest Microsoft 365 features.

Subjects

  • MS Excel Beginner-Expert

  • Power Query Beginner-Intermediate

Experience

  • MS Excel - Freelancer (Jul, 2019–Present) at MS Excel - Freelancer
    TRAINING:
    1. Basic MS Excel
    2. Advanced MS Excel
    3. MS Excel Power Query User Interface

    PROEJCTS:
    1. Basic MS Excel
    2. Advanced MS Excel
    3. MS Excel Power Query User Interface
    4. MS Excel Power Query M Language
    5. MS Excel VBA

Education

  • Bachelor of Commerce (Jun, 2001–Jun, 2004) from Lucknow Christian college

Fee details

    ₹500–1,000/hour (US$5.90–11.79/hour)

    Fees is different for:
    1. 1-on-1 Training
    2. Group Training - 1/2 day, 1 day, long-term
    3. Projects

Courses offered

  • MS Excel - Foundation

    • ₹9000
    • Duration: 20 Hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: Hindi, English
    • Certificate provided: Yes
    Topics include the in-built functionalities . . such as:

    1. Filter

    2. Remove Duplicates

    3. Sort
    i. Sort by Cell Values, Cell Colour, Font Colour, Cell Icon
    ii. Custom Sort
    iii. Multi-level Sort

    4. Freeze Panes

    5.
    i. New Window
    ii. Arrange All

    6. Conditional Formatting

    7. Data Validation

    8. PivotTable

    9. Protect
    i. Protect Worksheet
    ii. Protect Workbook
    iii. Password Protect
    iv. Open as Read-only

    . . etc.

  • MS Excel - Advanced

    • ₹11000
    • Duration: 25 Hours
    • Delivery mode: Online
    • Group size: Individual
    • Instruction language: English, Hindi
    • Certificate provided: Yes
    Topics include:

    1.
    i. VLOOKUP
    ii. Nested VLOOKUP

    2. MATCH

    3. INDEX

    4. $

    5.
    i. IF
    ii. Nested IF
    iii. SWITCH

    6. SUMIFS

    7. AVERAGEIFS

    8. COUNTIFS

    9. Data Visualization
    i. Dashboard
    ii. Charts
    iii. Interactive Charts

    . . etc.

Reviews

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