This section is for Excel users who want to learn more about formulas and functions in Excel.

1 Formulas & Functions: A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.

2 Cell References in Excel: Cell references in Excel are very important. This chapter explains the difference between relative, absolute and mixed cell reference.

3 Most Used Excel Functions: The most used functions in Excel are SUM, AVERAGE, COUNT, MAX and MIN. This chapter explains these functions and illustrates three options to access these functions.

4 Logical Functions in Excel: Learn how to use logical functions in Excel such as the IF function, AND function and OR function. The IF function can be nested, when you have multiple conditions to meet.

5 Date & Time Functions: An overview of the most important date and time functions in Excel.

6 Text Functions in Excel: Excel has many functions to offer when it comes to manipulating text strings.

7 Excel VLookup: The VLOOKUP function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column of the table. This chapter clearly illustrates the VLOOKUP function.

8 Excel Lookup: An easy example that shows you how to use the LOOKUP function in Excel. Not to be confused with the VLOOKUP function! The LOOKUP function is easier to use.

9 Excel Sumif: To sum cells based on one criteria, you can use the SUMIF function. In a similar way, you can use the AVERAGEIF and the COUNTIF function.

10 Excel Sumifs: To sum cells based on multiple criteria, you can use the SUMIFS function. In a similar way, you can use the AVERAGEIFS and the COUNTIFS function.

11 Excel Sumproduct: The SUMPRODUCT function is one of Excel's most powerful functions. Learn more about the SUMPRODUCT function in this chapter.

12 Excel Pmt: The PMT function in Excel calculates the payments for a loan based on constant payments and a constant interest rate.

13 Random Excel Numbers: Excel has two very useful functions when it comes two creating random numbers.

14 Excel Formula Errors: This chapter teaches you how to deal with the most common formula errors in Excel.

15 Round Excel Numbers: This chapter illustrates three functions to round numbers in Excel. The ROUND, ROUNDUP and ROUNDDOWN function.

16 Excel Transpose: The Transpose function in Excel switches rows to columns or columns to rows. You can also use the Paste Special Transpose option to transpose Excel data quickly.

17 Audit Excel Formulas: Formula auditing in Excel allows you to display the relationship between formulas and cells.

18 Array Formulas: Learn how to create Array formulas in Excel and do things you thought were impossible.

Follow

Thank you very much! We hope you'll soon become an Excel expert. Read on, learn, and enjoy!