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
  • Follow the exercises and upgrade your Excel projects

Curriculum

12h 57m
Section 4: Excel Zero: Text Formatting
30:14
Create your first words list
01:21
Create your first numbers list
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
Header and Footer
04:09
Table style formatting
07:29
Excel templates
05:13
Hyperlinks
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