Ads


» » » Excel Sort & Filter Tricks - Basics to Ninja (Updated)

Excel Sort & Filter Tricks - Basics to Ninja (Updated)

Author: thaijameupload on 12-06-2018, 11:41, Views: 86

Excel Sort & Filter Tricks - Basics to Ninja (Updated)

Excel: Sort & Filter Tricks - Basics to Ninja
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 1 Hour | Lec: 17 | 297 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 .

----------------------------------------------------------

Your Question - Why should I take this mini-course on Excel?

Our Response - Sort and Filter are the two most commonly used MIS reporting techniques. Having an in-depth knowledge helps avoid silly mistakes commonly made by professionals while using them.

Focus is also on learning hidden tips and tricks. E.g. Horizontal Sorting (Left to Right) - auto-realigning 100s of columns, Advanced filter
Do's & Don'ts




Excel Sort & Filter Tricks - Basics to Ninja (Updated)






Download link:

Buy Premium To Support Me & Get Resumable Support & Max Speed:





Links are Interchangeable - No Password - Single Extraction

  •      Views 86  |  Comments 0
    Comments
    All rights by KeygenCrackSoftware.com 2019