Information of news
  • Views: 0
  • Author: god.sad
  • Date: 27-08-2016, 16:39
 (Votes #: 0)

Excel: Sort & Filter Tricks - Basics to Ninja

Category: Tutorial

Download Now

Excel: Sort & Filter Tricks - Basics to Ninja

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 .

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

"The courses are really helpful whether in terms of saving time, improving your presentation skills or getting to learn new features. The videos give you the feeling of one to one attention. Moreover, their constant attachment by emailing new tricks is highly appreciating. #thankyouteamyoda" by Arundhati Raychaudhuri, Finance Professional, India

Important information before you join:

Once enrolled, you have unlimited, lifetime access to the course!
You will have instant and free access to any updates I'll add to the course.
I will give you my full support regarding any issues or suggestions related to the course.
Guided practice worksheets included for immediate practice
Access to all videos 24 x 7 - learn online from anywhere
A 30-day money back guarantee (we want you to be 100% satisfied)

If you have read this far, next action is JOINING this course. Invest 45 mins. for a benefit of lifetime Ninja status on Excel: Sort & Filter Tricks - Basics to Ninja!
Download link:

Buy Premium From My Links To Support Me & Download with MaX SPeeD!

Direct Download

Tags: Filter, Tricks, Basics

Excel: Sort & Filter Tricks - Basics to Ninja Fast Download via Rapidshare Hotfile Fileserve Filesonic Megaupload, Excel: Sort & Filter Tricks - Basics to Ninja Torrents and Emule Download or anything related.
Dear visitor, you went to website as unregistered user.
We encourage you to Register or Login to website under your name.

Add comments

Enter Code: *