STEP 3:Place the Pivot Table in a New or Existing Worksheet. This will insert your very first Pivot Table! You need to have a dataset ready so that we will create a Pivot Table based on it. Let us go over a couple of Pivot Table basics to get you started. You would be surprised on how widely used Excel Pivot Tables are! Pivot Tables are used by Project Managers, Finance Analysts, Auditors, Cost Controllers, Sales Analysts, Financial Controllers, Information Technology, Human Resources, Doctors and Statisticians just to name a few.
A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, “pivot”/change the report layout with the ease of dragging fields around, highlight key information to management and include Charts & Slicers for your monthly presentations. Pivot Tables in Excel are one of the most powerful features within Microsoft Excel.
