Top-rated Data Science tutor in Canada

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.

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.

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.

Shubham and Rohan collaborated on an Excel assignment, specifically task 4.1, which focused on advanced data analysis techniques. Their work involved mastering scenario management, constructing data tables, and generating insightful charts. To analyze profit per hour under various conditions, they effectively employed Excel's Scenario Manager, Solver, and pivot tables, supplementing their efforts with guidance from a video. While navigating the assignment, they encountered difficulties with formatting and the precise setup of data tables, and even pinpointed potential inaccuracies in the provided answer key. Ultimately, their diligent efforts resulted in a commendable score of 93 out of 100.

Shubham provided an Excel lesson to a learner from San Antonio, assisting with various assignment tasks. They collaborated on troubleshooting technical issues and worked through concepts like managing hyperlinks, formatting worksheets, using formulas, defining names, and handling circular references. During the lesson, they also reviewed graded assignments, identified errors, and made plans to continue working on assignment 4.1 the following day.

Shubham provided Rohan with an Excel lesson, covering essential skills such as sorting data, conditional formatting, and table manipulation. Rohan initially struggled with exercise 3.2, but after redoing it under Shubham's guidance, he achieved a perfect score. Due to Shubham's fatigue, they opted to postpone exercise 3.1 to their next lesson, agreeing to review the material beforehand.