Tugas Excel 10 AKL

Function = https://www.excel-easy.com/functions.html

1. Count and Sum
2. Logical
3. Cell References
4. Date & Time
5. Text
6. Lookup & Reference
7. Financial
8. Statistical
9. Round
10. Formula Errors
11. Array Formulas

============ Function + =============

12. Count and Sum: Countif | Count Blank/Nonblank Cells | Count Characters | Count Cells with Text | Sum | Running Total | Sumif | Sumproduct
13. Logical: If | Comparison Operators | Or | Roll th Dice | Ifs | Contains Specific Text | Switch | If Cell is Blank
14. Cell References: Copy Exact Formula | 3D-reference | External References | Hyperlinks | Percent Change
15. Date & Time: DateDif | Today’s Date | Calculate Age | Time Difference | Weekdays | Days until Birthday | Time Sheet | Last Day of the Month | Holidays | Quarter | Day of the Year
16. Text: Separate Strings | Number of Instances | Number of Words | Text to Columns | Find | Search | Lower/Upper Case | Remove Spaces | Compare Text | Substitute vs Replace | Text | Concatenate | Substring
17. Lookup & Reference: Vlookup | Tax Rates | Index and Match | Two-way Lookup | Offset | Case-sensitive Lookup | Left Lookup | Locate Maximum Value | Indirect | Two-column Lookup | Closest Match | Compare Two Columns
18. Financial: PMT | Loans with Different Durations | Investment or Annuity | Compound Interest | CAGR | Loan Amortization Schedule | NPV | IRR | Depreciation
19. Statistical: Average | Negative Numbers to Zero | Random Numbers | Rank | Percentiles and Quartiles | Box and Whisker Plot | AverageIf | Forecast and Trend | Absolute Value | MaxIfs and MinIfs | Weighted Average | Standard Deviation | Frequency
20. Round: Chop off Decimals | Nearest Multiple | Even and Odd
21. Formula Errors: IfError | IsError | Aggregate | Circular Reference | Formula Auditing | Floating Point Errors
22. Array Formulas: Count Errors | Count Unique Values | Count with Or Criteria | Sum Every Nth Row | Sum Largest Numbers | Sum Range with Errors | Sum with Or Criteria | Most Frequently Occurring Word | System of Linear Equations

=============== BASIC = https://www.excel-easy.com/basics.html

23. Ribbon: Excel selects the ribbon’s Home tab when you open it. Learn how to collapse and customize the ribbon.
24. Workbook: A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch.
25. Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
26. Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.
27. Find & Select: Learn how to use Excel’s Find, Replace and Go To Special feature.
28. Templates: Instead of creating an Excel workbook from scratch, you can create a workbook based on a template. There are many free templates available, waiting to be used.
29. Data Validation: Use data validation in Excel to make sure that users enter certain values into a cell.
30. Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.
31. Print: This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.
32. Share: Learn how to share Excel data with Word documents and other files.
33. Protect: Encrypt an Excel file with a password so that it requires a password to open it.