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
Nikita taught 3 days ago
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.
Excel Interface Basics
Formulas and Functions in Excel
Named Ranges in Excel
Status Bar Information
Formatting Cells and Tables
Nikita taught 4 days ago
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.
AutoFill and Selection Shortcuts
Column Width and Row Height Adjustment
Freeze Panes for Navigation
Merge & Center for Headings
Number Formatting (Comma
Percentage
Accounting)
Formula Automation and Relative References
Nikita taught 5 days ago
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.
Cell Formatting in Spreadsheets
Generating Random Data with RANDBETWEEN
Creating Dynamic Calculations: Formulas vs. Static Values
Table Creation and Formatting
Neha taught 7 days ago
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.
Pivot Tables vs. Raw Data
The IFS Function in Excel
Formula Copying and Pasting
AI Integration in Excel (Co-pilot/ChatGPT)
Neha taught 8 days ago
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.
End of Month (EOMONTH) Function
IF Function
NETWORKDAYS Function
IF with NETWORKDAYS
RANK.EQ Function
CONCATENATE Function
Steven taught 13 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
