First of all I would like to wish you all a Happy and Prosperous New Year, 2014. I got a bit late in wishing this as I was occupied in the joining and training formalities in my new organization, Capgemini.
Let's again proceed to know more on MS Excel. I would like to share some information on Pivot table today. Pivot table is an interactive table that automatically extracts, organizes, and summarizes your data. We can use this to analyze the data, make comparisons, detect patterns and relationships, and discover trends.
You might have observed that every time you have to refresh your Pivot table post updating your master data from where you have created a Pivot table. To avoid this repetation, MS Excel has an option which helps the user to Refresh the data every time you open the file.This forces the Pivot table to refresh it automatically while opening.
To perform this, select the pivot table and click right. Click "PivotTable Options" and visit the "Data" tab as shown below. There you will find the check box option of "Refresh data when opening file".
Check the box and save. For more information on how to do this, please get in touch with me at Samrat.biswaas@gmail.com
Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.
Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.
Visit Other MS Excel Tips and TricksHow to avoid #DIV/0! and #Value! Error?
How to create One Variable Data Table using What-if-Analysis?
Desde el analisis de blogspot, yo encontre que aqui son mas nacionales de espanol visita en mi Excel in MS Excel blog. so soy escribo el blogs en espanol tambien desde proximo blog en adelante. Espero el nacionales de espanol visitarnos en mi blog le gustara este in espanol.
Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
--------------------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
https://www.facebook.com/Samrat.Biswas
