logo

Akansha Sharma

"Excel Wizard: Transforming Data into Insights with Hands-On Projects"

4.8(32)

Free trial lesson

Profile photo of Akansha , Data Science tutor at Wiingy
Profile photo of Akansha , Data Science tutor at Wiingy
Profile photo of Akansha , Data Science tutor at Wiingy
Profile photo of Akansha , Data Science tutor at Wiingy
tutor-image
tutor-image

Private tutor - Akansha Sharma

Bachelors degree

$15

$13

/ 30 min

About your data science tutor

Hi there! I'm Akansha Sharma, a Data Science tutor specializing in Microsoft Excel. With a strong background in data analysis, business analytics, and statistical modeling, I bring real-world expertise into my teaching. My journey includes hands-on experience in projects across industries like retail and finance, where I applied advanced data visualization and analytical techniques to drive insights. I have worked extensively with Excel, Power BI, and statistical methods to analyze data, identify trends, and improve decision-making processes. My experience includes independent projects in business analytics, where I gained expertise in RFM modeling, mutual fund investment analysis, and retail data insights. I have also applied my skills in professional settings, such as working with Zen Technologies on financial analysis and conducting research for strategic decision-making. I believe in interactive learning, where students actively engage with real-world datasets to apply theoretical knowledge. Whether you're a student looking to build foundational skills, a professional aiming to upskill, or someone transitioning into data analytics, I customize lessons to meet your needs. With a practical and hands-on approach, I guide students through essential Excel functions, data cleaning techniques, advanced formulas, pivot tables, dashboards, and automation to streamline workflows. Additionally, I introduce data analysis concepts, helping students understand how to interpret and visualize data effectively. My goal is to empower students to feel confident in handling data, making informed decisions. Let’s learn and grow together !

Data sciece class overview

As a Microsoft Excel tutor, I cater to students of all levels, including school students, college learners, and working professionals. My teaching methodology is designed to ensure a comprehensive and engaging learning experience that builds a strong foundation in Excel while progressively advancing to data analysis and visualization techniques. I believe that learning should be practical and application-driven, which is why I focus on real-world use cases that help students understand the true power of Excel in data-driven decision-making. One of the key aspects of my teaching approach is personalization. Every student has different goals, whether it’s preparing for exams, improving efficiency at work, or transitioning into data analytics. I tailor my lessons to meet their specific needs by selecting datasets relevant to their interests or professional domains. This approach makes learning more relatable and engaging while ensuring that students understand how to apply their knowledge in real-world scenarios. Rather than simply memorizing formulas, I encourage students to grasp the logic behind them, which fosters problem-solving skills and deeper comprehension. Hands-on training is central to my methodology. Instead of just explaining functions and commands, I guide students through interactive exercises where they actively work with Excel’s features. Whether it’s using PivotTables for data summarization, mastering lookup functions like VLOOKUP and INDEX-MATCH, or exploring automation techniques, students practice each concept extensively. Visualization is another essential component of my teaching. I ensure that students learn how to present data effectively through charts, graphs, and interactive dashboards.

Data Science tutor specialities

Project help icon

Project help

Business intelligence icon

Business intelligence

Data visualization icon

Data visualization

Job readiness icon

Job readiness

Assignment help icon

Assignment help

keyLearning

Data Science concept taught by Akansha

Todd learned 1 day ago

Akansha Bhatt taught Todd Mitchell how to use advanced VLOOKUP functions in Excel for business applications. This comprehensive lesson covered using wildcards, CHOOSE, MATCH, and SWITCH functions. Todd gained practical experience by applying these techniques to calculate commissions and perform data lookups across multiple worksheets. Akansha provided supporting PDF documentation, and they rescheduled their next session to Wednesday to discuss XLOOKUP and IF statements.

SWITCH function in VLOOKUP

Avoiding Errors in VLOOKUP

CHOOSE and MATCH in VLOOKUP

VLOOKUP Wildcards

Sorting VLOOKUP Tables

VLOOKUP Approximate Match

Show more

Todd learned 2 days ago

Akansha trained a learner on data validation and VLOOKUP functions in Excel. The learner, who resides in Chandler, practiced VLOOKUP with provided datasets, and they discussed common errors and troubleshooting. For their next lesson, they agreed to cover more complex VLOOKUP scenarios and potentially other functions like IF statements, with the learner planning to share a work-related spreadsheet for targeted practice.

VLOOKUP - Basics

VLOOKUP - Lookup Value

VLOOKUP - Table Array

Data Validation - Lists

Data Validation - Time

Data Validation - Dates

Data Validation - Input and Error Messages

VLOOKUP - Column Index Number

Show more

Todd learned 7 days ago

Akansha trained Todd on advanced Excel pivot table techniques, covering data refreshing, grouping data by categories and time periods, and leveraging slicers and timelines for interactive data filtering and analysis. Todd actively practiced grouping and slicer implementation. They also touched upon data validation and agreed to continue their lesson next Monday, focusing on additional data validation techniques and VLOOKUP.

Refreshing Pivot Tables

Grouping in Pivot Tables

Slicers for Filtering

Timeline Slicers for Dates

Data Validation

Show more

John learned 8 days ago

Two learners from Brooklyn College collaborated on structuring survey data in Excel for a committee presentation. They focused on formatting questions and summarizing responses, opting for a summarized question format with aggregated answers. One of the learners will format the data in Word before transferring it to Excel and will share the document with the other before their next lesson on Monday.

Presenting Survey Results

Excel vs. Word for Data

Data Summarization

Excel Formatting for Surveys

Show more

Todd learned 8 days ago

During their recent lesson, Akansha guided Todd through the intricacies of using Excel pivot tables for sales data analysis. The instruction covered key aspects such as creating, sorting, filtering, formatting, and grouping data by date. Todd gained hands-on experience by creating pivot tables and applying various filtering methods. Akansha assigned further practice sheets and indicated that their next lesson would focus on data validation and VLOOKUP.

Number Formatting

Grouping in Pivot Tables

Multiple Fields

Report Filters

Value Filters in Pivot Tables

Pivot Table Arrangement

Filtering Data

Data Presentation

Show more

Todd learned 9 days ago

During their recent lesson, Akansha instructed Todd on leveraging Excel's conditional formatting and pivot table features for effective data analysis. Todd actively practiced using data bars, color scales, and icon sets to visualize data trends and pinpoint duplicates. He also mastered creating pivot tables to summarize and calculate sales figures. Akansha assigned further exercises involving pivot tables, and their upcoming lesson will delve into VLOOKUP, INDEX, and MATCH functions.

Data Bars

Conditional Formatting

Data Bars

Color Scales

Icon Sets

Duplicate Removal

Pivot Tables

Conditional Formatting

Show more

Free lesson slots

1 / 1

Teaching tools used by data science tutor

Google Colab image

Google Colab

Jupyter Notebook image

Jupyter Notebook

RStudio image

RStudio

Looker image

Looker

Student types for data science class

School icon

School

College icon

College

Adult / Professional icon

Adult / Professional

All Levels icon

All Levels

Anxiety or Stress Disorders icon

Anxiety or Stress Disorders

Home schooled icon

Home schooled

Interactive data science classes

Note taking icon

Note taking

Open Q&A icon

Open Q&A

Weekend lessons icon

Weekend lessons

tutorFooter

Data Science tutors on Wiingy are vetted for quality

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

Report this listing