Excel 2013 Pivot Tables In Depth Training

Excel 2013: Pivot Tables in Depth

Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data.

Topics include:
Creating a PivotTable
Summarizing multiple data fields
Managing subtotals and grand totals
Grouping PivotTable fields
Filtering with selections, rules, slicers, and search filters
Applying PivotTable styles
Formatting cells
Creating PivotCharts
Enabling PowerPivot
Using DAX operators
Visualizing data with matrices, cards, and tiles
Building charts and maps

HugeFiles
0._Introduction.rar - 10.5 MB
1._Creating_and_Pivoting_PivotTables.rar - 49.9 MB
2._Summarizing_PivotTable_Data.rar - 32.2 MB
3._Sorting_and_Filtering_PivotTable_Data.rar - 43.9 MB
4._Formatting_PivotTables.rar - 22.8 MB
5._Applying_Conditional_Formats_to_PivotTables.rar - 52.2 MB
6._Creating_and_Manipulating_PivotCharts.rar - 27.1 MB
7._Printing_PivotTables.rar - 16.9 MB
8._Manipulating_PivotTables_Using_Macros.rar - 14.1 MB 9._Starting_with_PowerPivot_and_the_Data_Model25m_44s.rar - 35.1 MB
10._Introducing_Data_Analysis_Expressions.rar - 28.5 
11._Visualizing_Power_View_Data_Using_Matrices__Cards__and_Tiles.rar - 26.1 MB
12._Visualizing_Power_View_Data_Using_Charts_and_Maps.rar - 20.4 MB
Conclusion.rar - 1017 KB
Exercise_Files.rar - 2.3 MB

Tusfiles
0. Introduction.rar - 10.5 MB
1. Creating and Pivoting PivotTables.rar - 49.9 MB
2. Summarizing PivotTable Data.rar - 32.2 MB
3. Sorting and Filtering PivotTable Data.rar - 43.9 MB
4. Formatting PivotTables.rar - 22.8 MB
5. Applying Conditional Formats to PivotTables.rar - 52.2 MB
6. Creating and Manipulating PivotCharts.rar - 27.1 MB
7. Printing PivotTables.rar - 16.9 MB
8. Manipulating PivotTables Using Macros.rar - 14.1 MB
9. Starting with PowerPivot and the Data Model25m 44s.rar - 35.1 MB
10. Introducing Data Analysis Expressions.rar - 28.5 MB
11. Visualizing Power View Data Using Matrices_ Cards_ and Tiles.rar - 26.1 MB
12. Visualizing Power View Data Using Charts and Maps.rar - 20.4 MB
Conclusion.rar - 1017 KB
Exercise Files.rar - 2.3 MB

Go4Up

http://q.gs/884Z9

http://q.gs/884ZA

http://q.gs/884ZB

http://q.gs/884ZC

http://q.gs/884ZD

http://q.gs/884ZE

http://q.gs/884ZF

http://q.gs/884ZG

http://q.gs/884ZH

http://q.gs/884ZI

http://q.gs/884ZJ

http://q.gs/884ZK

http://q.gs/884ZL

http://q.gs/884ZM

http://q.gs/884ZN

http://q.gs/884ZO

Read More

Total Training for Adobe® Photoshop® CS6 Extended Essentials

Total Training for Adobe Photoshop CS6 Extended Essentials

Chapter 1: GETTING STARTED (41 min)

Exploring the Interface & Panels
Switching & Customizing Workspaces
Using the Tools Panel & Options Bar
Creating & Opening New Documents
Zooming & Changing Document Views
Saving Documents


Chapter 2: MAKING SELECTIONS (49 min)

Working with Basic Selection Tools
Working with the Lasso Tools
Using the Magic Wand Tool
Using the Quick Selection Tool
Using the Refine Edge Command


Chapter 3: NON-DESTRUCTIVE EDITING & WORKING WITH LAYERS (35 min)

Making Panoramic Pictures with Photomerge
Creating a Layer Mask with Quick Mask Mode
Moving Images to Other Documents & Using Free Transform
Working with Layer Masks & Applying an Adjustment Layer
Creating a Grayscale Image with Actions


Chapter 4: CREATING COMPOSITE IMAGES (66 min)

Arranging Multiple Open Documents On-screen
Loading a Selection & Pasting into a Selection
Creating an Adjustment Layer with a Layer Mask
Working with a Hue Saturation Adjustment Layer
Merging Photos with the Merge to HDR Pro Command
Using Content Aware Fill
Working with the Patch Tool
Using the Gradient Tool to Combine Picture Elements into a New Picture
Working with Layer Styles, Fill Opacity & Opacity
Exploring the Filter Gallery
Adjusting Composited Images using Layer Effects


Chapter 5: DESIGNING WITH TYPE (75 min)

Defining the Project
Brainstorming the Project
Creating Guides
Placing Images
Working with Text
Adding Layer Styles to Text
Designing for a Different Audience
Improving the Design Layout with Filters
Using the New Content-Aware Move Command
Converting Text to a Shape


Chapter 6: RESTORING & CORRECTING PHOTOS & EXPLORING BLENDING MODES (54 min)

Scanning an Image
Using the Spot Healing Brush Tool
Using the Healing Brush Tool
Using the Patch Tool & Clone Stamp Tool
Using Content Aware with the Patch Tool
Applying an Action from the Actions Panel
Understanding Blending Modes
Using Blending Modes to Colorize an Image


Chapter 7: DRAWING & PAINTING IN PHOTOSHOP (51 min)

Reviewing the Drawing Modes
Using the Pen Tool
Drawing & Altering Shapes
Exploring the Brush Panel
Painting with Brushes
Applying the Oil Paint Filter


Chapter 8: USING ADOBE BRIDGE (12 min)

An Overview of Adobe Bridge
Using Automated Tasks


Chapter 9: CREATING A WEB PHOTO GALLERY (26 min)

Using the Histogram Panel
Using Auto Adjustments
Improving Image Composition with Cropping
Creating a Web Photo Gallery
Credits

Chapter 1: GETTING STARTED (41 min)
Chapter 2: MAKING SELECTIONS (49 min)
Chapter 3: NON-DESTRUCTIVE EDITING & WORKING WITH LAYERS (35 min)
Chapter 4: CREATING COMPOSITE IMAGES (66 min)
Chapter 5: DESIGNING WITH TYPE (75 min)
Chapter 6: RESTORING & CORRECTING PHOTOS & EXPLORING BLENDING MODES (54 min)
Chapter 7: DRAWING & PAINTING IN PHOTOSHOP (51 min)
Chapter 8: USING ADOBE BRIDGE (12 min)
Chapter 9: CREATING A WEB PHOTO GALLERY (26 min)

Read More