1. Use AutoSum to Quickly Add Numbers
Shortcut: Alt + =
How to use:
Click the cell below a column of numbers, then press Alt + =. Excel will automatically add the numbers above.
🧠 Example: Want to total expenses? Just select the cell below them and press the shortcut!
2. Freeze Panes to Keep Headers Visible
How to use:
Go to View > Freeze Panes > Freeze Top Row
This keeps your column headers visible when scrolling down.
🧠 Great for: Long tables where you need to see headings while scrolling.
3. Format as Table for Better Data Control
How to use:
Select your data and press Ctrl + T
Excel will convert it into a “Table” with filters and styling.
🧠 Benefit: Makes sorting, filtering, and formulas easier and clearer.
4. Use IF Function for Logical Checks
Formula: =IF(A1>50, "Pass", "Fail")
This checks if the value in A1 is more than 50. If yes, shows “Pass”, otherwise “Fail”.
🧠 Helpful for: Student results, fee checking, condition-based outputs.
5. Learn Basic Shortcuts
| Task | Shortcut |
|---|---|
| Save | Ctrl + S |
| Copy / Paste | Ctrl + C / Ctrl + V |
| Undo / Redo | Ctrl + Z / Ctrl + Y |
| Select all cells | Ctrl + A |
| Find anything | Ctrl + F |
🧠 These shortcuts save a lot of time in daily work.
1. Use AutoSum to Quickly Add Numbers
Shortcut: Alt + =
How to use:
Click the cell below a column of numbers, then press Alt + =. Excel will automatically add the numbers above.
🧠 Example: Want to total expenses? Just select the cell below them and press the shortcut!
2. Freeze Panes to Keep Headers Visible
How to use:
Go to View > Freeze Panes > Freeze Top Row
This keeps your column headers visible when scrolling down.
🧠 Great for: Long tables where you need to see headings while scrolling.
3. Format as Table for Better Data Control
How to use:
Select your data and press Ctrl + T
Excel will convert it into a “Table” with filters and styling.
🧠 Benefit: Makes sorting, filtering, and formulas easier and clearer.
4. Use IF Function for Logical Checks
Formula: =IF(A1>50, "Pass", "Fail")
This checks if the value in A1 is more than 50. If yes, shows “Pass”, otherwise “Fail”.
🧠 Helpful for: Student results, fee checking, condition-based outputs.
5. Learn Basic Shortcuts
| Task | Shortcut |
|---|---|
| Save | Ctrl + S |
| Copy / Paste | Ctrl + C / Ctrl + V |
| Undo / Redo | Ctrl + Z / Ctrl + Y |
| Select all cells | Ctrl + A |
| Find anything | Ctrl + F |
🧠 These shortcuts save a lot of time in daily work.
1. Use AutoSum to Quickly Add Numbers
Shortcut: Alt + =
How to use:
Click the cell below a column of numbers, then press Alt + =. Excel will automatically add the numbers above.
🧠 Example: Want to total expenses? Just select the cell below them and press the shortcut!
2. Freeze Panes to Keep Headers Visible
How to use:
Go to View > Freeze Panes > Freeze Top Row
This keeps your column headers visible when scrolling down.
🧠 Great for: Long tables where you need to see headings while scrolling.
3. Format as Table for Better Data Control
How to use:
Select your data and press Ctrl + T
Excel will convert it into a “Table” with filters and styling.
🧠 Benefit: Makes sorting, filtering, and formulas easier and clearer.
4. Use IF Function for Logical Checks
Formula: =IF(A1>50, "Pass", "Fail")
This checks if the value in A1 is more than 50. If yes, shows “Pass”, otherwise “Fail”.
🧠 Helpful for: Student results, fee checking, condition-based outputs.
5. Learn Basic Shortcuts
| Task | Shortcut |
|---|---|
| Save | Ctrl + S |
| Copy / Paste | Ctrl + C / Ctrl + V |
| Undo / Redo | Ctrl + Z / Ctrl + Y |
| Select all cells | Ctrl + A |
| Find anything | Ctrl + F |
🧠 These shortcuts save a lot of time in daily work.