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




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
Business intelligence
Data visualization
Job readiness
Assignment help

Data Science concept taught by Akansha
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
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
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
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
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
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
Free lesson slots
1 / 1
Teaching tools used by data science tutor
Google Colab
Jupyter Notebook
RStudio
Looker
Student types for data science class
School
College
Adult / Professional
All Levels
Anxiety or Stress Disorders
Home schooled
Interactive data science classes
Note taking
Open Q&A
Weekend lessons

Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.