Top-rated Data Science tutor in Canada

The Student and Tutor worked on refining an Excel proficiency scorecard. They discussed structuring the scorecard for longitudinal tracking, implementing dynamic referencing with the `INDIRECT` function, and explored different chart types like radar charts for data visualization. The session concluded with a plan for the Student to complete the scorecard template.

The student and tutor worked on setting up dynamic data filtering in Excel using the FILTER and TRANSPOSE functions. They configured a helper table to dynamically display subcategories based on a selected category and implemented dynamic data validation dropdowns. The session concluded with spreadsheet optimization and preparation for future use, with a follow-up session scheduled for the following Monday.

The student and tutor worked on designing and implementing a proficiency scorecard template in a spreadsheet application. They addressed formula creation for averaging scores and discussed various organizational structures for tracking employee performance over time, including how to integrate action plans into the scorecard.

The student and tutor worked on structuring an Excel-based maintenance management system. They refined the 'Equipment List,' 'Maintenance Plan,' and 'Maintenance Log' sheets, focusing on data organization, unique identifiers, and formula-driven calculations for service dates. Future steps involve developing a dashboard and maintenance alerts, and addressing template file management in SharePoint.

The student and tutor discussed issues with an Excel trading sheet, focusing on comparing different versions of the file and resolving data population discrepancies. The tutor will review a cleaner version of the file sent by the student, and they confirmed the next session is scheduled for Thursday.

The Tutor and Student worked on formatting and enhancing a daily report spreadsheet in Excel. This included implementing dropdown menus, text joining, and improving the overall layout for better usability. They also discussed saving the sheet as a template and explored ideas for a maintenance log spreadsheet to implement in the future.