Download Now

Excel: Sort & Filter Tricks - Basics to Ninja (2016)

Excel: Sort & Filter Tricks - Basics to Ninja
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1 Hours | Lec: 16 | 327 MB
Genre: eLearning | Language: English

Learn Advanced Excel: Sort (multi-level, custom, vertical vs. horizontal), Filter shortcuts & calculations with Examples
There are numerous hidden tricks of Sort & Filter which makes data analysis and manoeuvring accurate and fast. This section focusses on:
Vertical Sort - 1-level & 2-level
Custom Sort
Sort Trick - add alternate blank rows in-between existing rows
Horizontal Sorting (Left to Right) - auto-realigning 100s of columns
Filter - Basics
Filter - Choosing the dataset correctly
Filter analysis with shortcuts
Filter - SUBTOTAL() for calculations
Filter - SUBTOTAL() 9 vs. 109 series
Filter - Applying 2 or more Filters simultaneously on the same sheet
Filter - Color Filter & Text Filter
Advanced Filter - Basics
Advanced Filter - Differential Criteria
Advanced Filter - More parameters
We have 14 videos of duration 45 mins. Through practical examples, You'll learn Ninja level application on Excel: Sort & Filter Tricks - Basics to Ninja .

Excel: Sort & Filter Tricks - Basics to Ninja (2016)



Direct Download

Tags: Filter, Tricks, Basics

Comments
Name:*
E-Mail:*
Add Comments:
Enter Code: *