Introduction to Pivot Tables in Excel



Learn how to use Pivot Tables in Excel to easily summarize data. The example uses income and expense data and shows how to summarize by account, category and date. See the corresponding blog article:

0:14 How to Insert a Pivot Table
1:06 Using the field list pane to construct the Pivot Table
1:54 Add a Calculated Field
2:29 Changing the number formatting
2:47 Summarize data by month
3:03 Use the Timeline feature to filter by month
3:28 Show a running balance for each account by date

👍 Remember to Subscribe!

FOLLOW VERTEX42 HERE:
Website:
Instagram:
Facebook:
Pinterest:
Twitter:

LOOKING FOR MORE SPREADSHEETS? START HERE:

Watch more new videos about Excel Office | Synthesized by Mindovermetal English

5/5 - (1 bình chọn)

Bài viết liên quan

Theo dõi
Thông báo của
guest
2 Comments
Cũ nhất
Mới nhất Được bỏ phiếu nhiều nhất
Phản hồi nội tuyến
Xem tất cả bình luận
3jimmy33

That timeline tip was gold!

T

You need to create some asmr videos with your voice. People would adore you, your voice is like silk.