Top-rated Data Science tutor in Canada

The tutor and student reviewed spreadsheet data manipulation techniques, including adjusting raw data while maintaining totals and calculating percentages. They then delved into the advanced `IFS` formula for categorizing due dates and explored the potential of AI tools like ChatGPT for Excel automation. The next session will cover pivot tables and dashboard creation.

The tutor guided the student through several advanced Excel formulas, including `EOMONTH`, `IF` with `NETWORKDAYS`, `RANK.EQ`, and `CONCATENATE`. The student practiced applying these functions to analyze data, calculate business days, rank values, and combine text strings, with plans to cover pivot tables in a future session.

The student and tutor reviewed and practiced advanced Excel functions, including the `COUNTIF` function with absolute referencing. They also worked on data manipulation techniques such as creating tables, sorting, and filtering data, and formatting dates for proper chronological analysis. The student is scheduled to meet again in two weeks.

The student and tutor worked extensively with Excel, focusing on pivot tables and lookup functions. They practiced data preparation, creating pivot tables for sales forecasting and analysis, and utilizing XLOOKUP and EOMONTH functions for data retrieval and date calculations. The session concluded with an introduction to the IF function for conditional analysis, with the student to practice these skills.

The Tutor and Student reviewed and practiced Excel functions, including VLOOKUP, data formatting, Pivot Tables, Pivot Charts, Slicers, removing duplicates, and conditional formatting. They planned to continue VLOOKUP practice and introduce XLOOKUP in the next session.

The student and tutor worked through practical Excel exercises. They practiced data cleaning techniques like 'Text to Columns,' used the VLOOKUP function for data retrieval, and performed calculations for gross sales and discounts. The session also covered text formatting and explored table creation, with plans for the student to practice these skills further.