Lata Kaushik
Your Go-To Tutor for Excel, Word and PowerPoint| Learn with Confidence and Clarity
Loading...
Lata Kaushik
Masters degree
Enroll after the free trial
Each lesson is 55 min
50 lessons
20% off
/ lesson
30 lessons
15% off
/ lesson
20 lessons
10% off
/ lesson
10 lessons
5% off
/ lesson
5 lessons
-
/ lesson
1 lessons
-
/ lesson
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 Science tutor skills
Statistical analysis
Assignment help
Business intelligence
Data visualization
Learner types for data science class
Data Science for College students
Data Science for School students
Data Science for Beginners
Data Science for Adults
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 concepts taught by Lata
The Student and Tutor worked on building an Excel onboarding checklist, automating task completion tracking, and visualizing progress using bar graphs. They used formulas such as `COUNTIFS` and `UNIQUE` to ensure accuracy and consistency. The next session is scheduled for December 22nd to review progress on the checklist and visualizations.
Data Visualization with Charts and Graphs
UNIQUE Function for Data Validation
Absolute Cell References using $
Non-Empty Cell Check in COUNTIFS
COUNTIFS Function with Multiple Criteria
Onboarding Checklist Automation
Lata assisted a student from Marshall University in Huntington in resolving conditional formatting errors in an Excel spreadsheet. They addressed issues with conflicting rules and rule precedence, focusing on how to manage and delete rules to achieve the desired formatting outcome. The student plans to work on new projects and will reach out for shorter, focused lessons as needed.
Troubleshooting Conditional Formatting
Conditional Formatting Rule Hierarchy
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.
COUNTIF Function
Excel Chart Creation
Not Empty Operator (<>)
Absolute References ($)
COUNTIFS 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.
Data Amalgamation Challenges
XLOOKUP 'If Not Found' Argument
Excel Chart Axis Formatting
Excel Chart Data Selection
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
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
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.
