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
About Lesson

As you learned in our previous lesson, Intro to PivotTables, PivotTables can be used to summarize and analyze almost any type of data. To help you manipulate your PivotTable—and gain even more insight into your data—Excel offers three additional tools: filters, slicers, and PivotCharts.

Optional: Download our practice workbook. <–Click Here

Exercise Files
29_Doing More with PivotTables.pdf
Size: 1.10 MB
Previous
Next
ict04 platforma

Learning Technologies Courses

info@ict04.tech