Vogue IT
Microsoft Excel (Advanced)
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
Advanced IF's
1
Revision of single IFs
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
Nesting =IF
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
IFS and =SWITCH
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
Lookup functions
1
Using VLOOKUP for continuous values
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

Advanced IF's

IFS and =SWITCH

Lesson is locked. Please Buy course to proceed.

Prev lesson
Complete
Next lesson