TutorialsPublished by : LeeAndro | Date : 14-06-2018 | Views : 25
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


Dislike

Bookmark and Share This Post :



Please feel free to post your Excel: Sort & Filter Tricks - Basics to Ninja (updated) Download, Movie, Game, Software, Mp3, video, subtitle, sample, torrent, NFO, Crack, uploaded, putlocker, Rapidgator, mediafire, Netload, Zippyshare, Extabit, 4shared, Serial, keygen, Watch online, requirements or whatever-related comments here. 

Information
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.