ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How could i update a pivot table by just adding new data in the source sheet?

user-image
تم إضافة السؤال من قبل Mostafa Mohamed Saed Mohamed El wardany , As supply chain –Procurement executive (Section head), CISCM , SCIB PAINTS EGYPT
تاريخ النشر: 2013/12/05
Mohammed Yaseen MBA  PMP®
من قبل Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

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 seconds

Many 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)

 

 

Khalid Noor
من قبل Khalid Noor , Accounting Manager , FedEx

in the DATA Tab, click on Refresh All and its done.

Ahmed Saeed
من قبل Ahmed Saeed , Supply Chain and Purchasing Manager , Tuff Gear Ltd.

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.

Tariq Ali
من قبل Tariq Ali , Deputy Manager IT , Kohat Cement Company Limited

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

المزيد من الأسئلة المماثلة