Tutorials :

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

      Author: ptitno1   |   11 June 2018   |   comments: 1

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











Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me

скачать dle 12.0




Comments (1)
  #14 Author: Josphplast, 11 June 2018 21:51


Join Date: -- Status:
К чемпионату мира по футболу Такси Москва-24 Предоставляем услуги такси по доступным ценам! Ездить с нами – комфортно! Вы можете круглосуточно вызвать наше такси. Время подачи автомобиля занимает примерно 10-15 мин Ездить с нами – выгодно! Ездить с нами - быстро! Ездить с нами - надёжно! Заказ такси в Москве от 199 р.! Аэропорты от 399 р.! Такси межгород фиксированная цена! Онлайн заказ такси со скидкой 10% Звоните мы ждём Ваших звонков круглосуточно: 8(495) 776-80-04, 8(985) 776-80-04, 8(916) 155-33-39. Мы выполняем 100% наших заказов, все клиенты остаются довольны поскольку наши партнёры это: Яндекс такси, Gett такси, Uber такси, Ситимобил такси. Ваш промокод 8U>$m7B#B
News: 0 | Comments: 0                    
Home        |        Register        |        Forums        |        RSS        |        Rules        |        DMCA Policy        |        Contact Us
DISCLAIMER
None of the files shown here are hosted or transmitted by this server. The links are provided solely by this site's users. The administrator of this site (dl4all.ws) cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms.

Copyright © 2018 Dl4All. All rights reserved.