Pooja Dalwani
"Excel Virtuoso: Unraveling Data Magic with Real-World Mastery"
Loading...
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
Homework help
Assignment help
Exam prep
Upskilling
Computer Science concept taught by Pooja
The Tutor and Student discussed strategies for data aggregation and transformation from multiple sources into a master dataset for PowerBI. The Student presented a real-world Excel master model for kindergarten demand forecasting, seeking assistance with its complexity and unclear methodologies. The Tutor will prepare data sets for the Student to combine and transform in PowerBI, and they scheduled additional sessions to delve deeper into the master model.
Data Modeling in Power BI
Data Aggregation from Multiple Sources
Data Transformation Techniques
Understanding Data Methodology and Context
The Student practiced using Excel pivot tables and charts to analyze additional work order (AWO) data. They learned how to create and customize line charts to visualize site-wise financial metrics and reorganized pivot table rows to analyze revenue by department. The Student will add more data to the AWO sheet and practice creating pivot tables in the next session.
Rearranging Pivot Table Fields
Interpreting Visualized Data
Customizing Charts for Clarity
Pivot Charts: Visualizing Data
Pivot Tables: Summarizing Data
The Tutor guided the Student on using Excel for data analysis, specifically focusing on data cleaning, formatting, and summarization. The Student learned to use the format painter, create pivot tables, and generate pivot charts to visualize revenue trends. The next session will revisit these topics.
Sorting Pivot Table Data
Excel Navigation Shortcuts
Format Painter
Excel Data Types
Pivot Charts for Data Visualization
Pivot Tables for Data Summarization
The Student learned to approach data analysis in PowerBI, focusing on exploratory data analysis and selecting appropriate visualizations to represent different aspects of a well-being program data set. They explored different chart types and discussed data modeling concepts. The student was assigned to find and send vulnerability data for the next session to practice forecasting skills.
Data Storytelling
Exploratory Data Analysis
Choosing the Right Visualization
Master Table & Dimensional Data
Data Cleaning and Transformation
Power BI for End-to-End Analysis
The student presented a hypothetical dataset about children's mental well-being programs, and they discussed using PowerBI to derive meaningful insights. The Tutor shared examples of real-world data analysis reports related to community services and maternal child health. They planned to work on the student's data set in PowerBI during the next session.
Stakeholder Engagement in Data Projects
Data Analysis Beyond Visualization
The Importance of Domain Knowledge in Data Analysis
Data Cleaning and Preparation
Holistic Evaluation: Economic and Social Equity Perspectives
Beyond Dashboards: Delivering Actionable Reports
Pooja guided Sam through the basics of Microsoft Excel, covering interface terminology such as ribbons, worksheets, cells, and formula bars. Sam learned how to identify cell addresses and enter formulas correctly. They scheduled the next session for Thursday to continue working on Sam's spreadsheet, with Sam tasked to input additional data including dates for each entry.
Formula Start
Formula Bar
Cell Reference
Active Cell
Cell
Worksheet
Workbook
Learner for programming class
Anxiety or Stress Disorders
Adult / Professional
College
Dynamic programming classes
Chat for quick help
Record lessons
Parent feedback
Open Q&A
Note taking
Teaching tools used by tutor
Jupyter Notebook
Coding tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.
