top of page
ICT
1
2
3
EXCEL 2016
VIDEOS
​
​
​​​
​
Excel 2016 Basics
1 Getting Started with Excel
2 Understanding OneDrive
3 Creating and Opening Workbooks
4 Saving and Sharing Workbooks
​
Working with Cells and Sheets
5 Cell Basics
6 Modifying Columns, Rows, and Cells
7 Formatting Cells
8 Understanding Number Formats
9 Working with Multiple Worksheets
10 Using Find & Replace
11 Checking Spelling
12 Page Layout and Printing
Formulas and Functions
13 Intro to Formulas
14 Creating More Complex Formulas
15 Relative and Absolute Cell References
16 Functions
Working with Data
17 Basic Tips for Working with Data
18 Freezing Panes and View Options
19 Sorting Data
20 Filtering Data
21 Groups and Subtotals
22 Tables
23 Charts
24 Conditional Formatting
Doing More with Excel
25 Track Changes and Comments
26 Inspecting and Protecting Workbooks
27 Intro to PivotTables
28 Doing More with PivotTables
29 What-if Analysis
​
​
​
bottom of page