Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel 2016 Intermediate Tutorial

Learnit Training via YouTube

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Dive into this comprehensive 2-hour 36-minute intermediate Excel 2016 tutorial to enhance your data organization and analysis skills. Learn advanced techniques such as flash fill, multi-level sorting and filtering, table formatting, and pivot table creation. Master the art of data visualization with various chart types, including sparklines and pivot charts. Explore data validation, cell protection, and file encryption for improved data integrity and security. Discover how to import data from the web, use MS Query, and implement conditional formatting. Perfect for current Excel users looking to expand their capabilities, this tutorial provides hands-on exercises and covers a wide range of topics to boost your productivity and efficiency in Excel 2016.

Syllabus

Start
Flash Fill
List Design & Single Level Sorting
Multi-Level Sorting
Custom Sorting
Filtering
Multi-Level Filtering
Search Filtering
Format as Table
Table Style Options
Remove Duplicates
Convert to Range
Subtotal
Multi-Level Subtotaling
Remove Subtotals
Quick Analysis Charts
Inserting Data Charts
Formatting Data Charts
Chart Templates
Sparklines
Printing Charts
Importing From Web
MS Query
Exporting Overview
Pivot Tables
Multiple-Field Pivot Tables
Drill Down Reports
Pivot Charts & Grouping Fields
Slicer Tool
Data Validation
Additional Data Validation
Cell & Sheet Protection
File Encryption
Conditional Formatting
Linking Data
Inserting Comments

Taught by

Learnit Training

Reviews

Start your review of Excel 2016 Intermediate Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.