About this product

Microsoft Excel Beginners, Intermediate, and Advanced Functions.
1. Key Excel Functions: IF
2. Enlarge the Formula Bar.
3. Key Excel Functions: SUM, SUMIF, SUMIFS.
4. Key Excel Functions: COUNT, COUNTA, COUNTIF, COUNTIFS
5. Key Excel Functions: AVERAGE, and AVERAGEIF
6. Key Excel Functions: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATINATE.
7. Working with text in Excel.
8. Find the highest and lowest values in a range: Max & Min
9. = and + are interchangeable when you start typing the Formula.
10. Use ROUND in your financial models.
11. Excel's lookup Functions: VLOOKUP & HLOOKUP made easy.
12. INDEX, MATCH, and their Combination - The perfect substitutes of VLOOKUP
13. XLOOKUP: a solid substitute of VLOOKUP (office 365 only)
14. Using EXCEL'S IFERROR function to trap Spreadsheets errors.
15. A useful tool for financial analysis - The Rank Function
16. Create flexible financial model with CHOOSE
17. Goal seek will help you find the result you're looking for.
18. Perform sensitivity analysis with Excel's data Tables Functionality.
#accounting #excel #Microsoft #bookkeeping #businessanalysts