There are no items in your cart
Add More
Add More
| Item Details | Price | ||
|---|---|---|---|
Data Analysis Program
"Unlock the power of data with my comprehensive Data Analysis Program and turn numbers into valuable insights!"
Instructor: Rajesh Pathak
Language: English
Validity Period: 365 days
$20
1 Specialskills.in Coins as Cashback
Learn data analysis using MS Excel's powerful tool 'Pivot Table'.
Additionally, you will also learn many data cleaning techniques which will help you to create useful pivot tables for your data.
What you will learn:
1. Setting up your data for pivot tables
2. Creating pivot tables for different scenarios
3. Working with pivot table tools
4. Exploring different pivot table options
5. Exploring pivot table styles
6. Using advanced slicers, timelines and conditional formatting techniques in pivot tables
7. Creating pivot chart and handling Get Pivot Data and Pivot Cache.
8. Sorting, filtering and grouping of pivot tables using several scenarios
9. Learning about calculated fields and items and value field settings
This program is available in both downloadable and eLearning modes.
*For 'Windows' computers only.
You will have 365 days of immediate access to online video tutorials.
Additionally, post payment, please send an email to contact@specialskills.in to get your downloadable eBooks, Excel practice files and HD video tutorials.
* Trainer will provide offline support via WhatsApp, email and on phone.
You will get the following:
1. 123 downloadable + Online HD videos of data analysis with pivot table
2. 14 downloadable + Online HD videos of data cleaning
3. 130+ downloadable practice 'Excel' files used in the Program
4. 130+ downloadable eBooks containing step-by- step instructions
5. Program duration is 6 hours and 21 minutes approx.
6. Certificate of completion
7. Quiz
| Data Analysis with Pivot Table | |||
| Pivot Example 4:00 | Preview | ||
| Practice file | |||
| Arranging Data-Tabular Format 2:00 | Preview | ||
| Practice file | |||
| Arranging Data-No Gaps in the data 2:00 | |||
| Practice file | |||
| Arranging data-no subtotals in the data 14:00 | |||
| Practice file | |||
| Arranging data-always use excel tables 3:00 | |||
| Practice file | |||
| Arranging data-formatting 2:00 | |||
| Practice file | |||
| Arranging data-remove spaces 3:00 | |||
| Practice file | |||
| Arranging data-count the data first 3:00 | |||
| Practice file | |||
| Create pivot table 3:00 | |||
| Practice file | |||
| Field list- activate field list 2:00 | |||
| Practice file | |||
| Field list-Move field list 2:00 | |||
| Practice file | |||
| Field list-resize field list 2:00 | |||
| Practice file | |||
| Field list- field list views options 2:00 | |||
| Practice file | |||
| Field list-field list and areas 2:00 | |||
| Practice file | |||
| Field list-renaming field 2:00 | |||
| Practice file | |||
| Field list-duplicate field name 2:00 | |||
| Practice file | |||
| Field list-adjust the column position 2:00 | |||
| Practice file | |||
| Copy as picture 3:00 | |||
| Practice file | |||
| Copy as values 2:00 | |||
| Practice file | |||
| Copy as new pivot table 2:00 | |||
| Practice file | |||
| Exploring subtotal options 6:00 | |||
| Practice file | |||
| Exploring grand total options 6:00 | |||
| Practice file | |||
| Exploring report layout options 7:00 | |||
| Practice file | |||
| Exploring blank rows options 2:00 | |||
| Practice file | |||
| Exploring pivot table styles 3:00 | |||
| Practice file | |||
| Analyze tab 15:00 | |||
| Practice file | |||
| Show details 2:00 | |||
| Practice file | |||
| Slicers Introduction 18:00 | Preview | ||
| Practice file | |||
| PT Connections1 14:00 | |||
| Practice file | |||
| PT Connections2 15:00 | |||
| Practice file | |||
| PT Connections3 14:00 | |||
| Practice file | |||
| Add Search Box To A Slicer 14:00 | |||
| Practice file | |||
| Create slicer to filter another slicer 16:00 | |||
| Practice file | |||
| Protect worksheet, not the slicer 12:00 | |||
| Practice file | |||
| Slicer Styles 19:00 | |||
| Practice file | |||
| Slicer Settings 16:00 | |||
| Practice file | |||
| Custom slicer for year and month 12:00 | |||
| Practice file | |||
| Timeline 13:00 | |||
| Practice file | |||
| CF in Pivot Table 7:00 | |||
| Practice file | |||
| Pivot chart 7:00 | |||
| Practice file | |||
| Defer layout update 11:00 | |||
| Practice file | |||
| Getpivotdata Intro 14:00 | |||
| Practice file | |||
| Custom Report 17:00 | |||
| Practice file | |||
| Pivot Cache 27:00 | |||
| Practice file | |||
| With Source Data | |||
| Without Source Data | |||
| DSD-Without Source Data | |||
| Save source data with file | |||
| Keep source data in another file | |||
| Use external data source | |||
| Clone | |||
| Sharing cache and clone | |||
| Add one blank row | |||
| Create copy of source | |||
| Old pivot wizard | |||
| Copy to a new workbook | |||
| Multiple range names | |||
| Grouping-Practice file | |||
| Count number of pivot caches | |||
| Clear pivot cache old items 11:00 | |||
| Practice file | |||
| Refresh Pivot Table-Non macro 11:00 | |||
| Practice file | |||
| Refresh Pivot Table-With macro 15:00 | |||
| Practice file | |||
| Sort ascending or descending 11:00 | |||
| Practice file | |||
| Sort an item row left to right 11:00 | |||
| Practice file | |||
| Sort manually (drag, type, right click) 11:00 | |||
| Practice file | |||
| Sort using a custom list 12:00 | |||
| Practice file | |||
| Override a custom list sort 12:00 | |||
| Practice file | |||
| Sort regions in ascending order 11:00 | |||
| Practice file | |||
| Sort new items added 11:00 | |||
| Practice file | |||
| Clear a sort 10:00 | |||
| Practice file | |||
| Sort L to S grand totals 10:00 | |||
| Practice file | |||
| Filter by dates 16:00 | |||
| Practice file | |||
| Filter by text labels 14:00 | |||
| Practice file | |||
| Filter by numerical text labels 12:00 | |||
| Practice file | |||
| Value Filters 17:00 | |||
| Practice file | |||
| Filter by report filter 13:00 | |||
| Practice file | |||
| Keep or hide selected items 10:00 | |||
| Practice file | |||
| Filter by wildcards 12:00 | |||
| Practice file | |||
| Filter by multiple fields 11:00 | |||
| Practice file | |||
| Apply multiple filters 11:00 | |||
| Practice file | |||
| Filter by multiple values 11:00 | |||
| Practice file | |||
| Include new items 12:00 | |||
| Practice file | |||
| Clear multiple filters 11:00 | |||
| Practice file | |||
| Add filters to the column 10:00 | |||
| Practice file | |||
| Grp by month and months and years 11:00 | |||
| Practice file | |||
| Group by months and quarters 10:00 | |||
| Practice file | |||
| Group by quarters 10:00 | |||
| Practice file | |||
| Group by quarters & years 11:00 | |||
| Practice file | |||
| Group by years 10:00 | |||
| Practice file | |||
| Grouping by half years 11:00 | |||
| Practice file | |||
| Group by time 12:00 | |||
| Practice file | |||
| Group by week 12:00 | |||
| Practice file | |||
| Group by date 12:00 | |||
| Practice file | |||
| Grouping by a custom date 11:00 | |||
| Practice file | |||
| Errors when grouping by dates 13:00 | |||
| Practice file | |||
| Display dates that have no data 11:00 | |||
| Practice file | |||
| Group columns 13:00 | |||
| Practice file | |||
| Group numbers vs text 11:00 | |||
| Practice file | |||
| Group by text fields 11:00 | |||
| Practice file | |||
| Group by sales ranges 12:00 | |||
| Practice file | |||
| Calculated field 15:00 | |||
| Practice file | |||
| A new calc field from an existing calc field 11:00 | |||
| Practice file | |||
| Excel formulas in calculated fields 12:00 | |||
| Practice file | |||
| Creating a calculated item 16:00 | |||
| Practice file | |||
| Calculated item on column labels 12:00 | |||
| Practice file | |||
| Cal Field vs Cal Item 1:00 | |||
| Practice file | |||
| Create new cal. item using existing one 12:00 | |||
| Practice file | |||
| Excel formulas and calculated items 12:00 | |||
| Practice file | |||
| Solve order for calculated items 15:00 | |||
| Practice file | |||
| List calc field and item formulas 6:00 | |||
| Practice file | |||
| Order of operations 12:00 | |||
| Practice file | |||
| Shortcomings of calculated items 12:00 | |||
| Practice file 1,2,3 | |||
| Practice file 4,5,6 | |||
| Practice file 7 | |||
| Practice file 8,9 | |||
| VFS Intro 3:00 | |||
| Practice file | |||
| VFS- Create multiple subtotals 11:00 | |||
| Practice file | |||
| VFS - Count 7:00 | |||
| Practice file | |||
| VFS - Average 12:00 | |||
| Practice file | |||
| VFS- Maximum 11:00 | |||
| Practice file | |||
| VFS- Minimum 11:00 | |||
| Practice file | |||
| VFS- Product 13:00 | |||
| Practice file | |||
| VFS- Count Numbers 12:00 | |||
| Practice file | |||
| VFS - Show multiple grand totals 12:00 | |||
| Practice file | |||
| VFS- See all pivot items 18:00 | |||
| Practice file | |||
| VFS- Show a unique count 20:00 | |||
| Practice file | |||
| Percentage of grand total 12:00 | |||
| Practice file | |||
| Percentage of column total 12:00 | |||
| Practice file | |||
| Percentage of row total 11:00 | |||
| Practice file | |||
| Percentage of 13:00 | |||
| Practice file | |||
| Percentage of parent row total 13:00 | |||
| Practice file | |||
| Percentage of parent column total 11:00 | |||
| Practice file | |||
| Percentage of parent total 12:00 | |||
| Practice file | |||
| Difference from 15:00 | |||
| Practice file | |||
| Percentage Difference from 15:00 | |||
| Practice file | |||
| Running total in 12:00 | |||
| Practice file | |||
| Percentage Running total in 12:00 | |||
| Practice file | |||
| Rank smallest to largest 11:00 | |||
| Practice file | |||
| Rank largest to smallest 11:00 | |||
| Practice file | |||
| Index 14:00 | |||
| Practice file | |||
| Data Cleaning Techniques | |||
| Change case using upper,proper,lower 11:00 | Preview | ||
| Practice file | |||
| Remove spaces using TRIM 12:00 | Preview | ||
| Practice file | |||
| Using LEN Function 11:00 | |||
| Practice file | |||
| Extracting text, number, values 12:00 | |||
| Practice file | |||
| Adding leading zeroes 12:00 | |||
| Extracting numbers and names 12:00 | |||
| Practice file | |||
| Extract single digits and abbreviations 12:00 | |||
| Practice file | |||
| Converting symbols to values 10:00 | |||
| Practice file | |||
| Find Replace Basic Examples 11:00 | |||
| Practice file | |||
| Replace first hyphen 11:00 | |||
| Practice file | |||
| Replace 2nd hyphen 10:00 | |||
| Practice file | |||
| Wild Card Asterisk 11:00 | |||
| Practice file | |||
| Wild Card Question mark 11:00 | |||
| Practice file | |||
| Wild Card Tilde 11:00 | |||
| Practice file | |||
After successful purchase, this item will be immediately added to your courses. Please send an email to contact@specialskills.in to get downloadable HD videos+eBooks+Excel practice files for your enrolled course/s.
You can access your courses in the following ways:
- From Computer, you can access your courses after successful login.
- For other devices, you can access your library using this web app through the browser of your device.
Please read and understand Refund Policy
Reviews
Other Courses
Launch your Graphy