Excel 2016 Intermediate




About this tutorial:

Video duration: 2:36:27
Public Class:
Use Promo Code for 75% Off One Class: YOUTUBE75

Private Class:

Exercise Files:

Manuals:
Username: manuals
Password: password

Flash Fill 0:03
List Design & Single Level Sorting 2:28
Multi-Level Sorting 4:52
Custom Sorting 8:20
Filtering 11:33
Multi-Level Filtering 15:40
Search Filtering 17:34
Format as Table 21:47
Table Style Options 25:13
Remove Duplicates 29:12
Convert to Range 34:07
Subtotal 34:51
Multi-Level Subtotaling 40:32
Remove Subtotals 42:59
Quick Analysis Charts…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

4 thoughts on “Excel 2016 Intermediate

    Nima Haghighi

    (October 22, 2019 - 1:31 am)

    I tried opening the exercise file, but it says invalid link when I click on it.

    Jeremy Harper

    (October 22, 2019 - 1:31 am)

    Can I access the workfile somewhere?

    Josh Mower

    (October 22, 2019 - 1:31 am)

    I appreciate the rationale behind the Excel reasoning/logic!

    Ujjal Mondal

    (October 22, 2019 - 1:31 am)

    if in vlookup lookup data is in 1st column where we starting the table arrey what would be table index no?

Leave a Reply

Your email address will not be published. Required fields are marked *