Time
6 hours 3 minutes
Difficulty
Beginner
CEU/CPE
6

Video Transcription

00:00
So before we do the recap of this module, let's do a short quiz in which you could remind yourself about some things. You have been able to learn this module
00:11
and before. So the first question is, what do you need to press on your keyboard to start editing the cell?
00:19
And the possible answers are
00:24
control E.
00:27
I have to,
00:29
or a five
00:31
a couple seconds to think. The correct answer is I have to.
00:36
And the next question is what happens when you d wide with zero in formula
00:41
possible As our excell crashes,
00:45
hashtag signs are displayed in the cell or division by zero is playing the cell on the correct answer is division by zeros displayed? So
00:54
So in this module you have learned about what the formulas are. How are they entered?
01:00
How do you do the correction of formula?
01:03
How do you turn on or off automatic recalculation
01:08
types of formula? So I mentioned that there are three types of four types major types the Met, the formulas, the text formulas, logical formulas and,
01:19
uh, look up formulas.
01:23
And then you have the unseen how to do the air checking and evaluation of the formula.
01:32
So
01:33
you have now know how to do the and how to enter formulas in excel
01:40
and in further models. We're going to talk about further use off formulas, but also other things the regarding excel itself and the usage of it.

Up Next

Intro to Excel

This basic Excel training course will give you knowledge of Excel and the ability to use this software to do elementary calculations, file manipulation, data manipulation, to create charts, pivot tables and templates.

Instructed By

Instructor Profile Image
Milan Cetic
IT Security Consultant
Instructor