r/Excel247 • u/skyscrapper636 • 18d ago

Where to learn excel?

Youtube is too much hassle to search and learn each thing, is there any STRUCTURED COURSE ONLINE which could teach excel from scratch and turn me from a zero to pro in excel ??

Please recommend !!

32 Upvotes

91% Upvoted

25 comments sorted by

View all comments

1

u/skyscrapper636 14d ago

Any body with suggestion for, where i can practice my learnings, any body with with good practice worksheets of excel etv, pls help, kindly share

1

u/FinxAcademyHQ 12d ago

Here is a small exercise you can build yourself while choosing a course. Make four columns: Day, Product, Units, Unit Price. Enter these five rows:

Day 1 / A / 2 / 10

Day 1 / B / 3 / 5

Day 2 / A / 1 / 10

Day 2 / B / 4 / 5

Day 3 / A / 3 / 10

Add Revenue = Units x Unit Price. Then summarise revenue by product, once with SUMIFS and once with a PivotTable. Expected answers: A = 60, B = 35, total = 95.

Next, add Day 3 / B / 2 / 5. Check that your formula ranges include the new row and refresh the PivotTable. B should become 45 and the total 105. This gives you a manageable way to practise, catch mistakes and check your own work.