Pro Tips

Member MS EXCEL
MS EXCEL

Still removing duplicates manually from reports? Do it in seconds with one click.

👉 Hack: Select your data → Go to Data tab → Remove Duplicates → OK

Still scrolling through large sheets to find specific data? Jump to exactly what you need — instantly.

👉 Hack: Press Ctrl + F → Options → Within: Workbook to search across all sheets at once.

Still manually checking where a value is used in your sheet? Highlight everything in seconds.

👉 Hack: Use Conditional Formatting → Highlight Cells Rules → Text that Contains to instantly spot all matches.
Member POWER BI
POWER BI

Still using calculated columns for dynamic analysis? You’re slowing down your model.

👉 Hack: Use Measures (DAX) instead — they calculate on the fly and keep your model faster and lighter.

Still importing full datasets into Power BI? You don’t need all that data.

👉 Hack: Use Power Query → Filter rows early to reduce data size before loading — improves performance significantly.

Still building dashboards without a data model? That’s why things feel messy and slow.

👉 Hack: Create relationships in Model view (star schema) to organise data and enable efficient analysis.

write to us

WhatsApp us WhatsApp