Toggle navigation
GoSkills
Search for courses or lessons
Courses
Microsoft Excel
Lean Six Sigma
Microsoft Office
Finance
Project Management
Office Productivity
Soft Skills
Development
Design
Microsoft Excel
Excel - Basic
Excel - Advanced
Excel - Basic & Advanced
Excel - Pivot Tables
Excel - Macros and VBA
Excel - Dashboards
Excel - Power Query
Excel - Power Pivot
View more »
Lean Six Sigma
Yellow Belt
Green Belt
Black Belt
Principles - Green Belt
Principles - Black Belt
Statistical Process Control
Measurement Systems
Hypothesis Testing
View more »
Microsoft Office
PowerPoint
Word - Basic & Advanced
Word - Basic
Word - Advanced
Project Fundamentals
Access - Basic
Outlook
Publisher
View more »
Finance
For Non-Financial Professionals
For Operations Managers
For Project Managers
For Operations Directors
Financial Modeling Basics
Financial Modeling Techniques
Project Management
Project Management Basics
PM for Team Members
PM for Business Professionals
PM for Engineers
PM for Experts
PMP Certification Training
Scrum for Team Members
Scrum for Managers
View more »
Office Productivity
Keynote for Mac
Evernote
Trello
Google Drive & Apps
Productivity Training
Soft Skills
Business Writing
Public Speaking
Body Language
Team Leadership
Press Releases
Customer Service Training
Introduction to Sales
Leadership Training
View more »
Development
Introduction to HTML
Introduction to CSS
Introduction to JavaScript
Introduction to PHP
Introduction to SQL
Ruby on Rails
Design
Photoshop for Beginners
Photoshop - Advanced
Illustrator - Basic
Illustrator - Advanced
Coming soon
Intro to Ruby Programming
Introduction to Python
Get all these courses for only
$39
/month
Learn more
For business
Business
Teach
Blog
Redeem a coupon
Start Free Trial
Search
Login
Quiz
1
Beginner
Providing you need to add data from an Access database to an existing Excel solution and pull it in to a PivotTable, how would you start the process?
Go to the Data tab > From Access > Browse to your database > Select the table or query you’d like to use
Open the Access database and export the table or query into an Excel file.
Go to the Data tab > Existing Connections > Select your database > Select the table or query you’d like to use
Don’t know
2
Beginner
When connecting to a database, we have the option to “land” our data in either a table or directly into a PivotTable. What reason would you want to land your data into a table first?
You can see the data first, and create new columns using formulas.
It must be landed to a table in order to refresh the data since you have to right click the source data table to refresh it.
Your data set is less than 1,048,575 rows.
Don’t know
3
Beginner
When connecting to a database, we have the option to “land” our data in either a table or directly into a PivotTable. What would force you to avoid landing your data in a table first?
All the fields you could ever need are pre-calculated in the database already, so no manipulation will ever be needed in the worksheet.
Your data set is greater than 1,048,575 rows.
The IT department has implemented a limit on your file size, forcing you to keep it under 5 MB.
Don’t know
Back to the top
© 2019 GoSkills Ltd.
Skills for career advancement