XLTips
Accelerate Your Financial & Analytics Career Industry Ready
Micro-Learning Masterclasses

Single-Topic Live Practitioner Sessions & On-Demand Classes

Hyper-focused, practical live workshops (e.g. Learn VLOOKUP today at 4:00 PM for ₹88) and purchasable recorded masterclasses delivered on Microsoft Teams and our high-definition replay workstation.

event_available

Upcoming Live Sessions

Scheduled Future Cohorts & Workshops
calendar_today

No Future Live Classes Currently Scheduled

New weekly single-topic sessions are published regularly. Explore our on-demand recorded library below.

play_circle

Past Live Classes — Recorded On-Demand

Individually Purchasable Masterclass Replays & Materials
ondemand_video Recorded Class Data Analytics

Compare Two Excel Lists

Compare two Excel lists to identify missing items, duplicate entries and differences. Practise with supplier lists, product codes and office records.

verified Instant Video Replay Access 35 mins
person Harshad Patel Concluded Nov 2026
Recording Pass ₹9
Get Recording →
ondemand_video Recorded Class Spreadsheets

VLOOKUP for Finding Records

Learn to find matching information in Excel tables using VLOOKUP. Practise finding product prices, employee details and invoice records.

verified Instant Video Replay Access 35 mins
person Harshad Patel Concluded Nov 2026
Recording Pass ₹9
Get Recording →
ondemand_video Recorded Class Spreadsheets

COUNTIF and SUMIF for Reports

Learn to count records and calculate totals based on specific conditions. Practise preparing department summaries, sales totals and payment reports.

verified Instant Video Replay Access 30 mins
person Harshad Patel Concluded Oct 2026
Recording Pass ₹9
Get Recording →
ondemand_video Recorded Class Visualization

Conditional Formatting for Office Work

Highlight overdue tasks, pending payments, duplicate values and low stock automatically using Excel conditional formatting rules.

verified Instant Video Replay Access 30 mins
person Harshad Patel Concluded Oct 2026
Recording Pass ₹9
Get Recording →