Krishan

Rate $3
Response 1h
Students
Number of students Krishan has accompanied since arriving at Superprof
2
Number of students Krishan has accompanied since arriving at Superprof

$3/hr

See Computer Skills tutors

This teacher is currently unavailable

Computer Skills
Microsoft Excel
Web development
Gmail
Mail

Want to get a job as an MIS-Executive / Work Force Management. Join me I'll teach you, guide you and provide you some job openings as well.

Computer Skills
Microsoft Excel
Web development
Gmail
Mail

Lesson location

- online

About Krishan

I am an Advanced Excel Professional with a passion for turning raw data into actionable insights. My journey in the world of Excel started as a necessity and quickly evolved into a fascination. Over the years, I have honed my skills to become a proficient data wizard, able to tackle complex problems, streamline processes, and create dynamic dashboards that drive informed decision-making.

Skills and Expertise:

Advanced Formulas: Proficient in creating complex formulas and functions, I can swiftly perform data calculations, analysis, and modeling to extract valuable insights.

Data Visualization: My forte lies in crafting visually compelling charts, graphs, and pivot tables to present data in a clear and understandable format.

VBA (Visual Basic for Applications): I am skilled in creating and automating Excel macros to streamline repetitive tasks, enhance efficiency, and create customized solutions.

Data Analysis: I have a keen eye for data trends, outliers, and anomalies, and I can transform raw data into meaningful information.

Data Cleansing: I am adept at cleaning and structuring data, ensuring accuracy, consistency, and reliability for analytical purposes.

Power Query and Power Pivot: I can seamlessly handle large datasets, creating relationships, and performing advanced data transformations using these powerful Excel features.

What-If Analysis: Proficient in conducting scenario analysis, goal seeking, and Monte Carlo simulations to assist in decision-making.

Data Integration: I can combine data from various sources, ensuring a holistic view of information for comprehensive analysis.

Dashboard Creation: I specialize in developing interactive and user-friendly dashboards that provide at-a-glance insights.

Data Validation: I ensure data integrity by setting up validation rules, drop-down lists, and other constraints.

Efficiency Enhancements: I'm known for improving Excel performance, automating reports, and reducing manual workloads.

Advanced Functions: I am skilled in using advanced functions like INDEX-MATCH, SUMPRODUCT, and array functions for complex data manipulations.

About the lesson

You will get to know about Basic excel, Advance Excel, Vlookup, Hlookup, Sumproduct, Concatenate, Conditional Formatting and many other features of Excel.
After the course I'll share you some pro tips and job openings as well.
Don't wait contact me for this opportunity.

Want to get a job as an MIS-Executive / Work Force Management. Join me I'll teach you, guide you and provide you some job openings as well.

Lesson location

About Krishan

About the lesson

Rates

Rate

Pack prices

online

Similar Computer Skills tutors in New Delhi

Dr Pooja

Callum

Jake

Arun

Irene

Lovepreet

Vanya

Yatender

Fortunate

Chiri

Aarav

Gene

Twisha

Hiyori

Ganna

Liviya

Priyankush

Sven

Carol

Raj

Want to get a job as an MIS-Executive / Work Force Management. Join me I'll teach you, guide you and provide you some job openings as well.

Lesson location

About Krishan

About the lesson

Rates

Rate

Pack prices

online

Similar Computer Skills tutors in New Delhi

Dr Pooja

Callum

Jake

Arun

Irene

Lovepreet

Vanya

Yatender

Fortunate

Chiri

Aarav

Gene

Twisha

Hiyori

Ganna

Liviya

Priyankush

Sven

Carol

Raj

Share

Verified qualification

levels

All languages in which the lesson is available

Reviews

Reviews

Recommendations

free lessons

Report this listing