1 Get to know Excel
Menus and settings
08:58 min
Worksheets
02:12 min
The Status Bar
01:19 min
Help
01:45 min
2 Basic functionality
Insert data
01:54 min
Navigate with the mouse
02:21 min
Navigate with the keyboard
02:03 min
Undo and Redo
02:02 min
Comments and Annotations
01:58 min
Save
01:51 min
3 Working with formulas
Create formulas
02:40 min
Create a function
02:21 min
Copy formulas
02:41 min
Complicated formulas
03:03 min
Absolute and Relative Cell References
02:54 min
AutoSum
02:19 min
Insert Function
02:59 min
4 Formatting
Visual formatting
06:38 min
Date and time
02:22 min
Format numbers
02:55 min
Conditional Formatting
03:30 min
Format table
03:12 min
5 Worksheet basics
Insert and Delete Rows and Columns
03:02 min
Hide and Unhide Rows and Columns
02:44 min
Move and Copy Data
02:35 min
Paste
03:51 min
Find and Replace
03:07 min
6 Printing
7 Charts
8 Worksheet overview
Freeze panes
02:02 min
Split windows
02:26 min
Grouping rows and columns
01:24 min
9 Manage multiple workbooks
Linking worksheets and workbooks
03:21 min
Manage links
02:26 min
Displaying multiple worksheets
02:57 min
10 Functions
The IF-function
03:25 min
VLOOKUP
03:32 min
COUNTIF
02:27 min
SUMIF
01:52 min
AVERAGEIF
02:09 min
HLOOKUP
02:53 min
Nested IF-functions
03:26 min
IFerror
02:41 min
Date functions
02:13 min
Text functions
03:29 min
XLOOKUP
Combine Functions
04:28 min
11 Security and sharing
Protect the worksheet
03:36 min
Protect the workbook
01:46 min
Password for workbooks
02:03 min
12 Working with databases
13 PivotTables
Create a PivotTable
03:21 min
Working with a PivotTable
03:04 min
Filter and slicer
03:44 min
Insert a PivotChart
02:44 min
Grouping by time
01:45 min
Grouping rows and columns
02:47 min
Refresh the PivotTable
00:58 min
Change data source
03:42 min
Create PivotTables with multiple data sources (Power Pivot)
14 Goal Seek and Macros
Goal seek
03:16 min
Create a Macro
02:47 min
Create shortcut for macro
03:25 min
Manage and remove macros
02:46 min
Quiz – Data validation
Time limit: 0
Quiz Summary
0 of 3 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Quiz complete. Results are being recorded.
Results
0 of 3 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 3
1. Question
When can the Data Validation function be useful?
CorrectIncorrect -
Question 2 of 3
2. Question
What happens when we need to insert a value outside a predefined range?
CorrectIncorrect -
Question 3 of 3
3. Question
True/False: We can include more than 20 possible answers in the drop down list.
CorrectIncorrect