Abhishek Singh

"Excel Wizard: Unlocking Data Magic with Interactive Problem-Solving"

4.8(32)

Free trial in 24 hr

Loading...
Profile photo of Abhishek, Computer Science tutor at Wiingy
Profile photo of Abhishek, Computer Science tutor at Wiingy
Profile photo of Abhishek, Computer Science tutor at Wiingy
Profile photo of Abhishek, Computer Science tutor at Wiingy

Show all photos

tutor-image
tutor-image

Abhishek Singh

Masters degree

Enroll after the free trial

Each lesson is 55 min

50 lessons


20% off

/ lesson

30 lessons


15% off

/ lesson

20 lessons


10% off

/ lesson

10 lessons


5% off

/ lesson

5 lessons


-

/ lesson

1 lessons


-

/ lesson

Abhishek - Know your tutor

My focus is to keep it extremely simple as it always 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 cannot learn from books until we practice on practical examples. 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, Vlookup, Hlookup, 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

Learner for programming class

All Levels icon

All Levels

College icon

College

School icon

School

Adult / Professional icon

Adult / Professional

Programming class overview

My focus is to keep it extremely simple as it always 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 cannot learn from books until we practice on practical examples. 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, Vlookup, Hlookup, 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

Flexible Scheduling

Allows 1h early scheduling

Allows 1h early rescheduling

Can wait for 20 mins after joining

propsition image
Refund icon

10 day Refund

Swap icon

Free Tutor Swap

tutorFooter

Coding tutors on Wiingy are vetted for quality

Every tutor is interviewed and selected for subject expertise and teaching skill.