Vogue IT
Microsoft Excel (Intermediate)
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Prerequisites

Course sections

Section 1
Absolute references
1
Absolute cell references
Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112 Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112
2
Using the $ sign
Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112 Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112
Section 2
Range names
1
Creating range names
Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112 Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112
2
Editing/deleting range names
Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112 Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112
Section 3
Conditional formulae
1
Creating a single =IF formula
Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112 Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112
2
Using =SUMIFS and =COUNTIFS
Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112 Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112
3
Combining conditions (AND, OR and NOT)
Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112 Warning: Undefined variable $lesson_type in /customers/f/6/9/vogueit.co.uk/httpd.www/wp-content/plugins/masterstudy-lms-learning-management-system/_core/stm-lms-templates/lesson/curriculum.php on line 112

Range names

Editing/deleting range names

Lesson is locked. Please Buy course to proceed.

Prev lesson
Complete
Next lesson