Pivot Tables: MUST-KNOW for Business & Finance Professionals

Kenji Explains March 20, 2022
Video Thumbnail
Kenji Explains Logo

Kenji Explains

@kenjiexplains

About

 🧑‍💻 Explaining the data, business, and finance concepts I wish I had known earlier! 📚 Check out my courses if you want to learn more: careerprinciples.com ✌️Have a great day!

Video Description

Learn Pivot Tables for Business & Finance roles. In this step-by-step excel tutorial, we analyse a dataset through a real-life simulation with our manager using pivot tables. 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/623499367e7ec064e82a1de9 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance We learn how to insert pivot tables, pivot charts, slicers, as well as all the pivot table fields. We create columns, rows, and different values such as sums and averages using the value field settings. Then, we learn to calculate new fields discover how profitable Apple's operations are. Then, we start working on the pivot table visuals. From inserting pivot charts, to creating dynamic slicers, we cover it all. Lastly, we learn the different design settings ranging from borders to highlight colors. LEARN: 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🏦 The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Pivot Table Dataset 0:58​ - Pivot Table Analysis 5:17​ - Pivot Charts 7:27​ - Advanced Pivot Tables 8:56​ - Slicers & Design Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

You May Also Like

Upgrade Your Data Analysis

AI-recommended products based on this video

Loading...
Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

(1,960)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month
Loading...
UGREEN USB Bluetooth 5.3 Adapter for PC, Plug & Play for Windows 11/10/8.1, Bluetooth Receiver & Transmitter for Keyboard/Mouse/Headphone/Speakers/Printer

UGREEN USB Bluetooth 5.3 Adapter for PC, Plug & Play for Windows 11/10/8.1, Bluetooth Receiver & Transmitter for Keyboard/Mouse/Headphone/Speakers/Printer

(1,874)
6.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
3K+ bought in past month
Loading...
BISSELL® Steam Shot™ OmniReach handheld portable steam cleaner for tile, grout, windows, bathrooms, kitchens, fabric steaming tool, includes 10 tools

BISSELL® Steam Shot™ OmniReach handheld portable steam cleaner for tile, grout, windows, bathrooms, kitchens, fabric steaming tool, includes 10 tools

(5,004)
$41.99$33.99
FREE delivery Thu, Sep 11
40K+ bought in past month
Loading...
Lenovo IdeaPad 15.6” FHD Touchscreen Laptop, 40GB RAM 2.5TB Storage (2TB SSD+512GB Docking Station Set), 6-Cores Intel Core i3, Windows 11 Pro with Microsoft Office Included, Plusera Earphones

Lenovo IdeaPad 15.6” FHD Touchscreen Laptop, 40GB RAM 2.5TB Storage (2TB SSD+512GB Docking Station Set), 6-Cores Intel Core i3, Windows 11 Pro with Microsoft Office Included, Plusera Earphones

(94)
$599.99
FREE delivery Tue, Jun 17
300+ bought in past month
Loading...
Lenovo 2025 New Touchscreen Laptop • 6-Cores Intel Core i3 • 40GB RAM • 2TB SSD • 15.6 inch FHD (1920 x 1080) Display • Long Battery Life • WOWPC Recovery USB • Windows 11 Pro with Microsoft Office

Lenovo 2025 New Touchscreen Laptop • 6-Cores Intel Core i3 • 40GB RAM • 2TB SSD • 15.6 inch FHD (1920 x 1080) Display • Long Battery Life • WOWPC Recovery USB • Windows 11 Pro with Microsoft Office

(2)
$1,159.99$469.99
FREE delivery Jun 23 - 25
300+ bought in past month
Loading...
acer Nitro V 15 Gaming Laptop, 15.6" 144Hz FHD Display, Intel 10-Core i7-13620H, NVIDIA GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Microsoft Office Lifetime License, Windows 11 Pro

acer Nitro V 15 Gaming Laptop, 15.6" 144Hz FHD Display, Intel 10-Core i7-13620H, NVIDIA GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Microsoft Office Lifetime License, Windows 11 Pro

(827)
$1,659.99
FREE delivery Jun 17 - 20
Loading...
acer Nitro V16 Gaming Laptop, Microsoft Office 2024 Lifetime License, 16" WUXGA 165Hz, AMD Ryzen 7 8845HS Up to 5.10 GHz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Win 11 Pro

acer Nitro V16 Gaming Laptop, Microsoft Office 2024 Lifetime License, 16" WUXGA 165Hz, AMD Ryzen 7 8845HS Up to 5.10 GHz, GeForce RTX 4060, 64 GB DDR5 RAM, 4 TB SSD, Backlit Keyboard, Win 11 Pro

(0)
$1,769.99
FREE delivery Jun 17 - 20
Loading...
Macally Small Wired Keyboard for Mac and Windows - 78 Scissor Switch Keys Compatible Apple Keyboard - USB Mini Keyboard That Saves Space and Looks Great - Plug and Play Wired Mac Keyboard - Aluminum

Macally Small Wired Keyboard for Mac and Windows - 78 Scissor Switch Keys Compatible Apple Keyboard - USB Mini Keyboard That Saves Space and Looks Great - Plug and Play Wired Mac Keyboard - Aluminum

(4,883)
27.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
200+ bought in past month
Loading...
Wireless Gaming Headset for PS5, PS4, PC, Mac, Switch, 2.4GHz Gaming Headsets with Bluetooth 5.4, Hidden ENC Noise Canceling Mic, 35H Battery, 3D Spatial Sound, 3.5mm Wired - Black

Wireless Gaming Headset for PS5, PS4, PC, Mac, Switch, 2.4GHz Gaming Headsets with Bluetooth 5.4, Hidden ENC Noise Canceling Mic, 35H Battery, 3D Spatial Sound, 3.5mm Wired - Black

(132)
$14.99
FREE delivery Jul 2 - 6 on $35 of items shipped by Amazon
2K+ bought in past month
Loading...
UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

UGREEN USB C to USB Hub with 4 USB 3.0, Powered USB C Splitter for Laptop, MacBook Pro, Mac mini M4, iMac, iPad Pro, Chromebook, Dell XPS, Galaxy S23, and More, 0.5FT

(12,070)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
400+ bought in past month
Loading...
Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

Wireless Bluetooth Mouse for Apple iPad iPhone MacBook Android Samsung Tablet Phone Dual-Mode Rechargeable 2.4G Portable Computer Mice for Windows Laptop Notebook PC Mac Desktop USB Receiver (Black)

(1,960)
9.99
PrimeFREE delivery Saturday, June 14 on orders shipped by Amazon over $35
500+ bought in past month