Posts

Showing posts from August, 2025

Featured post

Trick to get the sum row wise or column wise

    Row-wise or Column-wise Sum Using a Shortcut: Select the range of numbers in the table that you want to sum (either a column or a row, or even multiple columns or rows). Press the Alt key on your keyboard. After pressing Alt , press the +   = key . This is the AutoSum shortcut. If you're summing a column , Excel will automatically fill the cell directly below the selected range with the sum of that column. If you're summing a row , Excel will automatically fill the cell directly to the right of the selected range with the sum of that row.   The AutoSum feature ( Alt + = ) automatically sums numbers in a contiguous range of cells.    
1 comment
Read more

Advanced Excel Tips and Tricks

Image
#   15 Advanced Excel Tips and Tricks for Power Users   ##   1. Use Dynamic Arrays (FILTER, SORT, UNIQUE) Excel 365 introduces **dynamic array functions**: * `=UNIQUE(A2:A50)` → Removes duplicates. * `=SORT(A2:A50)` → Sorts data instantly. * `=FILTER(A2:B100, B2:B100="Completed")` → Filters data without complex formulas.   ## 2. Master VLOOKUP with Approximate Match Instead of exact matches, use: `=VLOOKUP(lookup_value, table_array, col_index_num, TRUE)` Great for tax slabs, commissions, or price ranges. ## 3. Switch to XLOOKUP (Better than VLOOKUP) `=XLOOKUP(value, lookup_array, return_array, "Not Found")` ✅ No column index issue. ✅ Can search left to right. ✅ Supports exact or approximate matches.   ##   4. Combine Data with Power Query Use **Data > Get & Transform (Power Query)** to:   * Merge multiple sheets/files. * Clean messy data (remove blanks, split columns). * Automate refresh of repo...
Post a Comment
Read more

150 Essential Computer Shortcuts

Image
    150 Essential Computer Shortcuts     1. General Shortcuts (Works in Most Apps) 1. Ctrl + C → Copy 2. Ctrl + X → Cut 3. Ctrl + V → Paste 4. Ctrl + Z → Undo 5. Ctrl + Y → Redo 6. Ctrl + A → Select All 7. Ctrl + S → Save 8. Ctrl + P → Print 9. Ctrl + N → New Document/Window 10. Ctrl + O → Open File 11. Ctrl + W → Close Window 12. Ctrl + F → Find 13. Ctrl + H → Replace 14. Alt + Tab → Switch Applications 15. Alt + F4 → Close Program     2. File Explorer (Windows) / Finder (Mac)   16. Ctrl + N → New Window 17. Ctrl + Shift + N → New Folder 18. Alt + Enter → File Properties 19. F2 → Rename File 20. Delete → Move to Recycle Bin 21. Shift + Delete → Permanent Delete 22. Ctrl + D → Delete Selected File (Mac: Cmd + Delete) 23. Ctrl + E → Quick Search 24. Alt + Up Arrow → Go Up Folder 25. Alt + Left Arrow → Back 26. Alt + Right Arrow → Forward 27. Ctrl + Mouse Scroll → Resize Icons 28. F5 → Refresh 29. Home → Go to Top of Folder 30. End → Go to Bottom of Fold...
Post a Comment
Read more