Microsoft Excel 2021365 - Beginner to Advanced - Creating a Calculated Field

Microsoft Excel 2021365 - Beginner to Advanced - Creating a Calculated Field

Assessment

Interactive Video

Information Technology (IT), Architecture, Business

University

Hard

Created by

Quizizz Content

FREE Resource

The video tutorial explains how to use calculated fields in pivot tables. It starts with an introduction to calculated fields, followed by a demonstration of removing and adding fields. The tutorial then guides viewers through creating a calculated field, including naming and formula construction. It also covers formatting calculated fields and calculating average profit over 12 months. Finally, it introduces a method to represent values using symbols for positive and negative numbers.

Read more

1 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

What new insight or understanding did you gain from this video?

Evaluate responses using AI:

OFF