BUSINESS EXCEL
前往频道在 Telegram
Email 👉 nazim.khan09@gmail.com Website 👉 https://TechGuruPlus.com Free Tools 👉 https://eConvert.org
显示更多7 358
订阅者
+224 小时
+77 天
+4130 天
帖子存档
7 361
MAY-2023
Tax Last Date Chart ⚡️
GST/ Income/ Tax/ TDS/ TCS Etc.
.
https://techguruplus.com/important-dates/
7 361
New Video Published
.
.
How to Find ✅ Best Selling & 🔴 Worst Selling Product in Big Excel Data
.
.
Video Link
👉 https://youtu.be/Nz6Y-ACLVDc
7 361
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.
7 361
🔥 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
7 361
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+@.
