Top-rated Data Science tutor in Canada
Explore Data Science with expert tutor guidance
Free Trial
15-days refund
Free tutor swap
No cancel fee
Summary
Podcast
Data science taught through tutor-led classes
Learners attend in Toronto, Edmonton, Calgary
Steven taught 3 days ago
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.
COUNTIF Function with Absolute Referencing
Excel Tables: Automatic Expansion and Formula Propagation
Using Filters for Sorting and Hiding Data
Formatting Dates as Text for Custom Sorting
Neha taught 4 days ago
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.
Pivot Tables for Data Summarization
XLOOKUP: The Modern Data Retrieval Function
EOMONTH Function for Date Calculations
IF Statement for Conditional Logic
Neha taught 7 days ago
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.
VLOOKUP Function
Pivot Tables: Summarizing Your Data
Creating and Formatting Charts
Data Formatting: Numbers
Percentages
and Currency
Remove Duplicates & Conditional Formatting
Neha taught 9 days ago
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.
Text to Columns
VLOOKUP Function
Formula for Gross Sales Calculation
Discount Calculation Formula
Data Cleaning Techniques
Steven taught 9 days ago
The student and tutor reviewed the application of the COUNTIF function in Excel, focusing on absolute versus relative cell referencing and its impact on formula results. The student practiced refining their formulas to dynamically reference entire columns for greater efficiency and adaptability when adding new data.
Absolute vs. Relative Cell Referencing
COUNTIF Function in Spreadsheets
Optimizing Spreadsheet Formulas for Scalability
Ashley taught 9 days ago
The Student and Tutor focused on understanding and applying Excel's IF, IF OR, and IF AND functions. The Student practiced creating conditional statements based on student data, including attendance and grades, and explored various formula options within Excel. Homework was assigned to further practice these conditional logic scenarios with a new dataset.
IF Statement Logic
IF OR Statement
IF AND Statement
Nested Formulas & Logic
Text vs. Numerical Comparisons
