Academy

The PerfectXL Academy is a knowledge base with articles on various topics related to Excel. Here, you will find everything you want to know and learn about Excel, from a simple glossary to detailed instructions. Are you missing any topics? We’d love to hear your suggestions!

Operator sign in Excel // PerfectXL Academy

Operator sign

An operator sign is a symbol that indicates a type of computation between cells and/or integers and is often used in the more straightforward types of calculations in Excel.

Formula range in Excel // PerfectXL Academy

Formula range

A formula range is usually a reference to a range of cells, within which a formula persists consistently throughout the full range.

Formula breakdown // Excel Glossary // PerfectXL Academy

Formula breakdown

A formula breakdown refers to the disentanglement of the items in a formula. In Excel, most of these components will be clear at a glance, like constants, values, functions and operator signs.

Formula in Excel // PerfectXL Glossary

Formula

A formula is a type of equation. An equation says that two things are equal, that is why in Excel a formula always starts with ‘=’.

Cell reference // Excel Glossary // PerfectXL Academy

Cell reference

A cell reference in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet.

Excel Function Translations: Italian to English // PerfectXL Academy

Italian to English

List of Excel function translations from Italian to English for if you’re familiar with the Italian version of Excel and you have to work with the English version.