BUSINESS EXCEL

🔴 New Video Published Calculate GST Automatically in Excel (Local Tax / Central Tax) 9%, 18% Automatically https://youtu.be/zl7-qDWp6tw

🔴 New Video Published https://youtu.be/Qf_DqC3Jv7g . .

🔴 New Video Published https://youtu.be/Poj2bT5jy9k . .

🔴 New Video Published . . https://youtu.be/tQ1aWXdQwyM

🔴 New Video Published . . https://youtu.be/LA3vHY88vQs

🔴 New Video Published . . https://youtu.be/mitgQe4ImGg

🔴 New Video Published . . https://youtu.be/RhCtKTz6m24

MAY-2023 Tax Last Date Chart ⚡️ GST/ Income/ Tax/ TDS/ TCS Etc. . https://techguruplus.com/important-dates/

New Video Published . . How to Find ✅ Best Selling & 🔴 Worst Selling Product in Big Excel Data . . Video Link 👉 https://youtu.be/Nz6Y-ACLVDc

Hi Everyone 🙏 You Can Follow me on Instagram also www.Instagram.com/nazim_excel — Thanks

Latest 2023 Marriage Biodata Format (in Word) https://techguruplus.com/bio-data/

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

Helpful Shortcut Keys of Excel

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.

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

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