DataPig Technologies Excel Tutorials | 1F0BF5EDDF511519A769545CA433046AA9E64B58

DataPig Technologies Excel Tutorials

Name	DataPig Technologies - Excel Tutorials	DOWNLOAD Copy Link
Total Size	218.0 MB
Total Files	84
Hash	1F0BF5EDDF511519A769545CA433046AA9E64B58

/1.0 Basic Excel Concepts/
1.1 Using Paste Special.swf	2.0 MB
1.10 Formatting Tricks.swf	1.6 MB
1.11 Grouping Tabs to Save Time.swf	1.6 MB
1.12 Conditional Format with Four Conditions.swf	820.0 KB
1.2 Using Text to Columns.swf	2.9 MB
1.3 Tips on Filtering with AutoFilter.swf	2.6 MB
1.4 Using Goal Seek.swf	1.0 MB
1.5 Data Validation in Excel.swf	2.4 MB
1.6 About Conditional Formatting.swf	2.9 MB
1.7 Basics of Protecting a Worksheet.swf	1.2 MB
1.8 Basics of Using Subtotals.swf	4.0 MB
1.9 Basics of Print Setup Options.swf	2.9 MB
/2.0 All About Pivot Tables/
2.1 Create a Basic Pivot Table.swf	4.6 MB
2.10 Synchronize 2 Pivot Tables with a Combo Box.swf	5.3 MB
2.11 Tie a Chart to a Pivot Table.swf	2.5 MB
2.12 All About Multiple Consolidation Ranges.swf	6.3 MB
2.13 Pivot Table Based Conditional Chart.swf	4.2 MB
2.14 Add Dynamic Icons to Pivot Table Reports.swf	6.3 MB
2.15 Pivot Tables and Spreadsheet Bloat.swf	4.4 MB
2.2 Sorting in a Pivot Table.swf	2.3 MB
2.3 Create a Drill Down Effect with a Pivot Table.swf	1.1 MB
2.4 Adding a Calculated Field in a Pivot Table.swf	1.7 MB
2.5 Grouping in a Pivot Table.swf	1.0 MB
2.6 Creating Pivot Charts.swf	2.2 MB
2.7 Using Pivot Table Advanced Options.swf	2.3 MB
2.8 Convert Pivot Tables Into Hard Data.swf	4.3 MB
2.9 Table Structures Good and Not So Good.swf	9.8 MB
Sample Add-in.zip	24.7 KB
/3.0 All About Charts/
3.1 Formatting Charts.swf	2.9 MB
3.10 Create a Scrolling Chart (Offset Function).swf	3.9 MB
3.11 Create a Basic Speedometer Chart.swf	6.4 MB
3.12 Create a Thermometer Effect in you Column Charts.swf	1.8 MB
3.13 Quick and Easy Organizational Chart.swf	5.5 MB
3.14 Creating a Delta Chart.swf	4.7 MB
3.15 Creating a Benchmark Chart.swf	2.7 MB
3.16 Use Excel Charts in PowerPoint Without Bloat.swf	3.3 MB
3.2 Combo Charts and Formatting Data Points.swf	1.7 MB
3.3 Create Dynamic Chart Labels.swf	1.2 MB
3.4 Create a Histogram Chart.swf	2.2 MB
3.5 Create a Basic Water Fall Chart.swf	3.4 MB
3.6 Using the Bar to Pie Chart.swf	1.8 MB
3.7 Add Average Line to a Chart.swf	747.2 KB
3.8 Invert Negatives in a Chart.swf	887.5 KB
3.9 Get Graphical without Charts.swf	3.8 MB
/4.0 Advanced Excel Functions/
4.1 Alternate Shading with Conditional Formatting.swf	1.1 MB
4.10 Using the COUNTIF() to Find Duplicates.swf	2.7 MB
4.11 Set Duplicates Warning with Data Validation.swf	1.2 MB
4.12 Basics of Nested Formulas.swf	1.4 MB
4.13 Conditional Sums and Array Formulas.swf	3.5 MB
4.14 Formula to convert your dates to quarters.swf	388.0 KB
4.15 Using the SUBTOTALS Function.swf	2.0 MB
4.16 Sort by Color without an Add-in.swf	4.4 MB
4.17 Turn a Row Oriented Dataset into a Column Oriented Dataset.swf	2.3 MB
4.18 Dynamic Ranges Finally Explained.swf	2.7 MB
4.19 Sort by Capitalization.swf	620.5 KB
4.2 VLOOKUP formulas made easy.swf	3.4 MB
4.3 Matrix Lookup Formula (Index and Match).swf	3.6 MB
4.4 Cell Information Functions.swf	2.2 MB
4.5 Text and String Functions.swf	2.3 MB
4.6 Formula to Convert Trailing Minus Signs.swf	3.0 MB
4.7 Using IF(AND()) & IF(OR()).swf	2.7 MB
4.8 Increase Available Undo Actions.swf	1.8 MB
4.9 Using the SumProduct() Function.swf	2.1 MB
/5.0 Building Excel Applications/
5.1 All About Recording Macros.swf	3.8 MB
5.2 Cleaning up your Macro generated VBA.swf	2.0 MB
5.3 Using Spreadsheet Form Controls.swf	4.1 MB
5.4 Using Macros to create a user interface.swf	2.9 MB
5.5 Send Emails with SENDEMAIL method.swf	2.7 MB
5.6 Create your First User Form (Create a Splash Screen).swf	3.1 MB
5.7 Calling up Excel Dialog Boxes.swf	993.3 KB
5.8 Force Users to Enable Macros.swf	2.4 MB
Fun Spreadsheet that does Magic Tricks.xls	393.2 KB
/6.0 Getting Started with VBA/
6.1 Quick overview of VBA.swf	3.4 MB
6.2 Understanding Reference Libraries.swf	1.1 MB
6.3 Declaring Variables.swf	2.1 MB
6.4 Using If Statements.swf	1.8 MB
6.5 Using Select Case Statements.swf	885.9 KB
6.6 The Basics of the Do Loops.swf	1.9 MB
6.7 Using For Next Loops.swf	1.6 MB
6.8 Looping with For Each Statements.swf	2.2 MB
/Player/
Irfanview 3.9.8 Plugins.exe	5.2 MB
Irfanview 3.9.8.exe	905.7 KB
/
Read! (For Real).txt	1.2 KB
tracked_by_h33t_com.txt	0.0 KB
Total files 84