Microsoft Excel 2019 English 2022

Contents: Introduction. 1. Basic worksheet modeling. 2. Range names. 3. Lookup functions. 4. The INDEX function. 5. The MATCH function. 6. Text functions and Flash Fill. 7. Dates and date functions. 8. NPV and XNPV functions. 9. IRR, XIRR, and MIRR functions. 10. More Excel financial functions. 11. Circular references. 12. IF, IFERROR, IFS, CHOOSE, and SWITCH functions. 13. Time and time functions. 14. The Paste Special command. 15. Three-dimensional formulas and hyperlinks. 16. The auditing tool and the Inquire add-in. 17. Sensitivity analysis with data tables. 18. The Goal Seek command. 19. Using the Scenario Manager for sensitivity analysis. 20. The COUNTIF, COUNTIFS, COUNT, COUNTA and COUNTBLANK functions. 21. The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS and MINIFS functions. 22. The OFFSET function. 23. The INDIRECT function. 24. Conditional formatting. 25. Sorting in Excel. 26. Excel tables and table slicers. 27. Spin buttons, scrollbars, option buttons, check boxes, combo boxes and group list boxes. 28. The analytics revolution. 29. An introduction to optimization with Excel Solver. 30. Using Solver to determine the optimal product mix. 31. Using Solver to schedule your workforce. 32. Using Solver to solve transportation or distribution problems. 33. Using Solver for capital budgeting. 34. Using Solver for financial planning. 35. Using Solver to rate sports teams. 36. Warehouse location and the GRG Multistart and Evolutionary Solver engines. 37. Penalties and the Evolutionary Solver. 38. The traveling salesperson problem. 39. Importing data from a text file or document. 40. Get & Transform. 41. Geography and Stock data types. 42. Validating data. 43. Summarizing data by using histograms and Pareto charts. 44. Summarizing data by using descriptive statistics. 45. Using pivot tables and slicers to describe data. 46. The Data Model. 47. Power Pivot. 48. Filled and 3D Power Maps. 49. Sparklines. 50. Summarizing data with database statistical functions.