Here we will learn how Functions in Excel will help you to expedite the work and save your time. If you are a starter and you are not familiar with function in excel please read first introduction to Formulas and Functions.
1. Count and Sum: Count and Sum is the most useable Function in Excel. Count and Sum function can be used on single and multiple criteria.
2. Logical: the logical function that are used in Excel are IF, AND, OR and NOT. Here we will learn how to use these functions.
3. Cell References: Cell references are very important functions in Excel. Here we will try to understand the difference between relative, absolute and mixed reference.
4. Date & Time: To enter a date, use the "/" (backslash) or "-" characters. To enter a time, use the ":" (colon).
5. Text: Excel has many functions to offer when it comes to manipulating text strings.
6. Lookup & Reference: Here we will learn all about Lookup & Reference functions, such as VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE.
7. Financial: Financial functions is the most popular function. Here we will illustrate Financial function in Excel.
8. Statistical: here we will discussed about very useful Statistical Functions in Excel.
9. Round: The function that is used to round the figures in Excel is ROUND, ROUNDUP and ROUNDDOWN.
10. Formula Errors: Here we will learn how to deal with some common formula errors.
11. Array Formulas: Here we will try to understand the array formulas in Excel. We will also learn how Single cell array formulas perform multiple calculations in one cell.
Functions
To become an expert in Microsoft Excel you can find related examples and features on the right side of each chapter. For an overview you can read the following.
1. Count and Sum: Countif | Count Blank/Nonblank Cells | Count Characters | Not Equal To | Count Cells with Text | Sum | Running Total | Sumif | Sumproduct
2. Logical: If | Comparison Operators | Or | Roll the Dice | Ifs | Contains Specific Text | Switch | If Cell is Blank | Absolute Value
3. Cell References: Copy a Formula | 3D-reference | External References | Hyperlinks | Union and Intersect | Percent Change | Add a Column | Absolute Reference | Address
4. Date & Time: DateDif | Today's Date | Date and Time Formats | Calculate Age | Time Difference | Weekdays | Days until Birthday | Last Day of the Month | Add or Subtract Time | Quarter | Day of the Year
5. Text: Separate Strings | Count Words | Text to Columns | Find | Search | Change 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 | Xlookup
7. Financial: PMT | Loans with Different Durations | Investment or Annuity | Compound Interest | CAGR | Loan Amortization Schedule | NPV | IRR | Depreciation | Profit Margin
8. Statistical: Average | Negative Numbers to Zero | Random Numbers | Rank | Percentiles and Quartiles | Box and Whisker Plot | AverageIf | Forecast | MaxIfs and MinIfs | Weighted Average | Mode | Standard Deviation | Frequency
9. Round: Chop off Decimals | Nearest Multiple | Even and Odd | Mod | Rounding Times
10. Formula Errors: IfError | IsError | Aggregate | Circular Reference | Formula Auditing | Floating Point Errors | IFNA
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 | Dynamic Arrays | LET function
Check out all 300 examples.
No comments:
Post a Comment