watching now
5 Students
191 Lessons
Beginner

#### What Will You Learn?

• Learn to use Excel at the highest level, become a professional
• You will be guided to consolidate your Excel basic Knowledge
• Look into common and new Excel formulas
• Manage large amounts of data, make your reports automatic and simplify your work routine

#### Curriculum

12h 57m
05:59
08:44
09:01
##### Section 4: Excel Zero: Text Formatting
30:14
01:21
00:55
Select, copy, paste and cut
06:07
Order, filter and remove duplicates
06:20
Find and replace
04:32
Fonts, text alignment and colors
06:12
Exercise #1 – To do List
03:34
Exercise #1 – SOLUTION
01:13
##### Section 5: Excel Zero: Formulas
20:21
Structure of elementary Excel formulas
02:26
SUM math function
04:07
UPPER, LOWER and PROPER text functions
04:11
Arithmetical operators and calculation logic
05:06
Basic date and time functions
01:52
Exercise #2 – Name and years
01:19
Exercise #2 – SOLUTION
01:20
##### Section 6: Excel Basics
01:33
Introduction to Excel Basics
01:33
##### Section 7: Excel Basics: Fundamentals
25:59
04:09
Table style formatting
07:29
Excel templates
05:13
03:38
Print preview
03:22
Exercise #3 – To do List template
00:57
Exercise #3 – Solution
01:11
##### Section 8: Excel Basics: Cells Formats
14:35
Text and special formats
02:45
Maths formats
03:33
Currency formats
02:37
Date and time formats
03:46
Percentage format
01:54
##### Section 9: Excel Basics: Formulas
15:30
Structure of basic Excel formulas
01:44
COUNTA math function
02:00