Pooja Dalwani
"Excel Virtuoso: Unraveling Data Magic with Real-World Mastery"
Private tutor - Pooja Dalwani
degree
/ 30 min
Pooja - Know your tutor
Hi there! I’m Pooja, and I work in a tech company where Excel is a huge part of my daily life — from building dashboards and tracking invoices to organizing project data and generating reports. Along the way, I realized how powerful Excel can be once you understand how to use it properly — and that’s what made me want to teach. I love simplifying complicated tools and helping people feel more confident. Whether you’re just starting out or trying to do more with your spreadsheets, I’m here to guide you with patience, clarity, and real-world examples. My goal is to make Excel feel less intimidating and more empowering — so you can use it with ease in school, work, or life.
Certificates of Pooja
Programming class overview
I’ve always believed that learning should feel empowering, not intimidating — especially when it comes to tools like Excel that many people find overwhelming at first. I know that feeling well, because I’ve been there myself. I didn’t learn Excel in a classroom — I learned it on the job, solving real business problems, building reports from scratch, and figuring things out through trial and error. And that’s exactly why I love teaching it now — because I know what it’s like to start from zero and slowly realize how powerful Excel can be once you understand the logic behind it. I started teaching Excel because I realized that many of my colleagues, friends, and even managers were struggling with it — not because it was too hard, but because no one ever explained it to them in a clear, simple way. That’s what I love doing. I enjoy breaking things down, using real-world examples, and seeing that moment when someone says, “Oh! That actually makes sense now.” I believe that everyone can learn Excel — they just need someone to guide them without judgment, at their pace, with patience. Whether you’re a student trying to complete an assignment, a professional managing weekly reports, or someone exploring data analysis for the first time, I tailor my sessions to your level and your goals. I cover everything from the basics — formatting, formulas, VLOOKUP, XLOOKUP — to more intermediate topics like Pivot Tables, dashboards, and beginner-friendly automation using macros.
Programming tutor specialities
Assignment help
Upskilling
Homework help
Exam prep
To protect your payment, never transfer money or communicate outside the Wiingy website or app.
Computer Science concept taught by Pooja
Pooja and Renee covered data cleaning and visualization using Excel and PowerBI. Renee practiced identifying and correcting inconsistencies in Excel, creating pivot tables, and importing data into PowerBI. They created visualizations and discussed plans to continue working on formulas in Excel and linking them to PowerBI in future sessions.
PowerBI Data Types
Power Query Editor
Pivot Tables (Excel)
Excel UNIQUE Formula
PowerBI Interface
Data Cleaning (Excel)
Pooja and Renee practiced using COUNT, COUNTIF, and SUMIF functions in Excel with a sample dataset, and then moved on to learning about the XLOOKUP function. Renee was advised to practice these functions before moving on to COUNTIFS and SUMIFS. She plans to use census data for practice and schedule another session after practicing.
COUNT Function
SUMIF Function
COUNTIF Function
XLOOKUP Function
Cell Referencing (Absolute)
Pooja guided Samantha through creating an Excel spreadsheet for tracking additional work orders, covering data entry, table formatting, and basic calculations. Samantha practiced setting up columns, formatting data as currency, and using the SUM function. They plan to continue Excel lessons next Tuesday.
Auto-Fill Feature
Wrap Text
SUM Function
Data Formatting (Currency)
Excel Cell Navigation
Pooja assisted Maryanne with troubleshooting Excel formulas for her grape sales tracking sheet, focusing on cell referencing to ensure accurate calculations when copying formulas across different cells and sheets. Pooja also introduced Maryanne to creating interactive dashboards in Excel using pivot tables, slicers, and timelines for dynamic data analysis. Maryanne will practice implementing these techniques and plans to schedule more sessions after a two-week break.
Cell Referencing
Absolute vs. Mixed Referencing
Cross-Sheet Referencing
Excel Slicers
Card Visualization (Excel Workaround)
Pooja and Maryanne collaborated on visualizing sales data using Excel, covering pivot tables, line and bar charts, combo charts, and sales dashboards. Pooja demonstrated techniques for data analysis, chart customization, seasonality assessment, and sales forecasting. Maryanne will practice these techniques and identify specific visualizations to focus on in the next session.
Line vs. Column Charts
Pivot Tables
Combo Charts with Secondary Axis
Data Forecasting
Chart Customization
Sales Dashboards
Pooja tutored Maryanne on using Excel to improve her data presentation skills for cherry sales, covering pivot tables, various chart types for data visualization, and data extraction techniques. Maryanne worked on manipulating and visualizing sales data, but struggled with the existing data structure. They agreed that Maryanne would send Pooja a restructured dataset before the next session to enable further analysis and visualization.
Alt + Tab Shortcut
Pivot Tables
Excel Visualizations
Combo Charts
Bullet Charts
Data Preparation for Charts
Linking Excel Sheets
Learner for programming class
Adult / Professional
College
Anxiety or Stress Disorders
Dynamic programming classes
Chat for quick help
Note taking
Record lessons
Parent feedback
Open Q&A
Teaching tools used by tutor
Jupyter Notebook
Free lesson slots
1 / 1
Coding tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.