Main Menu

 Home 

 Software 
    - Driver 
    - Graphic & Design 
    - Internet 
    - MacOSX 
    - Multimedia 
    - Office 
    - Portable 
    - Security 
    - System 

 Music 
    - Mp3 
    - Music Video 

 Games 
    - PC 
    - Console 

 Books 
    - Audiobook 
    - Comic 
    - eBook 
    - Magazine 
    - Video Training 

 Movies 
    - Amine 
    - Cam 
    - DVD 
    - HD/BluRay 
    - TV Show 
    - Documentary 

 Graphics 
    - 3D Model 
    - icon 
    - Font 
    - Footage 
    - Photoshop 
    - Template 
    - Vector 
    - Stock 
    - Script/Plugin 
    - Wallpaper 

 Mobile 
    - iOS 
    - Android 
 
 
 
   Books / Video Training : Excel: Sort & Filter Tricks - Basics to Ninja (updated)
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

Vertical Sort - 1-level & 2-level

Sort Trick - add alternate blank rows in-between existing rows


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

DOWNLOAD
uploadgig


nitroflare


rapidgator


turbobit
 

 

Back to Top