Lata Kaushik
Your Go-To Tutor for Excel, Word and PowerPoint| Learn with Confidence and Clarity
Data Science tutor - Lata Kaushik
Masters degree
/ 30 min
About your data science tutor
Hi, I'm Lata. I've worked with Excel for around 8-9 years. This work ranges from business analyst to research to teaching. I've been a teacher for more than a year now and have worked with multiple students all over the globe. My expertise is in business data analytics to derive meaningful results from it. I love to work with people who are beginning their journey with excel because I get to introduce them to the wonderful world of excel. Whether you're a school student, a college student needing help with anything assignment or a professional trying to leap into new domains which require Excel, I'm here to help you in your journey. I also offer assignment/task-based help. Apart from Excel, I also work with PowerPoint and Word. If you have any questions, let's connect in a demo session and understand each other. Hope to see you soon for our demo session!
Lata graduated from IIT Delhi
Data sciece class overview
I believe learning is most effective when it’s hands-on, engaging, and connected to the real world. My teaching style blends clear explanations with interactive activities, ensuring students understand concepts rather than just memorizing them. I start with curiosity-building hooks, break topics into simple steps, and guide learners through practical projects that link theory to everyday life. I encourage questions, exploration, and independent thinking, while providing structure and support so each student feels confident and motivated to learn. We will start with your needs and what you want to achieve from these sessions during the demo. Then I will design a personalised lesson plan and share with you. This will be a dynamic plan, which can be changed if required and we will look at it from time to time to see our progress.
Data Science tutor skills
Statistical analysis
Business intelligence
Data visualization
Assignment help
To protect your payment, never transfer money or communicate outside the Wiingy website or app.
Data Science concept taught by Lata
Lata and Rita collaborated on an Excel lesson, where they focused on rebuilding a dashboard. Their work involved mastering COUNTIF and COUNTIFS formulas to track task progress using multiple criteria. Rita specifically honed her skills in correcting cell references and developing a pie chart to visually represent task distribution across different project phases. They have scheduled their next lesson to further their work in Excel, with a possibility of introducing PowerPoint.
Excel Chart Creation
Not Empty Operator (<>)
Absolute References ($)
COUNTIFS Function
COUNTIF Function
Lata assisted Elisa with her Excel dashboard project, focusing on handling agency amalgamations and improving data visualization. They worked on formatting bar graphs to display funding data and discussed strategies for dealing with agency name changes in the dataset. Elisa will continue working on the graphs and number formatting before the next session.
Excel Chart Data Selection
XLOOKUP 'If Not Found' Argument
Excel Chart Axis Formatting
Data Amalgamation Challenges
Lata assisted Alex with advanced Excel techniques, focusing on linking data between sheets using formulas, mastering cell formatting for a professional look, and understanding printing options. During their lesson, Alex practiced using the 'equals to' and 'concatenate' functions, and explored various formatting tools. Lata will provide Alex with a sanitized copy of the Excel file for future practice.
Cell Referencing Across Sheets
Merging Cells
Applying Cell Borders
CONCATENATE Function
CHAR(10) Function
Lata guided Elisa in building an Excel dashboard to dynamically display data for different agencies, focusing on funding, people treated, and waiting times. Elisa practiced using the XLOOKUP function, data validation for drop-down lists, and various formatting techniques to improve the dashboard's clarity. The next session will cover adding charts to visualize the data.
XLOOKUP Function
Data Validation (List)
Absolute Cell References
Suppressing Zero Values
Lata guided Alexandra through essential Excel techniques for creating a dynamic and user-friendly worksheet. Their lesson focused on formatting and protecting cells, including managing text, locking specific cells to prevent formula errors, and setting print areas. Lata will further refine the Excel files based on Alexandra's feedback, incorporating checkboxes and footers, before sharing the updated versions.
Center Across Selection
Dynamic Cell Length (Alt+Enter)
Sheet Protection
Lata and Daisy collaborated on creating an expenses dashboard in Google Sheets, focusing on extracting insights from financial data. Daisy gained practical experience using functions like SUMIF, UNIQUE, and SUMIFS, applying them to generate month-wise and type-wise expense reports with graphical representations. Lata assigned further practice with the sheet and suggested pursuing Excel and data analysis certifications. Their next lesson is planned to cover pivot tables and VLOOKUPs.
Cross-Sheet Referencing
Data Interpretation
Text to Columns Function
SUMIF Function
UNIQUE Function
Learner types for data science class
Data Science for School students
Data Science for Beginners
Data Science for Adults
Data Science for College students
Teaching tools used by data science tutor
Jupyter Notebook
Interactive data science classes
Weekend lessons
Open Q&A
Chat for quick help
Record lessons
Pets are welcomed
Free lesson slots
1 / 1
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.