Techy Stuff
17.3K views | +0 today
Follow
Techy Stuff
Interesting tech links for the Geeks and wannabees
Curated by Patty Ball
Your new post is loading...
Your new post is loading...
Scooped by Patty Ball
Scoop.it!

Analyze your data instantly - Excel

Analyze your data instantly - Excel | Techy Stuff | Scoop.it
Learn about data analysis at your fingertips. Quickly create a chart to visualize your data, add sparklines to show data trends, create a PivotTable for in-depth data analysis, apply conditional forma...
No comment yet.
Scooped by Patty Ball
Scoop.it!

[PT4] Why you should use a table for your pivot table

[PT4] Why you should use a table for your pivot table | Techy Stuff | Scoop.it
No comment yet.
Scooped by Patty Ball
Scoop.it!

Tip: How to sort a pivot table with a custom list

Tip: How to sort a pivot table with a custom list | Techy Stuff | Scoop.it
Patty Ball's insight:

lots of info about Excel Pivot Tables; videos, tips

No comment yet.
Scooped by Patty Ball
Scoop.it!

How to Generate Multiple Reports from One Pivot Table

How to Generate Multiple Reports from One Pivot Table | Techy Stuff | Scoop.it
You can generate multiple reports from one Pivot Table when you take advantage of the Report Filter drop zone. With just a few mouse clicks, generate the reports
No comment yet.
Scooped by Patty Ball
Scoop.it!

How to Set Up a Pivot Table as a Spreadsheet Database

Excel 2010 allows worksheet formulas to use Pivot Tables as a massive and powerful spreadsheet database, even with PowerPivot. Here’s how set it up.
No comment yet.
Scooped by Patty Ball
Scoop.it!

Excel Pivot Table Summary Functions

Excel Pivot Table Summary Functions | Techy Stuff | Scoop.it
When fields are added to pivot table Values area, the default summary funtion is Sum or Count. Later, you can change to other functions.
No comment yet.
Scooped by Patty Ball
Scoop.it!

Excel 2010: Lesson 20 - Creating PivotTables

Excel 2010: Lesson 20 - Creating PivotTables | Techy Stuff | Scoop.it
Organize, analyze and chart data with the new innovations in Microsoft's spreadsheet software Excel 2010.
No comment yet.
Scooped by Patty Ball
Scoop.it!

Running Totals Are Easy With Excel Pivot Tables | Contextures Blog

Running Totals Are Easy With Excel Pivot Tables | Contextures Blog | Techy Stuff | Scoop.it
No comment yet.
Scooped by Patty Ball
Scoop.it!

Demystify Excel's PivotTable feature with this simple method | TechRepublic

Demystify Excel's PivotTable feature with this simple method | TechRepublic | Techy Stuff | Scoop.it
If you can see your data as groups, values, and filters, you can create a useful pivot table in just a couple of minutes.
No comment yet.