Excel - The absolute basics, How to use the Sum function in Excel
Welcome to Excel the absolute basics where we are going to look at several different way to use the sum function in excel as well as a whistle-stop tour on the interface, and how to use Excel as a simple calculator.
Although Excel is used in this video, it should work for most spreadsheet applications.
This video is real absolute beginner video, so if you have never used Excel but want to know how to use it, this is the starting video for you with some practical tasks too.
Chapters: (In progress)
0:00 Intro
0:58 What is Excel
2:42 Quick interface orientation
3:50 Zooming in and out of Spreadsheet
4:20 How big is the spreadsheet?
5:14 Adding and renaming sheets (including mini exercise)
7:02 Simple maths like a calculator
7:54 What happens if you miss out the equals sign
9:14 The serial date error
11:30 Cut and paste data example
12:59 Simple math exercise
15:15 Adding text to the spreadsheet
16:42 Basic cell referencing for calculations
17:42 Slightly faster way to total cells (clicking cells)
18:25 Using the sum function the worst way
19:35 Sum function with ranges
22:07 The AutoSum function
23:35 Using the AutoSum shortcut
24:31 Mini exercise
26:13 Outro