Limited 1:1 learner slots available each month. Request Consultation

Self-Assessment

Know where you stand before you start.

Take a practical 20-question Excel assessment and get an instant score with a simple interpretation of your current level.

1:1personalised learning path
Practicalrealistic workplace use cases
Outcome-ledfocus on what you need to achieve
1. Which function is best suited to return a matching value from another table using a key?
2. What is the main advantage of converting a range into an Excel Table?
3. Which feature is most suitable for quickly summarising large datasets by category?
4. What does IFERROR help you do?
5. When is Power Query especially useful?
6. What is the most reliable first step before building a dashboard?
7. Which formula is commonly used for conditional aggregation?
8. What is a common reason to use INDEX/MATCH or XLOOKUP instead of manual copy-paste?
9. What does unpivoting data usually help with?
10. A report takes 3 hours every day because the same cleanup steps are repeated. What is the best improvement direction?
11. Why are consistent data types important?
12. What is the purpose of data validation?
13. What is the strongest reason to use named/structured references?
14. If a PivotTable source grows every week, what source design is generally better?
15. What should a management dashboard prioritise?
16. What does merging queries in Power Query generally do?
17. Which is usually better for a recurring monthly report?
18. What is the value of separating raw data from report outputs?
19. What should you check first when a formula returns an unexpected result?
20. Which statement best describes advanced Excel capability?

Request Consultation

Bring the problem you want to solve.

Share your role, current level and learning goal. We review your requirement and contact you to discuss fit and availability.

Request Consultation Prefer email? Write to coach@bigurus.in