![]() ![]() ![]() ![]() Excel just works it magic, determines what are the row values, column values based on your data, then works to group and sum the values together! This is very exciting if you have a big set of data and want to make sense of it. Our setup in our example is as follows: Column – YEAR Row – Region Values – Sum of SALES What we are saying here is create a report wherein the rows are the regions, columns are the years, then the values inside the pivot table will be the sum of sales (based on the grouping of year and region) You now have your Pivot Table! And the best part is no manual calculations were made. This will let you determine the location of where you want to put your pivot table in. STEP 2:Go to Insert > Pivot Table This will insert your very first Pivot Table! STEP 3:Place the Pivot Table in a New or Existing Worksheet. ![]() Prepare to be amazed! STEP 1:Click inside your dataset. You need to have a dataset ready so that we will create a Pivot Table based on it. You would be surprised on how widely used Excel Pivot Tables are! Let us go over a couple of Pivot Table basics to get you started. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |