Top-rated Data Science tutor in Canada

The Student and Tutor worked extensively with Excel to refine an onboarding checklist template. They focused on implementing sheet protection features, creating dynamic graphs from cell references, and troubleshooting formula behaviors to ensure data integrity and controlled user access for new hires.

The Tutor and Student worked through basic Excel formulas including SUM, AVERAGE, MIN, and MAX, using simulated business scenarios. The Student practiced inputting formulas, using drag-and-drop selection, and the auto-fill feature. The follow-up task involves creating a new store simulation in a Google Sheet and applying these formulas, with the tutor providing a template and further instructions.

The student and tutor worked on enhancing Excel formula efficiency by mastering absolute and relative cell references and dynamic formulas. They practiced using SUMIF and COUNTIF functions to avoid hard-coding and explored how to reference other sheets. The student was assigned practice exercises focusing on absolute referencing.

The tutor and student worked on enhancing spreadsheet financial tracking by implementing dynamic lists of savings accounts using formulas and checkboxes. They also focused on understanding and applying absolute versus relative cell references for date ranges and explored creating dynamic expense reports using pivot tables.

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.