Generating reports for single tables takes a few clicks.
Excel created pivot tables to improve upon its convoluted, weak reporting features (which are still available). The pivot table is actually a collection of tools that Excel uses to help you create better reports from complex, multi-file spreadsheet data. You filter, sort, reorganize, calculate, and summarize your spreadsheet databases, then extract specific information into a report.
For example, your spreadsheet may contain 25 field columns, but you only need four of these fields for your report. The Pivot Table tools allow you to sift that data in, literally, seconds—a huge improvement over Excel’s previous reporting capabilities.
To make it easier for you to practice the tasks we’re about to describe, go to (go. pcworld.com/crtx) and follow the instructions to create a sample relational database.
SINGLE “FLAT-FILE” PIVOT TABLE REPORTS
Pivot Tables are the “defined as tables” spreadsheets that the Pivot Table tools use to create custom reports for both flat-file and multi-file (relational) databases. This powerful function, which includes some very user-friendly filtering features, is a vast topic that cannot be covered adequately in a single article. Therefore, this article addresses the single “flat file” Pivot Table reports. We’ll follow up with coverage of the multi-file “relational” Pivot Table reports.
1. Open the database file, then click the VIOLATIONS tab. Place your cursor on column C - Violation Fee. Click the down arrow (right side), choose Sort Smallest to Largest, and click OK.
2. Click the arrow again, select Number Filters > Greater Than.
This story is from the {{IssueName}} edition of {{MagazineName}}.
Start your 7-day Magzter GOLD free trial to access thousands of curated premium stories, and 9,000+ magazines and newspapers.
Already a subscriber ? Sign In
This story is from the {{IssueName}} edition of {{MagazineName}}.
Start your 7-day Magzter GOLD free trial to access thousands of curated premium stories, and 9,000+ magazines and newspapers.
Already a subscriber? Sign In
Facebook wants to use your posts to train Al. Here's how to object
Facebook is changing its privacy policy and plans to use posts and images to train its Al. To prevent this, you need to object.
Windows 11's new AI feature could be a privacy nightmare
Your PC will be watching your every move by default.
The future of Windows: Copilot+ PCs unleash practical AI tools
Microsoft is aligning AI with its Copilot brand.
If you get a phone call from LastPass, it's a scam
A new breed of sophisticated phishing scammers are targetting LastPass users with phone calls and emails.
Sick of ads in Windows? This ingenious program eradicates them all
This clever free tool removes all the ads that Microsoft keeps stuffing into Windows 10 and 11.
Controversial Windows 11 Start menu ads begin rolling out
Microsoft has pushed “Promoted” apps from the Store to the Windows 11 wide build just a few weeks after they started appearing to Insiders.
Ring of bogus web shops steals 850K credit card numbers
Fake online storefronts, which show up in great numbers in Google and other search engines, are becoming a big problem.
This free, ancient Windows app will watch your laptop battery
BatteryInfoView gives you the laptop battery information you didn’t know you wanted.
How to use your smartphone as a Windows 11 PC webcam
Windows 11 now allows the wireless connection of Android smartphones for use as a webcam.
How to digitize VHS tapes the cheap way
Preserve your old video tapes with an inexpensive capture card and free software.