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
Neha taught 2 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 3 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 3 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
Steven taught 3 days ago
The tutor and student worked on integrating budget data into a pivot table for financial tracking. They explored methods for accurately representing monthly budgets alongside transaction data, including the use of helper tables and `SUMIFS`/`IF` formulas, and began constructing a dynamic formula to handle grand totals and blank rows.
Pivot Table Data Limitations
SUMIFS Function for Conditional Summation
Dynamic Date Range Calculations
Absolute References ($) in Formulas
IF Statements for Conditional Logic
Steven taught 8 days ago
The tutor and student explored methods to automate personal finance tracking in Excel, focusing on integrating dynamic budgeting with historical data and automating bank statement imports. They discussed the development of a more advanced financial analysis tool, with plans for the student to utilize a developed version in the near future.
Dynamic Budgeting in Excel
Automated Bank Statement Import with VBA
Customizable Reporting and Data Visualization
VBA as an Advanced Excel Tool
Lata taught 14 days ago
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.
Excel Sheet Protection
Referencing Data Between Sheets
Creating Dynamic Graphs with Formulas
Cell Formatting and Conditional Logic
