Top-rated Data Science tutor in Canada

The student and tutor worked through a technical issue where a "Simplified" platform's exported data was not integrating correctly with an Excel profit and loss tool. They identified that the issue stemmed from opening files from email and the platform's change in export options from Excel to CSV. The tutor guided the student on how to manually process the CSV export in Excel to achieve the desired financial report format.

The student and tutor reviewed and optimized Excel formulas, distinguishing between functions and formulas. They practiced using `SUMIF` and addressed errors related to incorrect arguments and data structure, with the student assigned homework to correct specific formulas using relative references and avoiding hardcoding.

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.