ExcelSessions
step by Step guide to learn Excel features, formulas, functionalities and VBA
26/05/2026
Most Data Analysts use these Excel formulas DAILY
If you want to work smarter in Excel, start mastering these functions
• XLOOKUP
• SUMIFS
• COUNTIFS
• IFERROR
• INDEX + MATCH
📌 Save this cheat sheet now
🔁 Share with someone learning Data Analytics
Copy Data from Another Sheet Using VLOOKUP
Excel Tip 💡
Need to insert multiple rows or columns in Excel quickly? 📊
Instead of adding them one by one, Excel allows you to insert multiple rows or columns in a single step — saving a lot of time during data preparation and reporting.
This trick is especially useful for:
✔️ Large datasets
✔️ Report formatting
✔️ Dashboard preparation
✔️ Data organization
✔️ Faster worksheet editing
A simple shortcut that can improve your Excel productivity instantly 🚀
📌 Save this reel for future reference
24/05/2026
Excel Tip 💡
Understanding the difference between COUNT, COUNTA, and COUNTBLANK is essential for accurate reporting and data analysis.
This quick reference guide covers:
✔️ Syntax
✔️ Use cases
✔️ Examples
✔️ Common mistakes
✔️ When NOT to use each function
📌 Save this post for quick reference
24/05/2026
Most Excel users confuse SUBSTITUTE and REPLACE
But knowing the difference can save a lot of time while cleaning data in Excel
✅ SUBSTITUTE → Replace specific text
✅ REPLACE → Replace text based on position
This simple comparison will help you remember when to use each formula 👇
📌 Save this post for future reference
💬 Which one do you use more often?
Excel Trick - Keep Headers Visible in Excel 📊
Excel Custom Sorting Trick You Should Know
How to use TEXT function for required Date format
Excel Hack: Lock Pivot Table Column Width ⚡
How to check live currency rate in Excel?
20/05/2026
Most people get this wrong on the first try...
Can you guess the correct output of this formula?
Click here to claim your Sponsored Listing.
Category
Telephone
Website
Address
Auckland