This video shows how to create and use pivot tables in Excel using a dataset for a fictional retailer. The dataset, which consists of 10,000 transactions, contains data for 3 different customer types. The video shows how to create pivot tables to quickly answer questions about each customer type, such as the gross profit for each customer type. — Edspira is the creation of Michael McLaughlin, an award-winning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education freely available to the world. — SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS: • A 23-PAGE GUIDE TO MANAGERIAL ACCOUNTING • A 44-PAGE GUIDE TO U.S. TAXATION • A 75-PAGE GUIDE TO FINANCIAL STATEMENT ANALYSIS • MANY MORE FREE PDF GUIDES AND SPREADSHEETS * http://eepurl.com/dIaa5z — SUPPORT EDSPIRA ON PATREON *https://www.patreon.com/prof_mclaughlin — GET CERTIFIED IN FINANCIAL STATEMENT ANALYSIS, IFRS 16, …
