Please revise the YouTube advertisement that suggests people who do not learn AI will be left behind in employment. At the same time, it is important not to underestimate Microsoft Excel, as it is capable of handling complex calculations where even AI can sometimes make errors. For someone who has experience using multiple AI applications and has also lived through two different technological eras, I can say from experience that I understand both perspectives.
Later someone challenge me to provide an example. CHALLENGE ACCEPTED!! :
One common example is multi-layered engineering or financial spreadsheets with interdependent formulas, lookup tables, conditional logic, and iterative calculations.
- Multiple worksheets are linked together,
- Progress claims are calculated based on work completed,
- Retention sums, liquidated damages, variations, taxes, escalation factors, and currency conversions are applied,
- Formulas may contain nested IF, INDEX-MATCH, XLOOKUP, SUMPRODUCT, and array functions,
- Circular references may be intentionally used with iterative calculations.
- Misinterpret the logic flow between worksheets
- Miss hidden cells, named ranges, or indirect references
- Suggest formulas that appear correct but produce inaccurate results.
- Fail to detect that a small formula change affects dozens of downstream calculations.
(Never underestimate an old man who appear to pretend like he's an idiot)
No comments:
Post a Comment