Главная
Study mode:
on
1
Start
2
Flash Fill
3
List Design & Single Level Sorting
4
Multi-Level Sorting
5
Custom Sorting
6
Filtering
7
Multi-Level Filtering
8
Search Filtering
9
Format as Table
10
Table Style Options
11
Remove Duplicates
12
Convert to Range
13
Subtotal
14
Multi-Level Subtotaling
15
Remove Subtotals
16
Quick Analysis Charts
17
Inserting Data Charts
18
Formatting Data Charts
19
Chart Templates
20
Sparklines
21
Printing Charts
22
Importing From Web
23
MS Query
24
Exporting Overview
25
Pivot Tables
26
Multiple-Field Pivot Tables
27
Drill Down Reports
28
Pivot Charts & Grouping Fields
29
Slicer Tool
30
Data Validation
31
Additional Data Validation
32
Cell & Sheet Protection
33
File Encryption
34
Conditional Formatting
35
Linking Data
36
Inserting Comments
Description:
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.

Excel 2016 Intermediate Tutorial

Learnit Training
Add to list
0:00 / 0:00