M-EXGF | Excel Gevorderden: Formules en Functies | Training Course | Applications. (2024)

FAQs

How to learn Excel formulas quickly? ›

Type the equal sign =. Note: Formulas in Excel always begin with the equal sign.

Make up your own mnemonic device.

Use the parts of the formula to tell yourself a story or spell out a word that you can remember. For example, if you're trying to remember that E = mc squared, you could remember it by saying that Elephants (E) are afraid of mice and critters.

It takes most Excel users approximately 18-20 hours to fully learn this spreadsheet application. However, this number depends on several factors. Keep reading to learn about how you can study Excel and find resources to help speed the process along.

Try Different Learning Strategies

You may also write down the formulas on paper as you learn them. Writing down the formulae several times will help you remember them because our brain has a proclivity for remembering what we write. It's also a good idea to say the formulas out loud to help you remember them.

Absolute references An absolute cell reference in a formula, such as $A$1, always refer to a cell in a specific location.

Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.

The SUM function is the first must-know formula in Excel. It usually aggregates values from a selection of columns or rows from your selected range. Example: =SUM(B2:G2) – A simple selection that sums the values of a row.

What are the 5 basic functions of Excel PDF? ›

Excel formulas that return a set of values, also known as an array, return these values to neighboring cells. This behavior is called spilling. Formulas that can return arrays of variable size are called dynamic array formulas.

A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references. These are separated by calculation operators.

How many functions are there in Microsoft Excel? There are over 450 functions in Microsoft Excel. They vary from simplistic to complex financial, statistical, engineering and database functions.

How do you calculate 20% in Excel? To calculate 20% in Excel, you can use the formula: "=number*0.2". Replace "number" with the specific value you want to calculate 20% of. Multiplying the number by 0.2 will give you the result that represents 20% of the original value.