🔔 New Video Published 👇

https://youtu.be/C-FKLocN2KE

🔔 New Video Published 👇

https://youtu.be/41LsJ1XJkFo

🔔 New Video Published 👇

https://youtu.be/ObmOKIVS3xk

🔔 New Video Published 👇

https://youtu.be/4o8PzmdxFr0

🔔 New Video Published 👇

https://youtu.be/p-dekigxKxE

🔔 New Video Published 👇

https://youtu.be/C-wdDet8kuE

Unlock the power of Excel with these game-changing shortcuts!

🔔 New Video Published 👇

https://youtu.be/Rw11JX1ROTs

How to add the current date & time without typing
✅ To add a current date in a cell, press Ctrl +. If you would like to add the current time, then press Ctrl+Shift+.
✅ To change the date format, use Ctrl+Shift+#. Likewise, if you would like to change the time format, use Ctrl+shift+@.

✅New Video Published

https://youtu.be/SIfM9xXujWU

🔥 Filter Keyboard Shortcut in Excel
✅ We can also use the keyboard shortcut “CTRL+SHIFT+L” to turn on/off the filters.
✅ Once the filter has been enabled on the data, we can use the drop-down menus on each column header. Follow the below steps for doing the same:
✅ We must first select a cell in the header row. As we can see, every cell contains a drop-down icon like the image. Then, press the “ALT + down arrow key” on the keyboard to open the “Filter” menu

✅ New Video Published
https://youtu.be/AlgqPyIT-rE

✅ New Video Published
https://youtu.be/2SvgVmH8cSc
.
.
.

List of Various Excel Errors
1. #DIV/0
2. #N/A
3. #NAME?
4. #NULL!
5. #NUM!
6. #REF!
7. #VALUE!
8. #####
9. Circular Reference

1 – #DIV/0 Error
#DIV/0! Error is received when we work with a spreadsheet formula, which divides two values in a formula and the divisor (the number being divided by) is zero. It stands for divide by zero error.


2 – #N/A Error
This error means “no value available” or “not available.” It indicates that the formula cannot find the value that we suppose it may return.

For example, using Excel’s VLOOKUP, HLOOKUP, MATCH , and LOOKUP functions, we may get this error if we do not find referenced value in the source data as an argument.


3 – #NAME? Error
This error is displayed when we usually misspell the function name. We can see in the above image that VLOOKUP is not spelled correctly; that is why #NAME? Error is being displayed.


4 – #NULL! Error
This error is usually displayed when cell references are not specified correctly. We get this error when we do not use the space character appropriately. The space character is called the “intersect operator,” which specifies the range that intersects each other at any cell.


5 – #NUM! Error
This error is usually displayed when a number for any function argument is found invalid.


6 – #REF! Error
This error stands for reference error. This error usually comes when, We accidentally deleted the cell which we referenced in the formula.OR We cut and paste the referenced cell in different locations.


7 – #VALUE! Error
This error comes when we use the wrong data type for a function or formula. For example, we can add only numbers. But if we use any other data type like text, this error will be displayed.


8 – ###### Error
This error is displayed when the column width in excel, is not enough to show the stored value in the cell.


9 – Circular Reference Error
This type of error comes when we reference the same cell in which we are writing the function or formula.

Helpful Shortcut Keys of Excel

New Video Published
https://youtu.be/I0Gm0dqv3bw