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 + =============

  1. Count and Sum: Countif | Count Blank/Nonblank Cells | Count Characters | Count Cells with Text | Sum | Running Total | Sumif | Sumproduct
  2. Logical: If | Comparison Operators | Or | Roll th Dice | Ifs | Contains Specific Text | Switch | If Cell is Blank
  3. Cell References: Copy Exact Formula | 3D-reference | External References | Hyperlinks | Percent Change
  4. 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
  5. 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
  6. 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
  7. Financial: PMT | Loans with Different Durations | Investment or Annuity | Compound Interest | CAGR | Loan Amortization Schedule | NPV | IRR | Depreciation
  8. 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
  9. Round: Chop off Decimals | Nearest Multiple | Even and Odd
  10. Formula Errors: IfError | IsError | Aggregate | Circular Reference | Formula Auditing | Floating Point Errors
  11. 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

  1. Ribbon: Excel selects the ribbon’s Home tab when you open it. Learn how to collapse and customize the ribbon.
  2. Workbook: A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch.
  3. Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
  4. Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.
  5. Find & Select: Learn how to use Excel’s Find, Replace and Go To Special feature.
  6. 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.
  7. Data Validation: Use data validation in Excel to make sure that users enter certain values into a cell.
  8. Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.
  9. Print: This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.
  10. Share: Learn how to share Excel data with Word documents and other files.
  11. Protect: Encrypt an Excel file with a password so that it requires a password to open it.