Lata Kaushik
Data Science Tutor for Excel & Data Analysis Techniques - Tutor University
Private tutor - Lata Kaushik
Masters degree
$18
$15
/ 30 min
About your data science tutor
I’m Lata Kaushik, and I’m here to help you become confident and skilled in MS Excel. With a background in engineering and hands-on experience in data analysis, business research, and project management, I’ve used Excel extensively in academic and industry settings. From mastering basic formulas and functions to building dashboards, automating tasks with Excel tools, and analyzing large datasets using pivot tables and charts, I can guide you at your own pace. Whether you're a student, a working professional, or someone looking to improve your productivity, my sessions are tailored to your goals. My sessions are interactive, goal-oriented, and customized to your needs. Let’s make Excel easy and impactful for you! I focus on practical learning with real-world examples to make Excel simple, useful, and even fun. Let’s get started!
Lata graduated from IIT Delhi
Data sciece class overview
My MS Excel teaching methodology is centered around practical, hands-on learning tailored to each student’s skill level and goals. I begin by assessing your current knowledge to customize lessons that build a strong foundation before progressing to advanced topics. Using real-world examples and interactive exercises, I help you master essential Excel skills such as formulas, functions, pivot tables, charts, and data analysis tools. I focus on breaking down complex features into simple, step-by-step instructions, and encouraging questions to ensure thorough understanding. My approach emphasizes not just learning Excel tools but applying them effectively to boost productivity and solve real problems in academics or the workplace. Ultimately, I aim to make Excel accessible, engaging, and empowering for every learner.
Expert in debugging code
Breaks down coding issues into manageable steps.
Debugging and problem-solving focus
85% of students improve debugging skills.
Interactive debugging sessions
Students debug and improve their own code in real-time.
Data Science tutor specialities
Statistical analysis
Assignment help
Data visualization
Business intelligence
To protect your payment, never transfer money or communicate outside the Wiingy website or app.
Data Science concept taught by Lata
Lata tutored Daisy on Excel, covering data formatting, conditional formatting, filtering, formulas, functions (SUM, AVERAGE, MIN, MAX), and relative/absolute referencing. Daisy practiced applying these concepts within the spreadsheet software. Lata assigned practice exercises using provided Excel files and offered ongoing support via chat, with the next lesson scheduled for Monday.
Calculating Percentage Bonus
Relative vs. Absolute Referencing
Excel Formulas vs. Functions
Filtering Data
Excel Formatting
Lata mentored Scott on data visualization in Excel, guiding him through chart selection and customization for effective data storytelling. Scott actively practiced creating various charts and applying Excel techniques to enhance his data presentation skills. They concluded by discussing ongoing support and scheduling their next lesson.
Choosing the Right Chart
Conditional Formatting
Moving Rows and Columns
Pie Chart Creation
Combining Charts
Calculating Missing Percentages
Lata introduced a student from the University of Texas at El Paso to the fundamentals of Excel, covering data entry, formatting, formulas, conditional formatting, and chart creation. The student gained practical experience by applying these concepts on a sample spreadsheet. To support continued learning, Lata will provide links to LinkedIn and Coursera courses, along with additional practice exercises.
Formatting Tables
Charts
Conditional Formatting
Formulas and Functions
Entering Data
Excel Interface
During their recent lesson, Lata guided Mario through various Excel functionalities essential for commission calculations. Their focus included formulas, data validation with dropdown menus, conditional formatting for visual cues, freezing panes for improved visibility, and filtering for focused analysis. Mario gained practical experience by applying these techniques to a commission calculator sheet provided by Lata, who subsequently sent the sheet to him for continued practice and experimentation with the formulas and formatting.
Conditional Formatting
YEAR function
Freezing Panes
Excel Formulas
Data Validation (Drop-Down Lists)
Lata taught Scott how to create a recruitment dashboard using spreadsheet software. Scott practiced using UNIQUE, COUNTIF, and COUNTIFS functions to extract and summarize data, and create dynamic charts. They scheduled the next session to work on Scott's assignments, and Scott will send the assignment link to Lata.
Creating Dashboards
Unique Function
Countif and Countifs
Chart Formatting
Dynamic Chart Data
Selecting Data for Charts
Fixing Ranges in Formulas
Lata provided Mario with an Excel training session, focusing on basic formatting, data entry, and manipulation techniques. Mario practiced number formatting, column resizing, and using serial numbers and date patterns in a practice file, with Lata guiding him through initial difficulties. They scheduled a follow-up session for Friday.
Adding Columns
Excel Formatting
Data Alignment
Cell Sizing
Date Formatting
Filters
Share Screen
Accounting Format
Your data science tutor also teaches
Data Analysis
Excel
Free lesson slots
1 / 1
Teaching tools used by data science tutor
Jupyter Notebook
Student types for data science class
Data Science for Beginners
Data Science for School students
Data Science for Adults
Data Science for Kids
Data Science for College students
Interactive data science classes
Record lessons
Pets are welcomed
Parent feedback
Open Q&A
Chat for quick help
Data Science tutors on Wiingy are vetted for quality
Every tutor is interviewed and selected for subject expertise and teaching skill.