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
Microsoft Excel (Beginner)
£300
What is Prerequisite courses
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
Questions
{{ comment.replies_count }}
Send
Load More
My Question
Ask A Question
Add Comment
{{ message }}
Send
Back to all questions
Conditional formulae
Combining conditions (AND, OR and NOT)
Lesson is locked. Please Buy course to proceed.
Prev lesson
Complete
Ask A Question