Search for courses or lessons
Redeem a coupon
Start free trial
Before we set up our PivotTables, we should ensure that the data is in good form. Which of the following should NEVER be included in a PivotTable data source?
Blank rows and columns
Header rows on our tables
Which of the following statements is true?
Data consistency is entirely optional in a column
Data types should be consistent down all rows of a column, with the exception of the header row (which will always be treated as text)
Data types should be consistent down all rows of a column including the header row
What is the quickest way to select all the data in our worksheet that we want to include in our PivotTable?
Select any cell in the worksheet, select Insert > PivotTable and everything will automatically be selected
Select the top left cell, hold the left mouse button and scroll down and across until we get to the last used cell
Press CTRL + End, hold down the Shift key, and then press CTRL + Home
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement