How to create a pivot table in Excel

How to create a pivot table in Excel

Introduction What is a pivot table? A pivot table is a summary of a data set that is represented as a table. In pivot tables, the data can be summarized in multiple dimensions by positioning different fields of the original data set in rows, columns, or filters of the...
Conditional formatting formulas

Conditional formatting formulas

Introduction What is a conditional formatting formula? Excel allows using formulas when describing conditional formatting rules. It means that one can eventually introduce very flexible and – if necessary – sophisticated conditions to apply conditional...
Conditional formatting rules

Conditional formatting rules

Introduction What are conditional formatting rules? A conditional formatting rule is an Excel command that determines conditions under which a cell will be automatically highlighted and the format to be applied in those cases (e.g., a color fill, a bar, specific fonts...
Conditional Formatting 101

Conditional Formatting 101

Introduction What is conditional formatting? Conditional formatting is a way of automatically highlighting cells in Microsoft Excel based on cell values. This highlighting might be done through different formatting tools, including – but not limited to – colors, bars,...