Excel Essentials
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
02:09 min
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)
05:57 min
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
Visualising Calculations
Share
Share "Visualising Calculations"
Share a link to someone who will get access to this lesson for 24 hours.
Share "Visualising Calculations"
Share a link to someone who will get access to this lesson for 24 hours.
In this lesson, you will learn how to visualise a trendline using moving averages.
Trendlines are especially useful for when we have large discrepancies between points of data over time.
Quizzes