Course Content
Chapter 1: Excel 2016 Basics
0/4
Getting Started with Excel
04:21
Understanding OneDrive
00:00
Creating and Opening Workbooks
02:34
Saving and Sharing Workbooks
03:50
Chapter 2: Working with Cells and Sheets
0/8
Cell Basics
04:28
Modifying Columns, Rows, and Cells
04:48
Formatting Cells
03:55
Understanding Number Formats
05:44
Working with Multiple Worksheets
03:54
Using Find & Replace
01:55
Checking Spelling
00:00
Page Layout and Printing
05:37
Chapter 3: Formulas and Functions
0/4
Intro to Formulas
03:38
Creating More Complex Formulas
05:51
Relative and Absolute Cell References
05:24
Basic Tips for Working with Data
Chapter 4: Working with Data
0/8
Freezing Panes and View Options
04:22
Sorting Data
04:31
Filtering Data
04:46
Data validitation
Groups and Subtotals
04:24
Tables
03:20
Charts
04:31
Conditional Formatting
03:46
Chapter 5: Doing More with Excel
0/5
Track Changes and Comments
05:31
Inspecting and Protecting Workbooks
03:12
Intro to PivotTables
04:34
Doing More with PivotTables
00:00
What-if Analysis
03:27
Projects [November 2024]
0/5
Hasan Nahi Gymnasium -Class 10
Class 8A
Class 8B
Class 8C
How to create an Powerpoint Presenation
Extras
0/2
New features in Office 2016
02:14
More Resources
00:00
Quiz
0/1
Excel Quiz
Private: MS Excel 2016
Exercise Files
21_Data Validation.pdf
Size: 1.82 MB
Previous
Next
ict04 platforma

Learning Technologies Courses

info@ict04.tech