Tugas Excel 10 AKL
|Function = https://www.excel-easy.com/functions.html
- Count and Sum
- Logical
- Cell References
- Date & Time
- Text
- Lookup & Reference
- Financial
- Statistical
- Round
- Formula Errors
- Array Formulas
============ Function + =============
- Count and Sum: Countif | Count Blank/Nonblank Cells | Count Characters | Count Cells with Text | Sum | Running Total | Sumif | Sumproduct
- Logical: If | Comparison Operators | Or | Roll th Dice | Ifs | Contains Specific Text | Switch | If Cell is Blank
- Cell References: Copy Exact Formula | 3D-reference | External References | Hyperlinks | Percent Change
- 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
- 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
- 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
- Financial: PMT | Loans with Different Durations | Investment or Annuity | Compound Interest | CAGR | Loan Amortization Schedule | NPV | IRR | Depreciation
- 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
- Round: Chop off Decimals | Nearest Multiple | Even and Odd
- Formula Errors: IfError | IsError | Aggregate | Circular Reference | Formula Auditing | Floating Point Errors
- 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
- Ribbon: Excel selects the ribbon’s Home tab when you open it. Learn how to collapse and customize the ribbon.
- Workbook: A workbook is another word for your Excel file. When you start Excel, click Blank workbook to create an Excel workbook from scratch.
- Worksheets: A worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook can contain multiple worksheets.
- Format Cells: When we format cells in Excel, we change the appearance of a number without changing the number itself.
- Find & Select: Learn how to use Excel’s Find, Replace and Go To Special feature.
- 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.
- Data Validation: Use data validation in Excel to make sure that users enter certain values into a cell.
- Keyboard Shortcuts: Keyboard shortcuts allow you to do things with your keyboard instead of your mouse to increase your speed.
- Print: This chapter teaches you how to print a worksheet and how to change some important print settings in Excel.
- Share: Learn how to share Excel data with Word documents and other files.
- Protect: Encrypt an Excel file with a password so that it requires a password to open it.