Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

ResolvedVersion 365

Tue 24 Sep 2024, 10:41 Delegate Louis said...

Louis has attended:
Excel Intermediate course
Excel Advanced course

Pivot Tables

Can you use Pivot tables to pull from regular Tables?

Wed 25 Sep 2024, 17:02 Trainer Martin said...

RE: Pivot Tables

Hi Louis,

Thank you for your question to the forum

Yes, you can turn your source data into a table and any changes or additions to the table will be automatically updated in the Pivot via a refresh. This method is more efficient than using a non table as the source data as this would involve having to 'Change Data Source' before refreshing which takes longer

Hope this has helped

Kind regards
Martin

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Add Text to Displayed Numbers in Excel 2010