أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
you know that Excel is fantastic for number crunching. But did you know that Excel also comes with a tool that is specifically designed to analyze huge sets of data? That tool is the PivotTable, and it is arguably the most powerful tool in Excel. There’s simply no better way to quickly make sense of a large set of data. And because PivotTables are extremely versatile, you can find opportunities to use them in any business setting. PivotTables are fast, flexible, and extremely accurate. Once you learn how they work, they will change the way you look at data analysis in Excel forever. Thus, learning PivotTables is a great career move, and this collection of tips will help make sure you’re getting the most out of PivotTables as you begin to use them to analyze data in Excel.
You can make a PivotTable in about15 secondsMany people worry that creating a PivotTable is time-consuming, but if you have well-organized source data, you can create a PivotTable in a snap. Here, we have sales data for a speciality chocolate business. Note that each column has a unique name and there are no empty rows or columns.
When you click OK, your table will be created. Note: as long as your data is in good shape, you can create a table in one step using the keyboard shortcut Ctrl-T. Now that you have a table, click the Summarize with PivotTable button (TableTools > Design)
in the DATA Tab, click on Refresh All and its done.
IN Excel2010. Just click inside the pivot table and force the pivot menu to launch. Then choose "Change Data Source" from the Data group source from the Data group of options. With the source data range highlighted, click and drag to highlight the new range in your data. In this step you could add new data or include more columns and row. Finally refresh the pivot table by clicking the "Refresh" button.
IF you only change in data so you in the DATA Tab, click on Refresh All and its done otherwise if you add extra rows and col so you need reselect data of pivot table