Formulas and functions

This subject teaches you the basics of working with formulas and functions in Excel. This knowledge is crucial for performing complex calculations and automating your data analysis.

Relative and absolute references: You will learn the difference between relative and absolute cell references and how to apply them in your formulas. Relative references adjust automatically when you copy formulas, while absolute references remain fixed. This is important to ensure correct calculations in your worksheets.

The IF function: The IF function is one of the most used functions in Excel, allowing you to perform conditional calculations. You will learn how to use the What-If function to perform logical tests on your data and display different results based on the test results.

Flash Preview: The flash preview is a tool that helps you automatically recognize and apply patterns in your data. You will learn how to use the flash preview to format and edit data quickly and efficiently. This saves time and increases the accuracy of your data processing.

With this knowledge, you will be able to perform complex calculations and automate your data analysis. You will be able to use formulas and functions effectively to design your worksheets accurately and efficiently.