![]() ![]() TIP: Hold down the CTRL key to select multiple items in your Slicer. It is easier now to zero in on specific combinations that you need or what your boss will need! Just with this, you can filter your data depending on the selections you have made. Your slicer is now ready! Go crazy clicking, slicing and dicing your data! STEP 2: Go to Options(Excel 2010)/Analyze(Excel 2013&2016) > Insert Slicer ![]() Select any cell and you should be good to go. STEP 1:Select your Pivot Table by clicking anywhere inside it. They are a must for anyone wanting to wow their boss by adding interactivity in their reports! I show you how to insert a Pivot Table Slicer below: Slicers in Excel are visual filters or interactive buttons that allow you to see what items have been chosen within a Pivot Table. It adds another layer of interactivity that you can do with Pivot Tables. Now let’s have a quick sneak peek of how to use slicers with the Pivot Table. Whether it be identifying trends, comparing performances, finding outliers, you name it! This is very exciting if you have a big set of data and want to make sense of it. 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! You now have your Pivot Table! And the best part is no manual calculations were made. 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) This will let you determine the location of where you want to put your pivot table in. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |