Top-rated Data Science tutor in Canada

The Student and Tutor reviewed advanced Excel functions including XLOOKUP, SUMIF, COUNTIFS, and MAX for data consolidation and dashboard creation. They practiced creating dynamic KPIs, calculating spend by status and department, and generating various chart types for data visualization. The Tutor encouraged the Student to practice creating a month-wise revenue report and explore the MIN function.

The Tutor provided an introductory lesson on basic Microsoft Excel functions and formatting. The Student practiced entering data, applying basic formulas, and learned about named ranges, cell formatting, and the `Merge & Center` function. Future sessions will delve into more advanced functions.

The student and tutor reviewed and practiced advanced Excel features, including auto-fill, column width adjustment, freezing panes, table formatting, and applying various number and currency formats. They also worked on automating commission calculations using formulas and explored the use of the Format Painter for efficient styling. Further discussion on more advanced Excel automations and number formats is planned for future sessions.

The student and tutor worked through advanced Excel functionalities, including formatting cells, creating tables, generating random data with functions like `RANDBETWEEN`, calculating profit, and applying various border styles. They planned to continue formatting tables in the next session.

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.