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 1 day ago
The Tutor and Student worked on advanced Excel formatting, focusing on the "Format as Table" feature. They practiced converting ranges to tables, managing cell formatting, and applying consistent styles and data types across different data sets. The next session will involve adding columns to remaining tables and further refining their structure.
Formatting Data as Tables in Excel
Image Manipulation within Cells
Column Deletion in Excel Tables vs. Regular Ranges
Data Formatting: Dates and Currency
Format Painter for Consistent Styling
Nikita taught 3 days ago
The student and tutor worked extensively on advanced Excel functionalities, focusing on data manipulation within tables. They practiced using "Format as Table" to improve data management, inserting columns, and controlling formula auto-fill behavior. The session also involved troubleshooting specific calculations for agent and company totals, and manually entering goal-related commission figures.
Excel Table Formatting
Formula Auto-fill Behavior in Tables
Using SUM Function for Totals
Manual Data Entry vs. Formulas
Neha taught 4 days ago
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.
XLOOKUP Function
Pivot Tables for Data Summarization
SUMIF and COUNTIF Functions
Dashboard Creation
Nikita taught 8 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 9 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 10 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


